What are the responsibilities and job description for the Data Engineer position at Contech Systems Inc.?
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).
Salary : $80 - $90