Data Engineer - Snowflake

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 ResponsibilitiesDesign 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 SkillsSenior-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 SkillsExperience implementing RBAC & data security frameworks.Hands-on data modeling experience (dimensional + relational).Exposure to healthcare standards (FHIR is a plus, but not required).