Data Engineer - Snowflake
Contech Systems
Newark, NJ
Apply
JOB DETAILS
SALARY
$75–$90 Per Hour
LOCATION
Newark, NJ
POSTED
30+ days ago
(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.
- 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).
- Experience implementing RBAC & data security frameworks.
- Hands-on data modeling experience (dimensional + relational).
- Exposure to healthcare standards (FHIR is a plus, but not required).
About the Company
C