Datavail

Senior Snowflake Engineer

United States full-time Senior Salary not listed
full-time Senior level Technology & IT Curated
Sign in to apply Free account — we bring you straight back to this role.

About the role

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.

Originally posted on Himalayas

Interview prep

Walk in with sharper answers.

Use these suggested prompts to prepare. They are not questions supplied by the employer.

Senior
Technology & IT Data Analysis MySQL Remote Collaboration SQL Writing Senior level

Practice questions

  1. Tell us about work you have done that is close to the Senior Snowflake Engineer role.
  2. How would you approach your first 30 days at Datavail?
  3. Which of Data Analysis, MySQL and Remote Collaboration have you used recently, and what did it help you achieve?
  4. How have you led people, improved a process, or made a hard decision in a previous role?
  5. How do you handle busy days, changing priorities, or pressure at work?

Prepare before the call

  • A recent example that proves your experience with Data Analysis, MySQL and Remote Collaboration.
  • One short story with a problem, your action, and the result.
  • Two examples that show the strengths listed on your CV.
  • A clear reason why this role and company interest you.
  • Your availability, preferred work style, and salary expectations.

Ask them

  • What would success look like in the first 90 days?
  • What are the main problems this hire should help solve?
  • How does the team give feedback and measure good work?
  • What does a normal working week look like for this role?
Practice line

I am interested in the Senior Snowflake Engineer role at Datavail. My relevant experience is [your example], where I [your action] and achieved [your result].

Related jobs.

More roles from this company or category.