The mission of the University of Michigan is to serve the people of Michigan and the world through preeminence in creating, communicating, preserving, and applying knowledge, art, and academic values, and in developing leaders and citizens who will challenge the present and enrich the future.

Why Work at Michigan?

Being part of something greater, of serving a larger mission of discovery and care — that's the heart of what drives people to work at Michigan. In some way, great or small, every person here helps to advance this world-class institution. It's adding a purpose to your profession. Work at Michigan and become a victor for the greater good.

A cover letter is required for consideration for this position and should be attached as the first page of your resume. The cover letter should address your specific interest in the position and outline skills and experience that directly relate to this position.

Department Summary

The University of Michigan (U-M) University Health Service (UHS), a unit of Student Life, is an AAAHC-accredited outpatient multispecialty health clinic that serves a large and diverse student body of more than 45,000 students, as well as U-M faculty and staff. UHS provides direct patient care through its primary care and specialty clinics, as well as public health, epidemiologic surveillance, health education and promotion.

Job Summary

The UHS Healthcare Analyst (HA) will join a dynamic and collaborative team of data analysts, clinicians, epidemiologist, IT business solutions, and revenue cycle professionals. The analyst mines, analyzes, presents and visualizes clinical, public health, financial and operational data from a variety of data sources in order to improve the healthcare quality, safety and sustainability of the university. This position collaborates across campus with clinical, analytic, IT and public health staff in order to improve access, workflows, and outcomes of care and public health interventions.

Responsibilities

The primary duties are data mining, coding, analysis, visualization, reporting and communication using the electronic medical record and various health databases and data warehouses as data sources.

Data Management (60%)

• Track/log cases of: COVID, flu, STIs, diseases caused by enteric pathogens, chickenpox, measles, mumps, pertussis, shingles, viral hepatitis, lyme disease; tracking tests (positive and negative results)
• Pull data from MiChart/HSDW and maintain reportable disease log. Clean and verify data to reflect appropriate format; ensure data effectively flows into the Tableau dashboard; integrate feedback/other requested components as requested
• Compile monthly data from different pre-existing sources and run MiChart/HSDW reports to obtain other data points for billing compliance; ensure data effectively flows into the Tableau dashboard; integrate feedback and requested adjustments as necessary following meetings where dashboard is shown in order to allow leadership to make informed decisions
• Respond to data inquiries from clinical and administrative managers
• Monitor timely and accurate receipt and transfer of data
• Ensure workflow integrity by securely connecting to an API to download test results; process, sort, and merge on a unique identifier to a registration list that includes demographic information for testers
• Identify and analyze trends in data sets by processing, merging, grouping, and creating of summary statistics (Excel, SAS, R, and other data management programs)
• Reconcile multiple and sometimes conflicting data sources by ensuring data from lab and data in log matches and is reported in MDSS; periodically review the reportable disease dashboard and yearly communicable disease report by matching the two data sources in software (R, SAS, SPSS, etc); manually review charts to determine vaccination status and/or search the self-reported vaccination information when reconciling needed data to resolve data concerns and ensure accurate information and data integrity
• Perform basic statistical analysis
• Design and develop data visualization solutions to communicate results to key decision makers by determining the source of data, formatting data to meet visualization needs (Tableau, website; etc.
• Other duties as assigned

Reporting and Communication (30%)

• Prepare summaries for internal and external stakeholders (e.g., reportable diseases, annual reports, clinical operations, billing optimization, quality and safety, patient satisfaction)
• Create and run data reports from the electronic medical record (MiChart/Epic) and other sources (e.g., Michigan Disease Surveillance System, health data warehouses)

Partnership and Collaboration (10%)

• Collaborate with UHS managers and public health professionals to define and create appropriate key performance indicators
• Adopt and modify (if needed) existing data and analytic programs and workflows
• Liaise with School of Public Health, Michigan Medicine, Health Departments, the Registrar, and Student Life partners

Required Qualifications

• Bachelor's degree in a related field
• 2 years of experience in a clinical, healthcare, data analytics, or STEM-related field where a significant component of the work was data analysis, working with large data sets, and collaborating with an interdisciplinary team

Desired Qualifications

• Master's degree in a related and/or field (e.g., MPH, MS, MAS, MHA, MIS)
• Knowledge of Epic/MiChart, or ability to gain proficiency in MiChart (Epic and Clarity) queries through training
• Experience using programming languages such as SQL and/or Python
• Advanced experience with software tools such as Microsoft Office, OneDrive, SharePoint, etc.
• Experience with large data sets (including data warehouses), database principles, and managing linkages between data sources.
• Ability to write clear and concise analytical summaries of methodologies, statistical results, and to create charts, tables, and other visual aids
• Working knowledge of public health and epidemiologic concepts
• Advanced experience with statistical analysis (using tools such as SAS, SPSS, R)
• Advanced experience with data visualization methods and programs
• Knowledge of the importance of consent, confidentiality, patient autonomy, and client privacy.
• Experience with quality and process improvement
• Familiarity with using programming languages such as Python to access application program interfaces (APIs) and automate data pulls and processing
• Experience with online survey methodologies, tools, and survey reporting

Additional Information

• Demonstrated experience pulling/collecting, cleaning, analyzing, and reporting data
• Superior attention to detail
• Strong analytical and problem-solving skills
• Ability to prioritize, organize, and efficiently work in a fluid environment that is rapidly changing, and with multiple assignments simultaneously
• Ability to anticipate requests and needs in advance and plan accordingly
• Excellent verbal and written communication
• Strong visual presentation skills
• Strong interpersonal skills
• Track record of effective collaboration with peers on analytical group projects
• Flexibility and ability to work independently and collaboratively with multiple co-workers and staff across the university
• Ability to work effectively with limited supervision and to know when to consult with colleagues

Financial/Budgetary Responsibility

None