Job Seekers, Please send resumes to resumes@hireitpeople.com

This position will be a member of a team but will need to work independently.  They will report to a Senior Architect/DBA but will require self-direction.  Job responsibilities will span ETL development and database modeling/development. 

Complete Description:

This position will be a member of a team but will need to work independently.  They will report to a Senior Architect/DBA but will require self-direction.  Job responsibilities will span ETL development and database modeling/development.  Advanced skills in writing complex Structured Query Language (SQL) queries are required. This candidate should be an expert in creating, modifying and maintaining SSIS packages which will be used to move data from source systems to the data warehouse backend. 

ETL developer that will make extensive use of data flow tasks that extracts large volumes of data from disparate data systems.  

•             Experience in interacting with customers regarding application requirements.

•             Strong business writing and interpersonal skills necessary for customer contact.

•             Proficient in development of SQL Server Integration Services (SSIS) packages.

•             Proficient using MS SQL 2005 or later and writing relational database queries and stored procedures using SQL.

•             Experience working on a large scale data warehouse implementation.

•             Experience in completing unit and system testing.

•             Addressing data quality issues;

•             Developing error checking and resolution routines;

Skills:

SQL Server Integration Services (SSIS) packages

Required 3 Years

ETL processes – internal/external sources

Required 3 Years

Strong experience with data transformation

Required 3 Years

SQL Server 2005

Required 1 Years

Experience in interacting with customers regarding application requirements

Required 3 Years

Developing error checking and resolution routines; Unit and system testing;

Required 1 Years

Convert other Databases to SQL

Highly desired

Load data to OLAP databases

Highly desired

Developing error checking and resolution routines; Unit and system testing;

Highly desired

Familiarity with eScholar CDW

Desired

Knowledge of and experience working with education data

Required