Snowflake Data Engineer

TechDigital Group; North Wales (Montgomery County); On-site; USD 100,000 - 130,000; Full time

Job summary

TechDigital Group is looking for a Snowflake Data Engineer with a strong background in healthcare data to design and implement a data platform utilizing the Medallion Architecture. You will gather requirements, analyze HL7 workflows, and migrate existing ETL jobs to Snowflake.

The ideal candidate should have extensive experience with Snowflake and SQL Server, along with knowledge of HL7 data and ETL tools like ADF and Airflow.

Qualifications

• Strong experience in Snowflake with Medallion Architecture.
• Expertise in SQL Server schema and performance tuning.
• Knowledge of HL7 data structures and healthcare workflows.

Responsibilities

• Design and implement a Snowflake-based data platform.
• Gather requirements and analyze existing HL7 data workflows.
• Migrate ETL and batch jobs to Snowflake.

Skills

Snowflake

SQL Server

.Net

Healthcare Background (HL7)

Tools

ETL Tools (ADF, Airflow)

Kafka

Job description

Snowflake Data Engineer (HL7 / Healthcare Data)

Role Overview

• Design and implement Snowflake-based data platform using Medallion Architecture
• Work on HL7, DICOM, and SQL Server data pipelines

Skills

• Snowflake
• Mssql
• .Net
• Healthcare Background (hl7)

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

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)

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