Senior Snowflake Engineer

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.