Data Warehouse

Codetech•Madison, WI
•Remote

About The Position

The Department of Employee Trust Funds (ETF) has an immediate opening for a Data Engineer to participate in its Data Management Program. The role supports ETF’s goal of becoming a more data-literate and data-driven organization. The Data Engineer will work on a small, collaborative team that uses agile practices to deliver value to business partners. Candidates must be Wisconsin residents or be willing to relocate to Wisconsin at their own expense before starting. The position can be performed 100% remotely from within Wisconsin.

Requirements

  • Six years of experience gathering requirements and developing technical specifications for ETL.
  • Six years of experience using ETL tools to design ETL jobs; two years with Alteryx is preferred.
  • Six years of experience developing data loads, including incremental, history/full, and survivorship-rule loads.
  • Four years of experience implementing change data capture (CDC).
  • Six years of experience testing and debugging ETL.
  • Six years of experience developing complex SQL.
  • Two years of experience scheduling ETL jobs.
  • Two years of experience loading data warehouses using ETL tools.
  • Experience managing multiple ETL tools.
  • Experience with data quality tools and frameworks.
  • Experience using source code version-control software.
  • Ability to mentor others on ETL development and manage multiple concurrent projects and tasks.
  • Strong interpersonal skills, including communication, mentoring, collaboration, and team building.
  • Must reside in Wisconsin or be willing to relocate to Wisconsin at personal expense before starting.

Nice To Haves

  • Two years of experience with Alteryx.

Responsibilities

  • Gather requirements and develop technical specifications for ETL.
  • Design ETL jobs using ETL tools and develop incremental, history/full, and survivorship-rule data loads.
  • Implement change data capture (CDC).
  • Test and debug ETL processes.
  • Develop complex SQL.
  • Schedule ETL jobs and load data warehouses using ETL tools.
  • Manage multiple ETL tools.
  • Work with data quality tools and frameworks.
  • Use source code version-control software.
  • Mentor others in ETL development.
  • Manage multiple concurrent projects and tasks.
  • Communicate, mentor, collaborate, and contribute to team building.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service