Data Warehouse Developer III

Summary

Join our team as a Data Warehouse Developer III and contribute to our data management program. This remote position in Madison, WI, is a 1+ month contract. You will work collaboratively on a small team using agile practices. The role involves designing and developing ETL jobs, implementing change data capture, and ensuring data quality. Experience with various ETL tools and SQL is essential. Mentoring junior team members is also a key aspect of this position.

Requirements

• Have 6 years of ETL experience, preferably 2 years with Alteryx
• Possess experience with data quality tools and frameworks
• Be proficient in using source code version control software
• Have strong interpersonal skills, including communication, mentoring, collaboration, and team building

Responsibilities

• Gather requirements and develop technical specifications for ETL
• Use ETL tools to design ETL jobs
• Develop various types of data loads (e.g., incremental, history/full, survivorship rules)
• Implement change data capture (CDC)
• Test and debug ETL
• Develop complex SQL
• Perform ETL job scheduling
• Manage multiple ETL tools
• Load data warehouses using ETL tools
• Mentor others on ETL development
• Manage multiple, concurrent projects and tasks

Preferred Qualifications

• Manage multiple ETL tools
• Have experience with data quality tools and frameworks
• Use source code version control software