Data Engineer Consultant

Chartis is hiring a Data Engineer Consultant to support the University of California system’s OMOP data warehouse. The role focuses on maintaining, improving, and troubleshooting clinical data ETL processes, while collaborating with end users and ensuring data quality and performance.

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

Requirements:

• 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
• 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