Description

You will own the design, development, and optimization of ETL pipelines and data warehouse loads.

This role is on-site.

Responsibilities

• Design and develop complex SQL queries, stored procedures, functions, and views.
• Build and maintain data ingestion, cleansing, transformation, and transfer workflows using SSIS and SQL.
• Identify and resolve technical issues in data pipelines and data warehouse loads.
• Analyze stakeholder needs to determine optimal data solutions and communicate findings.

Required Skills

• 8+ years of experience in ETL development.
• Expert proficiency with Microsoft SQL Server 2019 and above, including database management.
• Demonstrated experience using Microsoft SSIS to create and deploy ETL packages.
• Strong T-SQL skills for writing and troubleshooting stored procedures, views, and functions.
• Deep understanding of data warehousing concepts and data models (normalized, star, snowflake).
• Strong SQL coding and performance optimization experience for data queries.
• Experience with Azure DevOps and CI/CD pipelines for deployments.
• Familiarity with data structures and formats, specifically JSON and XML, and SSIS Scripting.
• Bachelor's degree required.

Key Skills

Education

Bachelor's degree