Job Description

Summary
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
Position Criteria (Candidate Characteristics):

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