POSITION TITLE:      Data Analyst/ETL Specialist



PRIMARY FUNCTION:    This is a full-time position that will design, develop, implement and support our K-12 data integration solutions and data integration utilities.  



CLASSIFICATIONS:    Professional – Exempt



REPORTS TO:          Director of Research and Development            



MAJOR DUTIES AND RESPONSIBILITIES:

 

This position will work with Product Specialists, our customers and other software developers to maintain and enhance our products and services.



Design, develop, implement and maintain ETL (extract, transform, load) processes to extract data from Student Information Systems, assessment systems and other customer data sources and convert extracted data into formats required by our learning solutions

Troubleshoot and analyze complex production problems related to source data

Ensure data integrity and accuracy

Conduct root cause analysis and resolve production problems and data issues

Write stored procedures for loading data and generating reports

Design, develop, implement, and maintain web (and desktop) based solutions to enhance and monitor the ETL processes for collecting data, staging data, cleansing data, standardizing data, and publishing data into our learning solutions

Recommend changes/enhancements to resolve recurring production incidents

Create and maintain technical documentation

Research and remain up-to-date on current data extract, transform and load technologies



Important Notice:  This job description is not an exclusive or exhaustive list of all job functions that a team member in this position may be asked to perform.  Duties and responsibilities can be changed, expanded, reduced or delegated by management to meet the business needs of the organization.



JOB QUALIFICATIONS:

Solid understanding of data, database structures, data warehousing concepts and data modeling

Experience with school district data

Experience with Microsoft SQL Server 2012 Enterprise Edition including Microsoft SSIS

Experience working with spreadsheet applications to assist in importing data

Programming experience using C# and Microsoft Visual Studio

Strong problem-solving skills

Ability to manage multiple competing tasks at the same time



EDUCATION:    Bachelor’s degree in MIS or related field required.  Additional technology related experience may be used in lieu of higher education (two years of experience in lieu of each year of higher education).



EXPERIENCE:    Experience working with data stored in a relational database environment.  Minimum of four years’ experience or equivalent proficiency with SQL database technology.