Key Skills: Senior Snowflake Engineer

Datavail; Boulder (CO); Remote; USD 120,000 - 180,000; Full time

Job summary

Datavail is seeking a Senior Snowflake Engineer to join our data management team, focusing on delivering scalable Snowflake-based data pipelines and analytics solutions. The role requires advanced Snowflake SQL, complex transformations, and strong production troubleshooting to ensure reliable data delivery.

Remote work with potential on-site collaboration in Boulder, CO. 7+ years of data engineering experience and hands-on development of end-to-end data flows are expected, along with Git-based

Qualifications

• 7+ years in data engineering, data warehousing or analytics engineering with strong recent Snowflake delivery.
• Advanced Snowflake SQL, layered transformations, query tuning and production troubleshooting.
• Experience with source-to-target mappings, complex business rules, incremental processing and reconciliation.
• Hands-on data-quality checks, audit/control logging, error handling, Git, testing and deployment.

Responsibilities

• Lead Snowflake development across staging, curated and conformed data layers.
• Build and optimize Snowflake SQL transformations for robust data pipelines.
• Develop restartable, testable and auditable processing with error handling.

Skills

Snowflake

Data engineering

ETL

Tools

Git

Job description

Datavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner.

Job Description

Title: Senior Snowflake Engineer

Location: Remote

Duration: 3 Month

Job Responsibilities:

7+ years in data engineering, data warehousing or analytics engineering with strong recent Snowflake delivery.

Advanced Snowflake SQL, layered transformations, query tuning and production troubleshooting.

Experience with source-to-target mappings, complex business rules, incremental processing and reconciliation.

Hands-on data-quality checks, audit/control logging, error handling, Git, testing and deployment.

Healthcare payer/provider, MPI or member identity experience preferred.

Build and optimize Snowflake SQL transformations across staging, curated and conformed layers.

Implement tables, views and transformation logic from approved models and source-to-target mappings.

Develop restartable, testable and supportable processing with auditability and error handling.

Implement patient/member matching logic, crosswalks and exceptions for duplicate, unmatched or conflicting records.

Build SCD Type 2 history, member-month outputs and current-state models.

Implement payer attribution across payer/plan, provider networks, PCPs and clinics and preserve monthly history.

Reconcile modeled attribution to source rosters and retain discrepancies and unassigned members.

Automate row-count, null, datatype, referential-integrity and schema-drift checks.

Build audit, balance and control logging, metrics, alerting and reconciliation evidence.

Troubleshoot defects, maintain technical documentation and participate in reviews, planning and client demonstrations.

About the Team

Datavail's Data Management and Analytics practice is made up of experts who provide a variety of data services including initial consulting and development, designing and building complete data systems, as well as ongoing support and management of database, data warehouse, data lake, data integration, and virtualization and reporting environments. Datavail's team is comprised of not just excellent BI & analytics consultants, but great people as well. Datavail's data intelligence consultants are experienced, knowledgeable and certified in the best in breed BI and analytics software applications and technologies. We ascertain your business objectives, goals and requirements, assess your environment, and recommend the tools which best fit your unique situation. Our proven methodology can help your project succeed, regardless of stage. With the combination of a proven delivery model and top-notch experience ensures that Datavail will remain the Data Management experts on demand you desire. Datavail's flexible and client focused services always add value to your organization.

Job Info

• Job Identification 1999
• Job Category Technical
• Posting Date 11/07/2026, 02:28 PM
• Locations 4770, Baseline Rd., Boulder, CO, 80303, US (Remote)