Contech Systems Inc. · 1 month ago
Data Engineer - Snowflake
Contech Systems Inc. is hiring a Senior Snowflake Data Engineer to architect, design, and optimize Snowflake-based data solutions for their healthcare clients. The role involves building models, pipelines, and scalable architectures to enhance analytics and reporting capabilities.
Software
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
Qualification
Required
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)
Cloud engineering experience (AWS or Azure)
Preferred
Healthcare data experience strongly preferred
Experience implementing RBAC & data security frameworks
Hands-on data modeling experience (dimensional + relational)
Exposure to healthcare standards (FHIR is a plus, but not required)
Company
Contech Systems Inc.
Since 1998, Contech Systems delivered staffing solutions for Fortune 500 companies.
H1B Sponsorship
Contech Systems Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (1)
2022 (1)
2021 (1)
2020 (6)
Funding
Current Stage
Growth StageCompany data provided by crunchbase