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.

Originally posted on Himalayas