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
• 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)
• Implementing change data capture (CDC)
• Testing and debugging ETL.
• Developing complex SQL
• ETL job scheduling
• Loading data warehouses using ETL tools
• 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 Technologies:

• Alteryx
• SSIS
• SSRS
• SQL Server
• Tableau
• Semarchy
• Git; GitHub

Top Skills &; Years of 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 (should be recent experience)
• ETL job scheduling – 2 years
• Loading data warehouses using ETL tools – 2 years

Nice to Have:

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

Interview Process:

• 1-2 rounds via Microsoft Teams.

Job Type: Contract

Pay: $48.00 - $52.00 per hour

Experience:

• Alteryx: 2 years (Required)
• CDC: 2 years (Required)
• SQL: 2 years (Required)

Work Location: Remote