1.20. Data Warehouse Developer

Focused HR Solutions; Madison (WI); Remote; USD 100,000 - 125,000; Full time

Job summary

An innovative company is seeking a skilled Data Warehouse Developer to join their remote team. This role focuses on leveraging Alteryx for ETL processes, requiring strong SQL skills and extensive experience in data load development. You will be responsible for gathering requirements, developing technical specifications, and implementing change data capture. This position offers the chance to work on exciting data projects while enjoying the flexibility of a fully remote environment. If you are passionate about data and eager to make an impact, this opportunity is perfect for you.

Qualifications

• 6+ years of ETL experience, particularly with Alteryx.
• Strong SQL skills with recent experience required.

Responsibilities

• Gathering requirements and developing technical specifications for ETL.
• Testing, debugging, and scheduling ETL jobs effectively.

Skills

Alteryx experience related to ETL

SQL

ETL job scheduling

Testing and debugging ETL

Change data capture (CDC)

Data load development

Requirements gathering

Tools

ETL tools

Data quality tools

Source code version control software

Job description

100% remote.

Our direct client has an opening for a 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 is required, 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:

1. Alteryx experience related to ETL.
2. Gathering requirements and developing technical specifications for ETL – 6 years.
3. Using ETL tools to design ETL jobs (ETL 6 years, preferably 2 years with Alteryx).
4. Developing various types of data loads (e.g. incremental, history/full, survivorship rules) – 6 years.
5. Implementing change data capture (CDC) – 4 years.
6. Testing and debugging ETL – 6 years.
7. Developing complex SQL - 6 years (should be recent experience).
8. ETL job scheduling – 2 years.
9. Loading data warehouses using ETL tools – 2 years.

Nice to Have:

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