Description

You will design and develop data warehouse solutions within the Azure and Snowflake ecosystems.

Responsibilities

• Design and implement data warehouse architectures using dimensional modeling.
• Lead walkthroughs of design documents and collect technical requirements.
• Analyze existing SSIS code for improvements, enhancements, and conversions.
• Execute data warehouse tasks independently from requirements to delivery.
• Troubleshoot complex data integration issues and implement business transformation rules.

Required Skills

• 10+ years of full Software Development Life Cycle (SDLC) experience.
• 7+ years of experience with ETL tools implementing complex transformation rules.
• 5+ years of experience working on data warehouse projects using dimensional modeling.
• 3+ years of practical experience writing complex SQL queries.
• 3+ years of experience with ADF, SSIS, Talend, or Matillion.
• 2+ years of experience implementing and supporting DW on a cloud platform.
• Hands-on experience with Snowflake and the Azure Cloud Platform.
• Bachelor’s Degree in Information Technology, Computer Science, or a related field.

Preferred Skills

• Experience with Talend, Fivetran, dbt, or Matillion.
• Experience using SAP ERP as a source system.

Key Skills

Education

Bachelor s Degree