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