Employer Active
- USA
Not Disclosed
Salary Not Disclosed
1 Vacancy
Senior ETL Developer
Chicago IL
Long Term Contract
Local to Chicago candidates only W2 only.
The Senior ETL Developer will be held accountable for the following responsibilities:
Maintain and Manage the existing CPS Enterprise Data Warehouse and ODS builds.
Model extensions to the existing Data Warehouse
Builds ETL components according to ETL specifications. Code must address performance
dependency auditing error handling and data quality issues.
Support post deployment by debugging fixing and participating in maintenance.
Create reports to meet business requirements and address data needs.
Create Dashboard pages and metrics within CPS custom dashboard solution.
Responsible for data integrity as well as the quality of data within Dashboard presentation layer.
Participate in code reviews and ensure that all solutions are aligned to predefined architectural
specifications; identify/troubleshoot coderelated issues; and review and provide feedback to
the final user documentation.
Read and understand business requirements write functional requirements develop detailed
technical designs and build / unit / system test ETL code.
In order to be successful and achieve the above responsibilities the Senior Business Intelligence
Analyst must possess the following qualifications:
Type of Education Required:
Bachelors degree in computer science or related field
Type of Experience and Number of Years:
10 years of Enterprise Data Warehouse experience
5 years of experience with an ETL product (SSIS Ab Initio etc) in a development role
(administrative knowledge a plus)
Good knowledge of data modeling/Star Schema
Strong ANSI SQL expertise
REST APIs development experience
Experience with C# Python Java
3 years of experience with Unix and Shell Scripting
Experience with latest releases of SQL Server
Experience with Azure DevOps
Ability to develop and organize highquality documentation
Experience with at least one job scheduler
Experience with CPS or a large school district
Knowledge Skills and Abilities:
Strong written and oral communications skills.
Proven ability and initiative to learn and research new concepts ideas and technologies quickly.
Strong systems/process orientation with demonstrated analytical thinking organizational skills
and problem solving skills.
Ability to work in a teamoriented collaborative environment.
Ability to quickly pick up new tools and technologies.
Willingness and ability to train and teach others.
Ability to facilitate meetings and follow up with resulting action items.
Ability to prioritize and execute tasks in a highpressure environment.
Strong presentation and interpersonal skills.
Ability to effectively move forward on tasks even with ambiguous or changing requirements.
Full Time