chartis · Remote
Skills: SQL
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 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 dep…
Sign in to see the original posting
Browse more developer jobs on RoleBurst