Data Engineer

JOB DESCRIPTION — 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.

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

🎯 Required Skills

• 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).
• Healthcare data experience strongly preferred.
• Cloud engineering experience (AWS or Azure).

✨ 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).