Snowflake Data Engineer (HL7 / Healthcare Data)

Job Role: Snowflake Data Engineer (HL7 / Healthcare Data) Remote USA Role Overview Job Description – Snowflake Data Engineer (HL7 / Healthcare Data) • Design and implement Snowflake-based data platform using Medallion Architecture • Work on HL7, DICOM, and SQL Server data pipelines Skill Snowflake – 5/5 MS SQL – 5/5 • Net – 5/5 Healthcare Background(hl7) : 3/5 Required Skills • Strong experience in Snowflake (Medallion Architecture) • Expertise in SQL Server (Schema, SPs, Jobs, Performance tuning) • Knowledge of HL7 data structures & healthcare workflows • Experience in ETL/ELT tools (ADF, Airflow, etc.) • Data modeling (Dimensional / Star Schema) • Handling semi-structured data (JSON/VARIANT) Key Responsibilities • Gather requirements and analyze existing HL7 → SQL Server → ETL workflows • Design Bronze, Silver, Gold layers in Snowflake • Build data ingestion pipelines for HL7 messages (ADT, ORM, ORU) • Parse and map HL7 data into structured relational models • Perform data transformation, cleansing, and normalization • Reverse engineer SQL Server databases (tables, SPs, jobs, dependencies) • Migrate ETL and batch jobs to Snowflake (Tasks/Streams/ADF/Airflow) • Develop data models (fact & dimension tables) for analytics • Ensure data quality, lineage, and governance • Implement scheduling, monitoring, and performance optimization Good to Have • DICOM data exposure • Real-time streaming (Kafka/Event Hub) • Healthcare domain experience • Data governance & security (HIPAA awareness) Deliverables • Data architecture design • HL7-to-Snowflake mapping documentation • Pipeline implementations • SQL Server reverse engineering artifacts • Reporting-ready data models Skills: healthcare,snowflake,etl,hl7