SSIS ETL / Data Warehouse Developer

Skills

Description

The Canopy Health data team is looking for an experienced senior developer to join our team on a contract basis. This role will focus on addressing our complex ETL (Extract, Transform, Load) needs, ensuring seamless data integration across our systems. We are looking for a highly skilled individual with deep expertise in SQL who can manage large-scale data processes, optimize performance, and support the overall data architecture. This senior-level position requires a strategic thinker with a proven ETL development and database management track record.

Responsibilities

• Must have solid knowledge of the ETL process, Change Data Capture (CDC), and data warehouse concepts.
• Expertise in creating and deploying Microsoft SQL Server Integration Services (SSIS) packages and Microsoft Azure Data Factory (ADF) pipelines to load data into a data warehouse and data mart tables.
• Create and maintain ETL technical specifications, ETL process, and ETL testing documents.
• Strong in writing complex SQL queries, stored procedures, triggers, and functions to automate ETL load.
• Working experience with Slowly Changing Dimensions (SCD) type-2 tables and developing ETL packages to load and maintain consistent historical data from heterogeneous source systems.
• Strong experience with various data quality transformations to enrich data and load data warehouse and data mart tables.
• Create and maintain ETL technical specifications, ETL process, and ETL testing documents.
• Working experience in ETL testing for dimensional and fact tables.
• Working experience in scheduling, monitoring, troubleshooting, and resolving ETL jobs in non-prod and prod environments.
• Have excellent working experience with Microsoft SQL Server, SSIS tool, SQL Server Management Studio (SSMS), Azure SQL Database, and Azure Data Factory.
• Collaborate with business analysts, database administrators, architects, and Canopy Health stakeholders to gather requirements and design solutions. Work with the BI team to support business intelligence and reporting through the data warehouse
• Follow industry regulations and organizational policies for data governance, including compliance with HIPAA.
• Preference for experience with healthcare clinical and health plan data.