Data Engineer

Senior Snowflake Data Engineer

Hybrid Newark, NJ — 2 days/month onsite, Contract to Hire

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.

• 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‑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.

Mid‑Senior level

Contract

Information Technology

Hospitals and Health Care, Insurance, and Public Health