Data Warehouse Developer III - Rebid

Top Required Skills & Years of Experience:

a. Developing complex SQL - 6 years

b. Gathering requirements and developing technical specifications for ETL – 6 years

c. Using ETL tools to design ETL jobs (ETL 6 years, preferably 2 years of with Alteryx)

d. Developing various types of data loads (e.g. incremental, history/full, survivorship rules) – 6 years

e. Implementing change data capture (CDC) – 4 years

f. Testing and debugging ETL – 6 years

g. ETL job scheduling – 2 years

h. Loading data warehouses using ETL tools – 2 years (preferably with SQL Server)

Nice to Have Skills:

a. Data integration for invoicing, billing, or payment systems HIGHLY PREFERRED – 2 years (years may not align with their system, but it’s included in job description anyway)

b. Management of multiple ETL tools

c. Experience with data quality tools and frameworks - preferred

d. Using source code version control software - preferred

Interview Process: 1-2 rounds via Microsoft Teams.

Duration: 6/30/2027, likely to extend.

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

Job Description

We have an immediate opening at the Department of Employee Trust Funds (ETF) for a Data Engineer to participate in

data integration and data warehousing for a new Invoicing system. This is part of a larger effort to modernize our core

business systems. Prior experience with invoicing, billing, or payment systems is preferred. The duration of this position

is expected to be 15 months. 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 (preferably with SQL Server)

• Data integration for invoicing, billing, or payment systems – 2 years preferred

• Management of multiple ETL tools

• Experience with data quality tools and frameworks

• Using source code version control software – github preferred

• Mentoring to others on ETL development

• Managing multiple, concurrent projects and tasks

• Having strong interpersonal skills including communication, mentoring, collaborating, and team building