Qualifications

• Bachelor's degree in Computer Science, Software Engineering, Data Analytics, or a related field.
• 3-7 years of practical data engineering experience, especially in data migration and cloud architectures.
• Proficient in ER diagramming and various database modeling techniques (3NF for OLTP, Star/Snowflake for OLAP).
• Experience with ETL platforms like Informatica and Azure Data Factory for data extraction and transformation.
• Familiarity with Azure Data Services including ADLS Gen2, Synapse, and Databricks, plus streaming technologies such as Event Hubs and Kafka.
• Knowledge of Salesforce data structures and experience using SOQL and Salesforce Bulk API.
• Advanced SQL proficiency for database queries, schema design, and performance optimization.

Responsibilities

• Design, deploy, and manage a centralized Azure ADLS Gen2 or Snowflake data lake to act as the single source of truth.
• Create both batch and real-time ETL/ELT processes for ingesting EHR data and operational telemetry using technologies like Kafka and Spark Streaming.
• Develop and execute complex migration scripts with tools like Informatica and Azure Data Factory to transition data from various sources into the lakehouse.
• Implement automated processes for validation, deduplication, and encryption to ensure data integrity and compliance with PHI regulations.
• Build high-performance data pipelines that synchronize data with the Salesforce Health Cloud using various integration tools.
• Transform healthcare data standards (HL7, FHIR, EDI) into organized formats suitable for storage and analysis.
• Design comprehensive data models for various analytics needs, including OLTP and OLAP systems.

Benefits

• Opportunities for professional development and continuous learning.
• Engagement in high-impact projects, contributing to healthcare data management innovations.
• Collaboration within a dynamic team focused on data-driven healthcare solutions.