Data Analyst (underfill option)
University of Michigan
Ann Arbor, MI
ID: 7261516
Posted: July 10, 2024
Application Deadline: Open Until Filled
Job Description
Summary
The University of Michigan Health System is home to multiple Collaborative Quality Initiatives (CQIs) coordinating centers which seek to address some of the most common, complex, and costly areas of surgical and medical care. With funding from Blue Cross Blue Shield of Michigan (BCBSM), the CQIs work collaboratively with health care providers throughout Michigan to collect data to a centralized registry. The data are analyzed and shared to identify processes that lead to improved delivery of care and outcomes, and guide quality improvement interventions.
The Inspiring Health Advances in Lung Care INHALE CQI is a recently established CQI focused on addressing lung health in patients with Asthma and COPD. The ultimate goal is to partner all CQIs with communities across the state to ensure all patients have access to social health interventions needed for optimal care and health outcomes.
Each CQI is organized and facilitated by a Coordinating Center, led by Program Directors and Co-directors (physicians and nurses), and a Program Manager. A CQIs staffing typically includes Quality Improvement (QI) coordinators, project managers, and analysts. The current role is for a novel CQI that will interface with all other existing CQIs as well as community partners across the state.
Role Summary:
The INHALE Data Analyst will perform data management, statistical programming, analysis and reporting using large administrative claims and clinical extracts.
Mission Statement
Michigan Medicine improves the health of patients, populations and communities through excellence in education, patient care, community service, research and technology development, and through leadership activities in Michigan, nationally and internationally. Our mission is guided by our Strategic Principles and has three critical components; patient care, education and research that together enhance our contribution to society.
Responsibilities*
This position involves a wide range of tasks including claims and clinical data management, provider participation and performance tracking for value-based reimbursement supporting quality improvement. Under the direction of the INHALE program directors and in collaboration with the CQI population health data hub, the position involves providing independent and collaborative analytic support for the INHALE CQI.
Responsibilities include but are not limited to:
Data Analysis:
Extract, transform, and merge raw data from various data sources into usable forms and construct datasets.
Write, test, and implement programs using SAS or other statistical software to analyze incoming data for accuracy
Design and prepare standard automated and ad hoc reports for participating provider organizations
Work closely with the INHALE team and the data hub to develop new quality measures and dashboard views.
Work closely with the INHALE team to summarize, interpret, and present results in written, tabular, and visual formats. Apply a broad knowledge of measurement, analysis, ROI, and performance improvement to implement QI and other projects throughout the collaborative, facilitating the adoption and implementation of best practices.
Document processes and data sources and make recommendations for improvements.
Harmonize data with previously collected data or aggregate disparate data sources for analysis and reporting.
Data Reporting:
Respond to questions, data needs, and ad-hoc requests from CQI participants.
Prepare standard reports for BCBSM detailing provider and practice participation.
Independently document quality assurance operations performed in final reports and provide basic documentation on datasets.
Document procedures for future reference and make recommendations for data analysis process improvements.
Behavioral & Work Environment Expectations:
Identify and act on current priorities while maintaining flexibility and openness to changes.
Bring a participatory and constructive approach to problem solving.
Consider impact of work on internal and external audiences and be mindful of project timelines, staff needs across projects.
Be approachable, responsive, and accessible, acting as a support and resource for others.
Proactively share knowledge to keep team members informed and work to overcome obstacles and seek resolutions with others.
Move between leader and follower roles within projects.
Required Qualifications*
Senior Level:
Bachelor's degree in Statistics, Biostatics, Public Health, Computer Science, Informatics, or related field or appropriate job experience.
At least 5 years of professional experience in SAS programing and analysis (or other similar statistical software such as Stata or R) required for placement at the senior level
Intermediate Level:
Bachelor's degree in Statistics, Biostatics, Public Health, Computer Science, Informatics, or related field or appropriate job experience.
At least 3 years of professional experience in SAS programing and analysis (or other similar statistical software such as Stata or R) required for placement at the intermediate level
Both:
Strong, demonstrable programming skills and experience with relational databases, complex data structure, and linkages between data sources
Experience with Microsoft Excel and PowerPoint for the development of presentation materials
Proven ability to write clear and concise technical documentation, summaries of various methodologies, and descriptions of statistical results
Excellent communication, both oral and written in English language, and interpersonal skills are essential
Ability to prioritize, organize, and efficiently work on multiple projects at the same time
Working knowledge of epidemiologic concepts and methodology
Experience working with International Classification Diagnosis and Procedures (ICD 10) codes, National Drug Codes (NDC), Current Procedural Terminology (CPT) and Healthcare Common Procedure Coding System (HCPCS) codes.
Experience with real world healthcare claims data, such as Blue Cross/Blue Shield, MarketScan, Optum, Medicare, Medicaid, and/or Electronic Medical Record Databases
The University of Michigan Health System is home to multiple Collaborative Quality Initiatives (CQIs) coordinating centers which seek to address some of the most common, complex, and costly areas of surgical and medical care. With funding from Blue Cross Blue Shield of Michigan (BCBSM), the CQIs work collaboratively with health care providers throughout Michigan to collect data to a centralized registry. The data are analyzed and shared to identify processes that lead to improved delivery of care and outcomes, and guide quality improvement interventions.
The Inspiring Health Advances in Lung Care INHALE CQI is a recently established CQI focused on addressing lung health in patients with Asthma and COPD. The ultimate goal is to partner all CQIs with communities across the state to ensure all patients have access to social health interventions needed for optimal care and health outcomes.
Each CQI is organized and facilitated by a Coordinating Center, led by Program Directors and Co-directors (physicians and nurses), and a Program Manager. A CQIs staffing typically includes Quality Improvement (QI) coordinators, project managers, and analysts. The current role is for a novel CQI that will interface with all other existing CQIs as well as community partners across the state.
Role Summary:
The INHALE Data Analyst will perform data management, statistical programming, analysis and reporting using large administrative claims and clinical extracts.
Mission Statement
Michigan Medicine improves the health of patients, populations and communities through excellence in education, patient care, community service, research and technology development, and through leadership activities in Michigan, nationally and internationally. Our mission is guided by our Strategic Principles and has three critical components; patient care, education and research that together enhance our contribution to society.
Responsibilities*
This position involves a wide range of tasks including claims and clinical data management, provider participation and performance tracking for value-based reimbursement supporting quality improvement. Under the direction of the INHALE program directors and in collaboration with the CQI population health data hub, the position involves providing independent and collaborative analytic support for the INHALE CQI.
Responsibilities include but are not limited to:
Data Analysis:
Extract, transform, and merge raw data from various data sources into usable forms and construct datasets.
Write, test, and implement programs using SAS or other statistical software to analyze incoming data for accuracy
Design and prepare standard automated and ad hoc reports for participating provider organizations
Work closely with the INHALE team and the data hub to develop new quality measures and dashboard views.
Work closely with the INHALE team to summarize, interpret, and present results in written, tabular, and visual formats. Apply a broad knowledge of measurement, analysis, ROI, and performance improvement to implement QI and other projects throughout the collaborative, facilitating the adoption and implementation of best practices.
Document processes and data sources and make recommendations for improvements.
Harmonize data with previously collected data or aggregate disparate data sources for analysis and reporting.
Data Reporting:
Respond to questions, data needs, and ad-hoc requests from CQI participants.
Prepare standard reports for BCBSM detailing provider and practice participation.
Independently document quality assurance operations performed in final reports and provide basic documentation on datasets.
Document procedures for future reference and make recommendations for data analysis process improvements.
Behavioral & Work Environment Expectations:
Identify and act on current priorities while maintaining flexibility and openness to changes.
Bring a participatory and constructive approach to problem solving.
Consider impact of work on internal and external audiences and be mindful of project timelines, staff needs across projects.
Be approachable, responsive, and accessible, acting as a support and resource for others.
Proactively share knowledge to keep team members informed and work to overcome obstacles and seek resolutions with others.
Move between leader and follower roles within projects.
Required Qualifications*
Senior Level:
Bachelor's degree in Statistics, Biostatics, Public Health, Computer Science, Informatics, or related field or appropriate job experience.
At least 5 years of professional experience in SAS programing and analysis (or other similar statistical software such as Stata or R) required for placement at the senior level
Intermediate Level:
Bachelor's degree in Statistics, Biostatics, Public Health, Computer Science, Informatics, or related field or appropriate job experience.
At least 3 years of professional experience in SAS programing and analysis (or other similar statistical software such as Stata or R) required for placement at the intermediate level
Both:
Strong, demonstrable programming skills and experience with relational databases, complex data structure, and linkages between data sources
Experience with Microsoft Excel and PowerPoint for the development of presentation materials
Proven ability to write clear and concise technical documentation, summaries of various methodologies, and descriptions of statistical results
Excellent communication, both oral and written in English language, and interpersonal skills are essential
Ability to prioritize, organize, and efficiently work on multiple projects at the same time
Working knowledge of epidemiologic concepts and methodology
Experience working with International Classification Diagnosis and Procedures (ICD 10) codes, National Drug Codes (NDC), Current Procedural Terminology (CPT) and Healthcare Common Procedure Coding System (HCPCS) codes.
Experience with real world healthcare claims data, such as Blue Cross/Blue Shield, MarketScan, Optum, Medicare, Medicaid, and/or Electronic Medical Record Databases