Senior Snowflake Engineer

Datavail

  • Remote - US
  • Remote
  • Senior level
  • 7+ yrs experience
  • Data Engineering
  • Visa: not specified

The role in 30 seconds

As a Senior Snowflake Engineer at Datavail, you will leverage your expertise in data engineering and Snowflake to build and optimize data transformations, implement complex modeling techniques, and ensure data quality and integrity. This role involves developing robust processing logic, implementing patient/member matching, and creating detailed audit trails to support healthcare data initiatives.

Is this role a fit for you?

The backgrounds this role is most likely to hire from, as RoleStack reads the posting.

Strong match

  • Data platform / ML pipeline
  • B2B infrastructure / API / developer tools
  • B2B enterprise platform / workflow software

Workable stretch

  • Internal tooling / back-office systems
  • E-commerce, Retail & Consumer Goods

Harder transition

  • B2C consumer-facing application
  • Creator / builder / self-serve tool

Industry: Healthcare & Life Sciences. See your personal match score

What they're really screening for

Must-haves

  • CORE 7+ years in data engineering, data warehousing or analytics engineering with strong recent Snowflake delivery.
  • CORE Advanced Snowflake SQL, query tuning and production troubleshooting.
  • CORE Strong dimensional modeling implementation, including facts, dimensions, surrogate keys and SCD Type 2.
  • PLUS Experience with source-to-target mappings, complex business rules, incremental processing and reconciliation.
  • PLUS Hands-on data-quality checks, audit/control logging, error handling, Git, testing and deployment.
  • CORE Healthcare payer/provider, MPI or member identity experience.
  • CORE Build and optimize Snowflake SQL transformations across staging, curated and conformed layers.
  • PLUS Implement tables, views and transformation logic from approved models and source-to-target mappings.
  • PLUS Develop restartable, testable and supportable processing with auditability and error handling.
  • CORE Implement patient/member matching logic, crosswalks and exceptions for duplicate, unmatched or conflicting records.

Nice-to-haves

  • CORE Healthcare payer/provider, MPI or member identity experience.

Résumé keywords for this role

Terms the posting stresses. Include the ones you can honestly back up.

Tools & technologies

  • Snowflake
  • SQL
  • Git

Concepts & phrases

  • Senior Snowflake Engineer
  • data engineering
  • data warehousing
  • analytics engineering
  • Snowflake delivery
  • Advanced Snowflake SQL
  • query tuning
  • production troubleshooting
  • dimensional modeling implementation
  • facts, dimensions
  • surrogate keys
  • SCD Type 2
  • source-to-target mappings
  • complex business rules
  • incremental processing

Words that count as the same thing: "MPI" ≈ Master Patient Index, Master Person Index · "SCD Type 2" ≈ Slowly Changing Dimension Type 2, Dimensional Modeling History

Check my résumé against these keywords

Hiring at Datavail

Open senior roles RoleStack tracks right now, posted in the last 30 days.

Full job description from Datavail

From Datavail's posting. View the original

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.

Show full description Show less

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

FAQ

How much experience do you need?

The posting asks for 7+ years in data engineering. It is a senior-level role.

Does Datavail sponsor visas for this role?

The posting does not say whether visa sponsorship is available. Ask the recruiter before you apply.

Is this role remote?

It is a remote role.

What tools and technologies does the posting mention?

Snowflake, SQL, Git.