1.20. Data Warehouse Developer

Focused HR Solutions; Madison (WI); Remote; USD 80,000 - 110,000; Full time

Job summary

Focused HR Solutions is seeking a remote Data Warehouse Developer for a 13-month position in Madison, WI. The ideal candidate will have strong skills in Alteryx for ETL processes and recent experience with SQL. Responsibilities include gathering requirements, developing data loads, and ensuring the quality of ETL processes. This role offers the potential for extension and is suitable for experienced professionals in the data field.

Qualifications

• 6 years of ETL experience, preferably 2 years with Alteryx.
• Recent experience developing complex SQL.
• Experience in implementing change data capture and job scheduling.

Responsibilities

• Gathering requirements and designing ETL jobs.
• Developing various types of data loads for the data warehouse.
• Testing and debugging ETL processes.

Skills

Alteryx experience related to ETL

Development of technical specifications for ETL

Testing and debugging ETL

Strong SQL skills

Tools

ETL tools

Data quality tools and frameworks

Source code version control software

Job description

100% remote.

Our direct client has an opening for an Data Warehouse Developer 129720.

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

Alteryx experience related to ETL, as many had experience based more on data prep. The manager is also looking for 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 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.

By replying to this job advertisement, I agree I want to receive additional job advertisements from Focused HR Solutions, including email, phone and mail to the contact information I am submitting. I consent to Focused HR Solutions, its affiliates, third parties and partners processing my personal data for these purposes and as described in the Privacy Policy. I understand that I can withdraw my consent at anytime.

FHR