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.

•