Data Engineer - Snowflake

JOB DESCRIPTION — Senior Snowflake Data Engineer
(Hybrid Newark, NJ — 2 days/month onsite, with flexibility to come in as needed)
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.
Senior Snowflake Data Engineer 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.

Senior Snowflake Data Engineer Required Skills

• Senior-level experience with Snowflake (3–6+ years minimum).
• Deep SQL optimization + warehouse tuning expertise.
• Experience implementing Snowpark, Snowpipe, Streams, Tasks, or Dynamic Tables.
• Strong understanding of micro-partitioning and performance patterns.
• Experience with ETL orchestration tools (Airflow, ADF, DBT preferred).
• Healthcare data experience required.
• Cloud engineering experience (AWS or Azure).

Senior Snowflake Data Engineer Bonus Skills

• Experience implementing RBAC & data security frameworks.
• Hands-on data modeling experience (dimensional + relational).
• Exposure to healthcare standards (FHIR is a plus, but not required).

 #Contech