Description

Lead the design and implementation of end-to-end ETL processes and data warehouse architectures.

Responsibilities

• Collaborate with business partners to translate requirements into technical ETL specifications.
• Design and develop ETL jobs using SSIS, SSRS, and Alteryx.
• Implement data loading strategies including incremental loads, full history, and survivorship rules.
• Integrate Change Data Capture (CDC) to optimize data acquisition.
• Schedule ETL workflows and manage data warehouse loading.

Required Skills

• 10+ years of database experience with 8+ years focused on ETL development.
• Expertise in complex SQL development and debugging.
• Hands-on experience with SSIS and SSRS.
• Proven ability to manage and develop ETL jobs using Alteryx.
• Strong understanding of the Data Life Cycle and data quality principles.
• Experience with data quality tools and frameworks.
• Proficiency with version control systems including Git and GitHub.
• Experience managing multiple ETL tools simultaneously.

Preferred Skills

• Experience using Alteryx for ETL development.

Key Skills

Education

Any Graduate