Senior Snowflake Engineer

🔥 29 minutes ago

🇺🇸 United States – Remote

⏰ Full Time

🟠 Senior

👷🏻‍♀️ Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

👻 Ghost score 10%

What it means: the chance that no one is really hiring for this job.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Datavail

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

Founded 2007

💼 Consulting

🏥 Healthcare

📦 Logistics

Consulting • Healthcare • Logistics

Datavail is a comprehensive IT solutions provider specializing in analytics, application development, database administration, and cloud services. Their offerings span advanced analytics consulting, cloud migration and management, and application modernization, ensuring clients can leverage their data for competitive advantage. Datavail focuses on delivering tailored solutions to enhance data management and operational efficiency across various sectors.

📋 Description

• 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

🎯 Requirements

• 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

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume