Michigan OPEN Information Coordinator

University of Michigan; Ann Arbor (MI); Hybrid; USD 75,000 - 110,000; Full time

Benefits offered by this job

Hybrid/Remote work flexibility

Job summary

The University of Michigan is seeking a data management professional to support Michigan OPEN healthcare data initiatives. You will develop data pipelines, merge diverse datasets, and create analytic datasets and visualizations using SQL Server and Power BI.

Collaboration with researchers, data stewards, and analysts is essential to ensure data quality and timely responses to data requests. Hybrid or remote work options are available at the department's discretion, with background screenings per

Qualifications

• Masters degree in Computer Information Systems or related field with 2 years of experience.
• Experience using multiple data sources, including healthcare datasets, to develop dashboards and reports.
• Proficiency with SQL queries, data transformation, and using Microsoft tools (SQL Server, Power BI) for analytics.

Responsibilities

• Perform data management tasks for healthcare data from multiple sources.
• Develop and enhance data pipelines to extract, clean, transform, and merge data.
• Create analytic datasets and perform analyses using statistical software; summarize results in reports and visuals.
• Respond to data queries and manage dataset requests; collaborate with analysts and researchers.
• Assess data quality and maintain data dictionaries and documentation.
• Support grant proposals, presentations, or scientific submissions; improve data processes.

Skills

SQL

Power BI

Data modeling

Data visualization

Education

Masters in Computer Information Systems

Tools

SQL Server

Power BI

Job description

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 .

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 maybegin as early as the eighth day after posting.Thisopening 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.