Job Details

This is a REPOST of #128031, #128748 and #129720.

Please do not submit the same candidates. This repost is open to nationwide candidates and does not require relocation to WI. Candidates MUST have Alteryx experience related to ETL, not just Alteryx experience based in data prep. The manager is also looking for candidates with strong and recent SQL skills. Candidates will be required to complete an SQL exercise when they interview with ETF and will need to answer very detailed questions regarding their background with Alteryx.

The State of Wisconsin is looking for 1 Data Warehouse Developer IIIs.

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

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

• 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

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

• 1-2 rounds via Microsoft Teams.

• 06/30/2024, likely to extend.

• This position can work 100% remote or in the office.
• No WI residency required. Open to nationwide candidates.