Data Engineer
Core
Design and maintain a centralized cloud data lakehouse to serve as the single source of truth for clinical analytics, AI initiatives, and business intelligence by ingesting and transforming EHR and operational data.
Role type
Senior Data Engineer (Healthcare)
Builds
Centralized Azure ADLS Gen2/Databricks/Synapse data lakehouse and Salesforce Health Cloud integration
Domain
Healthcare / Cloud Data Engineering
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Cloud data architecture (Azure ADLS Gen2, Databricks, Synapse), Enterprise ETL (Informatica, Azure Data Factory), Data modeling (ER/3NF, Star/Snowflake/Medallion), Streaming pipelines (Kafka, Spark Streaming), SQL (complex joins, CTEs, window functions), Python (Pandas, PySpark), Data security (masking, encryption, PHI compliance)
Preferred skills
Salesforce data structures (SOQL, Bulk API), MuleSoft, dbt, Legacy system migration (Epic, OLTP stores)
Technologies
Azure ADLS Gen2, Databricks, Synapse, Informatica PowerCenter/IDMC, Azure Data Factory, Kafka, Spark Streaming, Salesforce Health Cloud, MuleSoft, dbt, Python, Pandas, PySpark, SQLAlchemy
Responsibilities
Design and deploy centralized data lake architectures; Create batch and real-time ETL/ELT flows for EHR and telemetry data; Write complex migration scripts for legacy OLTP stores to cloud lakehouse; Build automated validation, deduplication, and security controls for PHI compliance; Transform HL7, FHIR, and EDI messages into canonical schemas; Design robust data models for both OLTP and OLAP analytics
Seniority
Mid-Senior, hands-on IC