Senior dbt Engineer - Healthcare EMR Migration

• 100% Remote
• Note: We’re not able to work with candidates requiring sponsorship through a third-party firm (C2C)

About Provisions Group

At Provisions Group, we believe technology is about people first. We are an IT consulting, staffing, and professional services firm based in Franklin, TN, focused on building long-term relationships with both our clients and consultants. Our teams work across cloud, data, software engineering, business applications, healthcare IT, and enterprise transformation initiatives.

We are currently seeking a senior-level dbt Engineer to support a healthcare-focused data and analytics initiative involving an EMR migration and modernization effort.

Position Overview

Our client is undergoing a migration from one EMR platform to another and needs an experienced dbt Engineer to help assess, analyze, and update an existing dbt environment within Snowflake.

This person will work closely with data and clinical teams to evaluate existing dbt models, identify dependencies and gaps created by the EMR transition, and help support remediation efforts. The ideal candidate is a senior-level consultant who can work independently with limited onboarding and quickly contribute within an existing healthcare data environment.

This engagement is expected to begin as part-time support initially, with the potential for ongoing long-term work as new data sources and dbt models continue to evolve.

Must Haves

• 3+ years of hands-on dbt development experience

• Strong experience building and maintaining dbt models, tests, documentation, and lineage workflows

• Experience working with Snowflake and/or other enterprise data platforms such as Databricks

• Strong SQL development skills

• Experience with healthcare data environments and EMR-related data structures

• Familiarity with data modeling patterns including staging, intermediate, and mart layers

• Ability to work independently and contribute quickly in environments with limited documentation

• Experience supporting data migration, modernization, or transformation initiatives

Responsibilities

• Audit the existing dbt project to catalog models, sources, tests, and dependencies

• Analyze current dbt models and identify references to source tables or columns no longer available in the new EMR

• Perform lineage analysis to determine downstream impact from upstream schema changes

• Document gaps between legacy and new EMR data structures, including renamed fields, missing tables, and structural differences

• Collaborate with client data teams and clinical stakeholders to understand schema mappings and business logic

• Recommend updates to existing dbt models and create net-new models where needed

• Support Snowflake-based data transformation and analytics workflows

• Assist with remediation planning and implementation efforts related to the EMR migration

• Produce a detailed gap analysis report with prioritized findings and recommendations

• Work independently within an existing healthcare analytics environment with minimal oversight

Preferred Skills

• Familiarity with EMR platforms such as Epic, Cerner, Athena, or similar healthcare systems

• Experience supporting EMR migrations or healthcare system transition projects

• Experience working within consulting or client-facing environments

• Understanding of ETL/ELT concepts and modern analytics engineering practices

• Experience with open-source data tooling ecosystems

Additional Information

• Part-time consulting engagement initially, estimated at approximately 5–10 hours per week

• Potential for expanded hours or long-term ongoing support depending on project needs

• Senior-level experience strongly preferred due to limited onboarding bandwidth within the client environment

• Healthcare experience is highly preferred due to the nature of the EMR migration work