(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.

Snowflake Schema, Ecosystems, Snowflake Schema, Healthcare, Data Analysis, Customer/Client Research, Metadata, Data Structures, Data Modeling, Data Quality, * 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