ETL Data Warehouse Developer ( Wisconsin Candidates only)

Summary: The ETL Data Warehouse Developer role focuses on gathering requirements, developing technical specifications, and designing ETL jobs using various tools, particularly Alteryx. The position requires extensive experience in data loading, change data capture, and SQL development. Candidates must also possess strong interpersonal skills and the ability to manage multiple projects concurrently. This role is specifically for candidates located in Wisconsin and offers a remote working arrangement.

Key Responsibilities:

• Gathering requirements and developing technical specifications for ETL
• Using ETL tools to design ETL jobs
• Developing various types of data loads (e.g. incremental, history/full, survivorship rules)
• Implementing change data capture (CDC)
• Testing and debugging ETL
• Developing complex SQL
• ETL job scheduling
• Loading data warehouses using ETL tools
• Management of multiple ETL tools
• Experience with data quality tools and frameworks
• Using source code version control software
• Mentoring others on ETL development
• Managing multiple, concurrent projects and tasks
• Having strong interpersonal skills including communication, mentoring, collaborating, and team building

Key Skills:

• 6 years of experience in gathering requirements and developing technical specifications for ETL
• 6 years of experience using ETL tools to design ETL jobs, preferably 2 years with Alteryx
• 6 years of experience developing various types of data loads
• 4 years of experience implementing change data capture (CDC)
• 6 years of experience testing and debugging ETL
• 6 years of experience developing complex SQL
• 2 years of experience in ETL job scheduling
• 2 years of experience loading data warehouses using ETL tools
• Management of multiple ETL tools
• Experience with data quality tools and frameworks
• Using source code version control software
• Strong interpersonal skills

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT