Snowflake Data Engineer
Shrive Technologies LLC
- Wausau, Wisconsin, United States
- Wausau, Wisconsin, United States
Über
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
#J-18808-Ljbffr
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klick auf „Jetzt Bewerben”, um deine Bewerbung direkt auf deren Website einzureichen.