Lead Data Analyst

University of Michigan9 months ago
Michigan
On-site
Full-time
Junior Level (1-3 years)

Job Description

Position Overview

The Michigan Value Collaborative (MVC), housed at the University of Michigan, is seeking a detail-oriented self-starter to join the team in the role of Lead Data Analyst. Strong analytic, organizational, project management, as well as verbal and written communication skills are critical to this role. The MVC is a statewide hospital and physician organization consortium, aiming to improve the health of Michigan through sustainable, high-value healthcare and to enable Michigan patients to access the right care, at the right cost, at the right time. The Lead Data Analyst will be assigned to lead a dedicated project aimed at demonstrating the impact, value, and return on investment of the Collaborative Quality Initiatives (CQIs). In this role, the Lead Analyst gathers and analyzes data from various databases and other sources; cleans and constructs datasets; performs statistical programming; and provides analytic and technical assistance to the wider project team. The position offers an excellent opportunity to work with clinicians, policy experts, statisticians, economists, health services researchers, and other MVC analysts while applying and growing your data management and analytic expertise. A cover letter is required for consideration and should be attached as the first page of your resume, addressing your specific interest and relevant skills and experiences.

Key Responsibilities

  • Write and edit programs to clean, manage, merge, maintain, and analyze data, including large data sets (millions of observations).
  • Extract, transform, and merge raw data from various data sources into usable forms and construct datasets according to the specifications provided.
  • Design, create, and implement programs and templates to collect, display, and analyze data.
  • Perform statistical programming utilizing a variety of statistical software packages to summarize data and create reports and/or visual presentations.
  • Conduct advanced statistical analysis, with support and supervision, including multilevel regression modeling, survival analysis, and causal inference methods such as difference-in-differences, instrumental variables analysis, interrupted time series, and regression discontinuity designs.
  • Design and prepare standard and ad hoc reports.
  • Design and prepare summaries for statistical analysis and planning purposes.
  • Document procedures for future reference and recommend improvements to the data analysis process.
  • Present analytic methods and new approaches to accomplishing goals both internally and externally.

Required Qualifications

  • Bachelor's degree in a recognized field of science or learning directly related to the duties of the position.
  • Minimum 5 years of experience analyzing and interpreting process data, clinical outcomes, and costs of care.
  • Demonstrated proficiency working with large administrative datasets using statistical software programs (STATA, SAS, R), along with data visualization, statistical models, and significance testing.
  • Strong organization skills and attention to detail with the ability to manage competing demands and prioritize to meet deadlines.
  • Ability to work both independently and cooperatively.
  • Demonstrated ability to manage multiple projects simultaneously.
  • Professional, team-driven attitude with a proven ability to take initiative.

Preferred Qualifications

  • Master's degree in a relevant field.
  • Experience working with large insurance claims datasets, such as Medicare, MarketScan, Healthcare Cost & Utilization Project, or other claims data sources.
  • Experience working with multi-payer claims data.
  • Working knowledge of hospital pay-for-performance or payer incentive reimbursement programs.
  • Knowledge or experience working with the BCBSM Collaborative Quality Initiatives.

Required Skills

SQL
R
Advanced Statistical Analysis
SAS
Project Management
Reporting
Data Analysis
Statistical Programming
Data Visualization
STATA
Data Cleaning