Centers for Disease Control and Prevention (CDC), Data Collection, Data Management, Data Quality, Database Extract Transform and Load (ETL), Debugging Skills, Interpersonal Skills, Mentoring, Microsoft SQL Server, Requirements Management, SQL Databases, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Source Code/Configuration Management (SCM), Tableau, Team Building, Team Player
Position: Data Engineer
Location: Madison, WI
Duration: 03+ Month Contract
JOB DESCRIPTION
We have an immediate opening at the Department of Employee Trust Funds (ETF) for a strong Data Engineer to participate in our Data Management Program. Data is one of our most valuable assets and we strive to become a more data-literate and data-driven organization. This position will work on a small, collaborative team that uses agile practices to deliver value to our business partners.
Desired Experience
- Gathering requirements and developing technical specifications for ETL — 6 years
- Using ETL tools to design ETL jobs (ETL 6 years, preferably 2 years of with Alteryx)
- Developing various types of data loads (e.g. incremental, history/full, survivorship rules) — 6 years
- Implementing change data capture (CDC) — 4 years
- Testing and debugging ETL — 6 years
- Developing complex SQL - 6 years
- ETL job scheduling — 2 years
- Loading data warehouses using ETL tools — 2 years
- Management of multiple ETL tools
- Experience with data quality tools and frameworks
- Using source code version control software
- Mentoring to others on ETL development
- Managing multiple, concurrent projects and tasks
- Having strong interpersonal skills including communication, mentoring, collaborating, and team building
ETF Techno Indies
- Alteryx
- SSIS
- SSRS
- SQL Server
- Tableau
- Semarchy
- Git & GitHub
R
Revive Business Solutions