Logo for Datavail

Senior Snowflake Engineer

Role overview

Summary

This role focuses on delivering advanced Snowflake solutions for data engineering and analytics. You will work on building and optimizing SQL transformations while ensuring data quality and compliance with business rules, serving the healthcare sector.

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.
  • Strong dimensional modeling implementation, including facts, dimensions, surrogate keys and SCD Type 2.
  • Experience with source-to-target mappings, complex business rules, incremental processing and reconciliation.
  • Preferred: Healthcare payer/provider, MPI or member identity experience.

Responsibilities

  • 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.
  • Troubleshoot defects, maintain technical documentation and participate in reviews, planning and client demonstrations.

Key facts

Hard skills

Other skills

  • Problem Solving
  • Communication
  • Teamwork

About the company

Datavail logo

Datavail

  • IT Services & Consulting
  • 1,001–5,000
Datavail is a proven technology consulting, implementation, and managed services partner headquartered in Boulder, Colorado. Our world-class tech-enabled delivery platform enables us to provide an extensive solutions portfolio, including database management, analytics, application development, cloud infrastructure, and enterprise applications consulting — on-premises and in the cloud. With tens of thousands of hours of experience, our goal is to enable our clients to build modern, data-driven organizations that scale. Datavail maintains strong partnerships with leading technology companies to help our clients leverage the best-fit platform to optimize outcomes. In addition, we have poured over $25 million in R&D to bring world-class systems and application monitoring tools to the market. We seek to leverage the greatest that technology and talent have to offer to simplify and operationalize the IT systems organizations use to manage their most valuable data. We select the best across the globe so we can implement complex solutions for top brands as well as small-to-midsize organizations. Our passionate team of 1200+ certified, cloud-focused consultants deliver industry-focused solutions to 500+ customers with an average lifespan of 7+ years. These committed tech professionals help our clients jump-start their projects, improve time to value & reduce the risk for the core industries that we serve. Our Technology Alliances: Datavail has leading partnerships with AWS, Microsoft, Oracle, Google, Maria DB, Mongo DB, MySQL and can provide 24×7 managed services for all leading database and applications environments including: · AWS · Azure · Oracle · MongoDB · SQL Server · Db2 · PostgreSQL · MySQL · Cassandra · Hadoop · MariaDB · Oracle E-Business Suite (EBS)/ Oracle PeopleSoft/ Oracle Hyperion technologies · Oracle Enterprise Resource Planning (ERP) and Enterprise Performance Management (EPM) technologies · Oracle Analytics & Business Intelligence tech.

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

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.

  • Strong dimensional modeling implementation, including facts, dimensions, surrogate keys and SCD Type 2.

  • 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.

Related jobs

See all Snowflake Developer jobs

Other jobs at Datavail