Senior Snowflake Engineer
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior Snowflake Engineer building Snowflake transformations and healthcare attribution models. Supporting Datavail’s data-management and analytics services with testing, reconciliation, and auditability.
Responsibilities:
- 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
Requirements:
- 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
Similar Jobs
Engineer III – Transmission Planning
Transmission planning engineer performing power flow, short circuit, and interconnection studies for Qualus. Supporting utilities and energy clients in modernizing resilient power infrastructure.
Endpoint Management Engineer – Intune, SCCM/MECM
Endpoint Management Engineer supporting Windows endpoints for Gruve, an AI-focused software services company. Managing Intune, SCCM/MECM, patching, compliance, deployments, and ITIL operations.
Oracle Identity & Access Management Engineer
Oracle IAM Engineer administering OAM, OIG, and OID systems for GDIT’s CMS HIGLAS healthcare accounting program. Supporting secure access, monitoring, troubleshooting, and integrations.
Lead Substation Engineer – Grid
Lead substation engineer designing and upgrading high-voltage substations for Sargent & Lundy. Guiding protection, controls, SCADA, reviews, and engineering teams.
Service Desk Engineer
Remote Service Desk Engineer providing hardware, software, network, and access support for Aspire’s global teams. Managing tickets, devices, collaboration platforms, and security compliance.
Forward Deployed Engineer
Forward Deployed Engineer embedding with product teams to build production AI services. Developing RAG, agentic, cloud-native, and MLOps solutions for IFS enterprise software.
Forward Deployed Engineer
Forward Deployed Engineer embedding with product teams to build production AI services for IFS enterprise software. Connecting LLM, RAG, agentic, and cloud-native capabilities to business workflows.
NPI Engineer
NPI Engineer leading prototype-to-production manufacturing for Ammortal Chamber wellness technology. Coordinating contract manufacturers, DFM/DFA, quality systems, and production ramp.
Project Controls Engineer, OT SCADA Projects
Project Controls Engineer designing and commissioning SCADA controls for utility-scale solar, storage, and hybrid renewable energy projects. Supporting FATs, grid compliance, documentation, and product improvements.
Principal Equipment Engineer, Adhesion & Assembly
Principal Equipment Engineer developing robotics, controls, and assembly automation for Collins Aerospace. Deploying scalable equipment across aerospace manufacturing sites.
Senior/Staff PCB Layout Engineer
PCB layout engineer designing complex boards for Skydio’s autonomous drones. Owning high-speed layouts, manufacturing release, and hardware design standards.
Staff GCP Engineer
Staff GCP Engineer supporting reliable GCP applications, CI/CD, and SRE operations at CVS Health. Building secure infrastructure for AI agents, integrations, and knowledge-based applications.
Enterprise Telecom Engineer
Enterprise Telecom Engineer supporting voice, contact center, and network infrastructure. Enabling reliable communications for LUX Infusion’s patient-care operations.
Controls Engineer
Controls Engineer designing PLC, robotics, and industrial automation systems for Valmont’s steel manufacturing operations. Supporting capital projects, commissioning, troubleshooting, and continuous improvement.
Nuclear Engineer – Fuel Manager
Fuel Business Manager managing PWR and BWR customer accounts across the Americas for Westinghouse, a global nuclear energy solutions provider. Leading sales, account planning, pricing, and fuel engineering partnerships.
Senior Narrative Engineer
Senior Narrative Engineer building dialogue tools and pipelines for CD PROJEKT RED’s story-driven RPGs. Supporting localization, subtitles, voiceovers, and narrative systems from Warsaw or remotely.
Senior Graphics Engineer
Senior Graphics Engineer advancing Unreal Engine 5 rendering, shaders, and performance for Cloud Chamber’s BioShock games. Building graphics tools and mentoring engineers across multidisciplinary development teams.
Plumbing and Heating Engineer
Clean Energy Technician installing heat pumps, cylinders, and radiators for Aira’s sustainable home energy systems. Training provided toward heat pump installation.
Lead, Supplier Development Engineer
Lead supplier development for L3Harris defense programs, evaluating aerospace manufacturing capability and resolving technical issues. Drive supplier quality, process improvement, and production execution across critical programs.
GCP Engineer
GCP Engineer building and operating secure Google Cloud platforms for US federal customers. Automating infrastructure, CI/CD, compliance, and customer onboarding.