Contech Systems Inc.
Senior Snowflake Data Engineer
Hybrid Newark, NJ — 2 days/month onsite, Contract to Hire
Overview We’re hiring a
Senior Snowflake Data Engineer
to architect, design, and optimize Snowflake-based data solutions powering analytics, reporting, and clinical insights across our client’s healthcare ecosystem. This isn’t a button‑click Snowflake admin role — this is true engineering, building models, pipelines, metadata patterns, performance frameworks, and scalable architectures.
Responsibilities
Design and develop ELT/ELT workflows for Snowflake data environments.
Build advanced Snowflake features:
Snowpipe, Streams, Tasks, Time Travel, Clustering , RBAC.
Model and optimize data structures for analytics and downstream consumers.
Implement data quality checks, lineage, validation frameworks, and governance.
Tune SQL, warehouse sizing, caching, and micro‑partition performance.
Collaborate with analytics, clinical, product, and architecture teams.
Troubleshoot ingestion, transformations, and warehouse performance issues.
Document architecture, data flows, patterns, and best practices.
Mentor junior Snowflake engineers as the team scales.
Qualifications
Senior‑level experience with
Snowflake
(3–6+ years minimum).
Deep SQL optimization + warehouse tuning expertise.
Experience implementing Snowpipe, Streams, Tasks, or Dynamic Tables.
Strong understanding of micro‑partitioning and performance patterns.
Experience with ETL orchestration tools (Airflow, ADF, DBT preferred).
Cloud engineering experience (AWS or Azure).
Experience implementing RBAC & data security frameworks.
Hands‑on data modeling experience (dimensional + relational).
Exposure to healthcare standards (FHIR is a plus, but not required).
Mentoring experience is a plus.
Seniority Level Mid‑Senior level
Employment Type Contract
Job Function Information Technology
Industries Hospitals and Health Care, Insurance, and Public Health
#J-18808-Ljbffr
Overview We’re hiring a
Senior Snowflake Data Engineer
to architect, design, and optimize Snowflake-based data solutions powering analytics, reporting, and clinical insights across our client’s healthcare ecosystem. This isn’t a button‑click Snowflake admin role — this is true engineering, building models, pipelines, metadata patterns, performance frameworks, and scalable architectures.
Responsibilities
Design and develop ELT/ELT workflows for Snowflake data environments.
Build advanced Snowflake features:
Snowpipe, Streams, Tasks, Time Travel, Clustering , RBAC.
Model and optimize data structures for analytics and downstream consumers.
Implement data quality checks, lineage, validation frameworks, and governance.
Tune SQL, warehouse sizing, caching, and micro‑partition performance.
Collaborate with analytics, clinical, product, and architecture teams.
Troubleshoot ingestion, transformations, and warehouse performance issues.
Document architecture, data flows, patterns, and best practices.
Mentor junior Snowflake engineers as the team scales.
Qualifications
Senior‑level experience with
Snowflake
(3–6+ years minimum).
Deep SQL optimization + warehouse tuning expertise.
Experience implementing Snowpipe, Streams, Tasks, or Dynamic Tables.
Strong understanding of micro‑partitioning and performance patterns.
Experience with ETL orchestration tools (Airflow, ADF, DBT preferred).
Cloud engineering experience (AWS or Azure).
Experience implementing RBAC & data security frameworks.
Hands‑on data modeling experience (dimensional + relational).
Exposure to healthcare standards (FHIR is a plus, but not required).
Mentoring experience is a plus.
Seniority Level Mid‑Senior level
Employment Type Contract
Job Function Information Technology
Industries Hospitals and Health Care, Insurance, and Public Health
#J-18808-Ljbffr