Michigan OPEN Information Coordinator

Michigan Medicine; Ann Arbor (MI); Hybrid; USD 85,000 - 110,000; Full time

Job summary

Michigan Medicine is seeking a data management professional to support the Michigan OPEN project. The role involves building and refining data pipelines to extract, clean, transform, and merge data from multiple sources.

You will develop analytic datasets, perform analyses, and produce dashboards and reports. The candidate will collaborate with researchers and data stewards, ensuring data quality, documenting data elements, and supporting grant-related submissions.

Qualifications

• Masters degree in Computer Information Systems or related field with 2 years of experience
• Experience using multiple data sources, including healthcare datasets such as Medicaid, to develop dashboards and reports
• Proficiency in coding and debugging SQL queries to extract, transform, and validate data
• Experience using Microsoft tools including SQL Server and Power BI for data transformation, calculations, visualizations, and reports

Responsibilities

• Perform data management tasks for the Michigan OPEN data, coordinating with analysts, researchers, and data stewards
• Develop and enhance data pipelines to extract, clean, transform, and merge data from diverse sources
• Create analytic datasets, merge datasets, and perform analyses using statistical software
• Summarize results and create reports or visual presentations
• Provide input on datasets to use for analyses and manage requests for datasets
• Collaborate with stakeholders to ensure data exchange follows established protocols
• Develop methods to detect missing or poor data and assess quality before distribution
• Maintain data dictionaries and documentation of data elements and mappings
• Identify improvement opportunities and propose solutions for data management processes
• Support grant proposals, presentations, or scientific papers; up to 60% work-from-home

Skills

SQL queries

Data analysis

Data cleaning

Dashboard development

Education

Master's degree in Computer Information Systems or related field

Tools

SQL Server

Power BI

Excel

Job description

Responsibilities*

Perform day-to-day tasks associated with data management for various healthcare data sourced by the Michigan Opioid Prescribing Engagement Network (Michigan OPEN), including interacting and collaborating on a consistent basis with other business/functional analysts, data analysts, research teams, and data stewards to obtain and integrate data from different systems. Develop and enhance data pipelines to extract, clean, transform, and merge raw data from various data sources and construct usable analytic datasets. Merge and create analytic datasets and perform analysis utilizing a variety of statistical software packages. Summarize results and create reports and/or visual presentations. Provide input on the appropriate datasets to use for analyses. Manage, track, and fulfill requests for datasets and respond to data queries. Collaborate and coordinate with internal and external stakeholders to ensure that data exchange and transfers follow established protocols. Design and develop robust methods to detect missing or poor data and assess data quality and reasonableness prior to distribution. Develop and maintain reference materials, including data dictionaries and documentation of data elements, data mapping and definitions. Identify opportunities for improvement and recommend solutions for better operational processes for data management. Support the preparation of grant proposals, presentations, conferences, or scientific paper submissions. Up to 60% work from home permitted.

Required Qualifications*

Requires Masters degree in Computer Information Systems or related field + 2 years of experience: using multiple data sources, including healthcare insurance datasets such as Medicaid, to develop dashboards and reports to highlight analytical findings; coding and debugging SQL queries to extract, transform, and validate data, ensuring accuracy and efficiency in reporting and dashboard development; and using Microsoft tools including SQL Server and Power BI to perform transformation and statistical calculations, develop data visualizations, and enhance the functionality of reports and analyses.

Modes of Work

Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about the work modes.

Background Screening

Michigan Medicine conducts background screening and pre-employment drug testing on job candidates upon acceptance of a contingent job offer and may use a third party administrator to conduct background screenings. Background screenings are performed in compliance with the Fair Credit Report Act. Pre-employment drug testing applies to all selected candidates, including new or additional faculty and staff appointments, as well as transfers from other U-M campuses.

Application Deadline

Job openings are posted for a minimum of seven calendar days. The review and selection process may begin as early as the eighth day after posting. This opening may be removed from posting boards and filled anytime after the minimum posting period has ended.

U-M EEO Statement

The University of Michigan is an Equal Opportunity Employer. We are committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants, including protected veterans and individuals with disabilities.