1.20. Data Warehouse Developer

Focused HR Solutions; Madison (WI); On-site; USD 80,000 - 100,000; Full time

Job summary

A recruitment agency seeks a remote Data Warehouse Developer for a contract role based in Madison, WI. The ideal candidate will have significant experience with ETL processes using Alteryx, as well as strong SQL skills. Responsibilities include gathering requirements, developing technical specifications, and testing ETL processes. Candidates should have a minimum of 6 years of relevant experience. This position may last up to 13 months with an option for extension.

Qualifications

• 6 years of experience in developing technical specifications for ETL.
• 6 years of experience in using ETL tools to design ETL jobs, preferably 2 years with Alteryx.
• 2 years of experience in loading data warehouses using ETL tools.

Skills

Alteryx experience related to ETL

Recent SQL skills

Gathering requirements

Testing and debugging ETL

Change data capture (CDC)

ETL job scheduling

Complex SQL development

Job description

100% remote.

Our direct client has an opening for a Data Warehouse Developer (ID: 129720).

This position is for up to 13 months with the option of extension, and the client is located in Madison, WI.

Alteryx experience related to ETL, with a focus on data prep, is required. The manager also seeks candidates with strong and recent SQL skills.

Top Skills & Years of Experience

• Alteryx experience related to ETL.
• Gathering requirements and developing technical specifications for ETL – 6 years.
• Using ETL tools to design ETL jobs (ETL 6 years, preferably 2 years 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.