Description

You will lead ETL development, data pipelines, and data warehouse loads.

Responsibilities

• Design, develop, and optimize complex SQL queries, stored procedures, functions, and views.
• Build and maintain workflows for data ingestion, cleansing, transformation, and transfer using SQL Server Integration Services (SSIS) and SQL.
• Work with team members to identify and resolve technical issues in a timely fashion.
• Analyze problems and communicate with stakeholders to assess needs and determine optimal solutions.

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