Sr. Data Integration Engineer
Core
Design, develop, and maintain data integration workflows that ingest partner and internal data from flat files, REST APIs, and direct database connections, transforming it into curated warehouse tables for reporting and operational systems.
Role type
Senior hands-on IC data integration engineer
Builds
Reusable, configuration-driven ingestion patterns and modernized data pipelines
Domain
Healthcare data integration and platform modernization
Deliverable
production ML models | product features
Required skills
Advanced T-SQL, Python, Git, data quality validation, idempotent pipeline design, HIPAA compliance, dimensional modeling, CI/CD for database projects
Preferred skills
Azure Data Factory, Microsoft Fabric, on-prem to cloud migration, data governance, healthcare/pharmacy domain knowledge
Technologies
Azure, Fabric, Git, JSON, XML, REST, SQL, pandas, Cursor, Flow, LESS
Responsibilities
Design and maintain data ingestion workflows from SFTP, APIs, and databases; develop T-SQL transformation logic; implement automated validation and quarantine for data quality; set up monitoring and alerting for pipeline status; investigate and resolve production data incidents; migrate integration workflows to modernized patterns; support AI/ML initiatives with reliable data pipelines; coordinate with partner technical contacts; provide off-hours support for critical failures.
Seniority
Senior, hands-on IC