Senior ETL Developer (SSIS)

The Senior ETL Developer is the primary owner of the organization's data integration platform, responsible for the reliability and ongoing modernization of a portfolio of SSIS packages, SQL Agent jobs, and supporting scripts that process healthcare data daily. The role operates against an existing, prioritized backlog and involves approximately 60% maintenance and 40% improvement work. This is a sole-owner position, not part of a team rotation.

Responsibilities

• Maintain the existing SSIS package and SQL Agent job portfolio; monitor, alert, and respond to overnight failures.
• Diagnose and resolve ETL failures end-to-end; document root cause and resolution for each incident.
• Tune and refactor existing packages and stored procedures for performance and reliability.
• Design and build new ETL workflows for new data feeds and file formats.
• Maintain version control discipline across the portfolio: Git, pull requests, and a defined deployment process.
• Write and maintain runbooks for every recurring job in the portfolio.
• Coordinate with the DBA, application engineers, and operations team on changes that affect downstream systems.

Required Qualifications

• 5 years building and supporting SSIS in production.
• Strong T-SQL: stored procedures, query plans, indexing, and performance tuning on SQL Server or Azure SQL.
• Working scripting fluency in C#, PowerShell, or Python.
• SQL Server Agent: scheduling, job steps, alerts, and failure handling.
• File-based integration patterns: flat files, CSV, fixed-width, XML, SFTP.
• Source control with Git or equivalent.

Preferred Qualifications

• Healthcare EDI (837, 835, 270/271) or other healthcare data experience.
• Azure Data Factory and related Azure data services.
• Experience modernizing legacy SSIS workloads onto cloud-native tooling.
• Experience working in a SOC 2 or HITRUST environment.