Data Warehouse Developer

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

1. Gathering requirements and developing technical specifications for ETL – 6 years
2. Using ETL tools to design ETL jobs (ETL 6 years, preferably 2 years with Alteryx)
3. Developing various types of data loads (e.g. incremental, history/full, survivorship rules) – 6 years
4. Implementing change data capture (CDC) – 4 years
5. Testing and debugging ETL – 6 years
6. Developing complex SQL - 6 years
7. ETL job scheduling – 2 years
8. Loading data warehouses using ETL tools – 2 years
9. Management of multiple ETL tools
10. Experience with data quality tools and frameworks
11. Using source code version control software
12. Mentoring others on ETL development
13. Managing multiple, concurrent projects and tasks
14. Having strong interpersonal skills including communication, mentoring, collaborating, and team building

ETF Technologies

1. Alteryx
2. SSIS
3. SSRS
4. SQL Server
5. Tableau
6. Semarchy
7. Git & GitHub

Requirements Top Skills & Years of Experience:

1. Gathering requirements and developing technical specifications for ETL – 6 years
2. Using ETL tools to design ETL jobs (ETL 6 years, preferably 2 years with Alteryx)
3. Developing various types of data loads (e.g. incremental, history/full, survivorship rules) – 6 years
4. Implementing change data capture (CDC) – 4 years
5. Testing and debugging ETL – 6 years
6. Developing complex SQL - 6 years
7. ETL job scheduling – 2 years
8. Loading data warehouses using ETL tools – 2 years

Nice to Have:

1. Management of multiple ETL tools
2. Experience with data quality tools and frameworks - preferred
3. Using source code version control software - preferred