MTQIP Clinical Registry Data Engineer

A cover letter and resume are required for consideration. Please attach both documents as one file due to system limitations.

In your cover letter, please describe how your experience, career goals, and accomplishments directly relate to this position. Please include examples of your experience developing data pipelines, writing SQL code, automating data workflows, working with clinical or administrative data, supporting ad hoc technical projects, and communicating technical information to both technical and non-technical audiences.

To be considered, you must be legally authorized to work in the United States without the need for employer sponsorship now or at any time in the future.

MTQIP advances trauma care across Michigan through high-quality clinical data, collaborative quality improvement, and actionable performance feedback to participating trauma centers.

The Michigan Trauma Quality Improvement Program, or MTQIP, is a statewide quality improvement collaborative focused on improving trauma care, outcomes, and data-driven performance across participating Michigan trauma centers.

MTQIP is seeking a Clinical Registry Data Architect to support clinical registry data infrastructure, report exports, data pipelines, automation, and program-wide technical data needs. This position will play a key role in maintaining and improving SQL-based report exports from registry platforms, including Snowflake Reader, and supporting the development of streamlined workflows for data submission, validation, reporting, and analysis. In addition, MTQIP is looking to develop extracts from electronic medical record such as EPIC Clarity, and proficiency in data science concepts such as Large Language Models (LLM).

This role is well suited for a data professional who enjoys working at the intersection of healthcare, technology, quality improvement, and applied data engineering. The ideal candidate will be comfortable working with complex clinical data, translating registry and measure specifications into technical logic, writing and maintaining SQL, supporting data quality checks, and collaborating with clinical, operational, and technical stakeholders.

This position will support MTQIP's clinical registry reporting needs, including report exports from vendor systems, data transformation processes, automation, data validation, ad hoc data and technical projects, and potential future data extraction from electronic health record systems such as Epic. The person in this role will work closely with MTQIP leadership, program managers, analysts, clinicians, participating hospitals, registry vendors, and institutional technical teams.

A typical week may include SQL development, Snowflake query development, data pipeline maintenance, troubleshooting registry export logic, documenting technical specifications, validating data quality, supporting automation, responding to ad hoc technical data requests, participating in stakeholder meetings, and helping translate clinical measure logic into reliable, reproducible data processes.

• Develop, maintain, and troubleshoot SQL-based data exports from clinical registry systems, including Snowflake Reader.
• Translate registry specifications, data dictionary requirements, and performance measure logic into reproducible SQL queries and export processes.
• Support the development, maintenance, and documentation of MTQIP data pipelines, including data extraction, transformation, validation, and reporting workflows.
• Create and maintain automated processes to reduce manual data handling, improve reproducibility, and streamline recurring report production.
• Provide global MTQIP technical data support across registry reporting, collaborative performance measurement, data validation, vendor data workflows, and internal analytic needs.
• Support ad hoc technical and data projects, including one-time data extracts, special analyses, data investigations, process improvement efforts, and emerging MTQIP reporting priorities.
• Work with complex healthcare datasets, including trauma registry data, hospital-submitted data, vendor registry data, and potentially electronic health record data from Epic or related systems.
• Support clinical registry submission workflows, including mapping, formatting, validation, and preparation of data for reporting and analysis.
• Partner with clinicians, program staff, analysts, vendors, and institutional technical teams to understand data needs and convert them into scalable technical solutions.
• Perform data quality checks to identify missing, inconsistent, duplicated, or unexpected values.
• Document SQL logic, data sources, transformation rules, data validation steps, and recurring operational workflows.
• Support the creation of standardized datasets for internal analysis, quality improvement reporting, external submission, and collaborative performance measurement.
• Assist with troubleshooting data discrepancies between registry systems, exported files, analytic…