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.
Similar Jobs
What you need to know about the Boston Tech Scene
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories



