Data Engineer Consultant

Remote · United States
Contract
$75-$90
Posted Nov 12, 2026

Job description

About Chartis

The challenges facing US healthcare are longstanding and all too familiar. We are Chartis, and we believe in better. We work with more than 1,900 organizations annually to develop and activate transformative strategies, operating models, and organizational enterprises that make US healthcare more affordable, accessible, equitable, safe, and human. With more than 1,450 professionals, we help providers, payers, technology innovators, retail companies, and investors create and embrace solutions that tangibly and materially reshape healthcare for the better. Our family of brands—Chartis, Jarrard, Greeley, and HealthScape Advisors—is 100% focused on healthcare and each has a longstanding commitment to helping transform healthcare in big and small ways. Believe in better.

Chartis has offices in Boston, Chicago, New York, Washington D.C., and Nashville.

Remote work is allowed.

Role Overview

Please note, this is a contract opportunity initial contract is 6 months.

Key Responsibilities:

•Design, fine-tune, and troubleshoot existing SSIS ETL processes that transform clinical data sets into the OMOP data warehouse schema that is unique to the University of California system

•Communicate and collaborate with end users on updates, downstream impacts, testing, and troubleshooting

•Ensure high data quality and mapping accuracy by documenting lineage and transformation rules

•Fulfill OMOP enhancement requests, bug fixes, and day-to-day maintenance

•Optimize the existing ETL processes to reduce overall ETL time and performance

Required:

•5+ years of experience creating and optimizing data pipelines capable of ingesting and integrating data from multiple heterogenous sources using complex Microsoft SSIS ETL packages

•5+ years of developing and managing data transformation and structured databases in Microsoft SQL Server

•3+ years of experience designing and fine-tuning data quality tests

•3+ years of working with Git-based version control

•3+ years of working within a software development lifecycle framework (testing, production deployment, data reconciliation, and post-release monitoring)

•Ability to independently create and manage performance tuning, error handling, and operational monitoring of ETL workflows

Preferred:

•3+ years of Epic Clarity experience (ideally Clarity certified)

•3+ years with the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM)

•Knowledge of clinical terminology, standardized vocabularies, and concept mapping.

•Understanding of patient matching and identity resolution concepts.

Hourly salary range: $75-$90. The hourly range for this role takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to, skills, experience, training, licensure and certifications, practice area, and other business and organizational needs.

At Chartis, we pride ourselves on having a diverse workforce. We value and celebrate the uniqueness of individuals and the different perspectives they provide. We offer equal opportunity employment regardless of race, color, religion, gender identity or expression, sexual orientation, national origin, genetics, disability status, age, marital status, or protected veteran status.