W2 Only Snowflake Data Engineer (HL7 Healthcare Data) exp. Must- need 10+ Yrs profiles

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

Skill :
Snowflake 5/5
Mssql 5/5
.Net 5/5
Healthcare Background(hl7) : 3/5
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