Posted 1 week ago
Senior Snowflake Engineer
Datavail
Remote · United States 🇺🇸
- Remote
- Full Time
- Snowflake
- SQL
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.
Other jobs in United States
Customer Relations Representative
HCC Service Company, Inc. Carmel, Indiana, United States🇺🇸
Hybrid Full Time 1 hour ago
Senior Business Operations Analyst, NA P&C
HCC Service Company, Inc. New York City, New York, United States🇺🇸
Hybrid Full Time 1 hour ago
Veterinary Clinical Research Associate-US Clinical Operations
Zoetis Kalamazoo, Michigan, United States🇺🇸
Full Time 1 hour ago
Quality Control Analyst - Chemistry Control Laboratory
Zoetis United States 🇺🇸
Onsite Full Time 1 hour ago
Quality Specialist 3
Grifols, S.A. San Diego, California, United States🇺🇸
Onsite Full Time 1 hour ago
Maintenance Technician
LyvWell Apartments LLC Los Angeles, California, United States🇺🇸
Full Time 1 hour ago
Coordinator, Early Intervening Services
Los Angeles Unified School District United States 🇺🇸
Onsite 1 hour ago
Assistant Professor – Bachelor of Social Work
University of the Cumberlands Remote · United States 🇺🇸
Remote Full Time 1 hour ago
Global Partnerships & Commercial Strategic Communications Manager
Valvoline Global Cincinnati, Ohio, United States🇺🇸
Onsite 1 hour ago
Senior Manager, Enterprise & Executive Communications
Valvoline Global Cincinnati, Ohio, United States🇺🇸
Onsite 1 hour ago
Credit Application Representative
PREMIER Bankcard, LLC Dakota Dunes, South Dakota, United States🇺🇸
Onsite Full Time 1 hour ago