Datavail Logo

Datavail

Senior Snowflake Engineer

Posted 15 Days Ago
In-Office or Remote
Hiring Remotely in USA
Senior level
In-Office or Remote
Hiring Remotely in USA
Senior level
Build and optimize Snowflake data transformations across staging, curated, and conformed layers. Implement dimensional models, SCD Type 2 history, member matching, payer attribution, reconciliation, and member-month outputs. Develop restartable, testable processing with audit logging, error handling, data-quality checks, alerting, and schema-drift controls. Troubleshoot production issues, maintain documentation, participate in reviews and planning, and support client demonstrations.
The summary above was generated by AI

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.

  •  

About UsDatavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner. About the Team
Datavail’s Data Management Services: 
Datavail’s Data Management and Analytics practice is made up of experts who provide a variety of data services including initial consulting and development, designing and building complete data systems, as well as ongoing support and management of database, data warehouse, data lake, data integration, and virtualization and reporting environments. Datavail’s team is comprised of not just excellent BI & analytics consultants, but great people as well. Datavail’s data intelligence consultants are experienced, knowledgeable and certified in the best in breed BI and analytics software applications and technologies. We ascertain your business objectives, goals and requirements, assess your environment, and recommend the tools which best fit your unique situation. Our proven methodology can help your project succeed, regardless of stage. With the combination of a proven delivery model and top-notch experience ensures that Datavail will remain the Data Management experts on demand you desire. Datavail’s flexible and client focused services always add value to your organization.

Similar Jobs

Yesterday
Remote
United States
75-75 Hourly
Senior level
75-75 Hourly
Senior level
Artificial Intelligence • Cloud • Information Technology • Internet of Things • Software
Lead architecture and end-to-end implementation of a secure full-stack business application integrated with Snowflake. Design accessible workflow interfaces, APIs, transactional data models, field-level audit history, authentication, authorization, deployment pipelines, monitoring, backups, and operational documentation. Partner with product, PMO, data, security, and operations stakeholders to deliver and support the production system.
Top Skills: Ci/CdObservabilityRest ApisRole-Based Access ControlSecrets ManagementSnowflakeSnowflake StreamsSnowflake TasksSsoTransactional Databases
4 Days Ago
Remote
United States
110K-160K Annually
Senior level
110K-160K Annually
Senior level
Consulting
Design, implement, and maintain Snowflake-based data pipelines, integrations, architectures, and warehousing solutions. Use Qlik, dbt Labs, Astronomer, SQL, and scripting to support data ingestion, transformation, performance, security, governance, and quality. Diagnose engineering issues, collaborate with stakeholders, and provide consulting services. The role requires bi-weekly travel to Columbia, Missouri, for approximately one year.
Top Skills: AstronomerAWSAzureDbt LabsGitPowershellPythonQlik ComposeQlik ReplicateSnowflakeSQL
5 Days Ago
In-Office or Remote
Senior level
Senior level
Software
Designs and maintains Snowflake data warehouses, scalable ETL/ELT pipelines, layered data architectures, dimensional models, and analytics-ready datasets. Develops complex SQL transformations, integrates multiple data sources, supports BI platforms and downstream applications, and implements data quality monitoring. Troubleshoots pipeline and performance issues, collaborates with technical and business stakeholders, contributes to architecture decisions, and builds documented, reusable data solutions.
Top Skills: Apache AirflowAWSDagsterDbtFivetranKafkaLookerPower BIPythonSnowflakeSnowplowSQLTableauTerraform

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

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

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account