Data Warehouse Developer

Introduction:

The Data Warehouse Developer will be responsible for gathering requirements, developing technical specifications, and designing ETL jobs using various tools. They will work on loading data warehouses, implementing change data capture, testing and debugging ETL processes, and managing multiple ETL tools.

Responsibilities:

• Gathering requirements and developing technical specifications for ETL - 6 years
• Designing ETL jobs using ETL tools (preferably with 2 years of experience 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 processes - 6 years
• Developing complex SQL - 6 years
• ETL job scheduling - 2 years
• Loading data warehouses using ETL tools (preferably with SQL Server) - 2 years
• Data integration for invoicing, billing, or payment systems - 2 years preferred
• Management of multiple ETL tools
• Experience with data quality tools and frameworks
• Using source code version control software (GitHub preferred)
• Mentoring others on ETL development
• Managing multiple, concurrent projects and tasks
• Strong interpersonal skills including communication, mentoring, collaborating, and team building

Requirements:

Required Skills:

• Gathering requirements and developing technical specifications for ETL - 6 years