Business Intelligence Analyst

MU Health Care; Columbia Township (MO); On-site; USD 68,000 - 111,000; Full time

Benefits offered by this job

Health, vision and dental insurance

Paid leave & holidays

Retirement options

Tuition assistance

Discounts on cell plans, cars, gyms

Job summary

MU Health Care in Columbia, MO is seeking a data analyst to develop, interpret, and monitor moderate-to-complex health care analyses, data projections, models, and reports used by system management to drive decisions.

You will collaborate with stakeholders to deploy actionable insights, standardize data, build predictive models, and develop metrics for cross-functional projects using SQL, Excel, Power BI, Python, and R.

Qualifications

• Bachelor’s degree or higher in a related field.
• Experience in decision support, analytics, or quality reporting.
• Strong SQL and data visualization skills (Power BI, Tableau).
• Healthcare analytics experience preferred.

Responsibilities

• Extracts, analyzes, and interprets population health data for actionable insights.
• Performs analyses and modeling on large clinical, financial, and operational datasets.
• Develops data visualizations and reports for leadership and stakeholders.
• Collaborates with subject matter experts to implement analytics solutions.
• Maintains and improves ETL processes and data models.

Skills

Data analysis

Decision support

Stakeholder collaboration

Education

Bachelor's degree in health administration, public health, computer science, statistics, business administration, data science, or a related field

Master's degree in health administration, business administration, data science, or a related field

Tools

SQL

Power BI

Tableau

Python

R

Cerner HealtheIntent

Job description

Shift: Monday - Friday, 8:00am - 5:00pm

Work Arrangement: On-Site

Facility: University Hospital - 1 Hospital Drive, Columbia, MO

• Base Pay Range: $68,266 - $111,426 per year, based on experience

ABOUT THE JOB

Develops, prepares, interprets, and monitors moderate-to-complex health care analyses, data projections, data models, and reports used by system management in decision-making. Serves as an expert resource to provide analytics guidance and support. Works in collaboration with stakeholders and subject matter experts to deploy actionable insights that produce value driven outcomes for patients. Responsibilities include standardizing and cleaning data, building prediction models, modeling outcomes, and developing metrics for complex data analysis projects that can be multi-disciplinary or interdepartmental. Addresses data requirements for analytic reporting and operating areas with expertise in specific data systems and/or analytical methodologies. Works with expert proficiency with a variety of tools (ex: SQL, Excel, Power BI, Python, etc.) to extract data, write queries, develop programming logic, run reports, manipulate data, and analyze datasets to meet the needs of the organization.

ABOUT MU HEALTH CARE

MU Health Care is proud to be named one of Forbes' Best-in-State Employers seven years in a row, and that's largely a result of the incredible culture and team we've built. At MU Health Care, we have an inspired, hard-working and collaborative environment driven by our mission to save and improve lives. Here, we believe anything is possible and rally around solutions. We celebrate innovation and offer opportunities to be a part of something bigger - to have a voice and role in the work that is serving our community and changing the field of medicine.

Our academic health system - the only in mid-Missouri - is home to seven hospitals, including the region's only Level 1 Trauma Center and region's only Children's Hospital, as well as over 90 specialty clinics. Here you can define your career among our many clinical and nonclinical positions - with growth, opportunity and support every step of the way.

Learn more about MU Health Care.

Learn more about living in mid-Missouri.

EMPLOYEE BENEFITS

• Health, vision and dental insurance coverage starting day one
• Generous paid leave and paid time off, including ten holidays
• Multiple retirement options, including 100% matching up to 8%and full vesting in three years
• Tuition assistance for employees (75%) and immediate family members (50%)
• Discounts on cell phone plans, rental cars, gyms, hotels and more
• See a comprehensive list of benefits here.

DETAILED JOB DESCRIPTION

• Extracts, analyzes, and interprets moderate-to-complex population health data using actionable analytics for providers to improve patient outcomes.
• Performs analysis and modeling techniques on large clinical, financial, and/or operational data sets.
• Develops graphical presentations of health data that can be used to illustrate findings using data visualization tools and provide analytic guidance and technical support to other analysts, managers, clinicians, and executives utilizing data.
• Assists in the planning, implementation, and evaluation of health care for individuals and populations across the continuum of care through analytics solutions.
• Performs basic to advanced analyses, ETL processes with Excel, SQL, Python, R, or other programming languages.
• Utilizes various data analysis and business intelligence tools such as SQL, Python, R, Power BI, Tableau, Excel to produce reports and perform meaningful quantitative or qualitative analyses addressing impactful business issues or questions via ad hoc and routine reporting.
• Utilizes methods from outside of healthcare; utilizes data broadly using traditional and non-traditional databases.
• Forecasts the impact of system changes to establish targets and mitigate business risk as well as a strong understanding of external pressures.
• Models and frames scenarios that are meaningful and impact critical business processes and/or decisions.
• Communicates and works with business subject matter experts to analyze information or data on current and future trends of best practice.
• Improves organizational performance though the application of innovative thinking to existing and emerging methods, processes, products, and services. Employs sound judgment in determining how deliverables will be deployed to produce return on investment.
• Remains current with database and analytics technologies methods and standards, actively participate in professional forums, and ensure compliance with all applicable standards. Updates job knowledge by studying state-of-the-art/industry relevant tools, techniques, and equipment.
• Participates in educational opportunities, reading professional publications, maintaining personal networks, and participates in professional organizations. Performs advanced data transformation for utilization in reporting and analyses and implements automated data processes.
• Works closely with Tiger Institute Information Management resources to implement scalable and automated data models that will be used to help drive business performance.
• Assists with development of ETL (Extraction, Transformation and Loading) processes to acquire and load data from internal and external sources.
• Independently develops programming to mine, analyze, and interpret data from databases that are commonly used in program planning and research.
• Prepares and assists in the presentation of the strategic metrics.
• Works closely with executives, leadership, managers, service line leaders, and others to ensure accuracy and timeliness of reporting and success of assigned projects. Develop and incorporate service line clinical, quality, and operational reports, scorecards, and databases utilized by leadership.
• May complete unit/department specific duties as outlined in department documents.

REQUIRED QUALIFICATIONS

• Bachelor's degree in health administration, public health, computer science, statistics, business administration, data science, or a related field, or an equivalent combination of education and experience from which comparable knowledge, skills and abilities can be acquired.
• Two (2) years of experience in decision support, analysis, or quality reporting and/or quality and process improvement via cross-functional teams.

PREFERRED QUALIFICATIONS

• Master's degree in health administration, business administration, data science, or a related field.
• One (1) year of healthcare experience.
• Experience in SQL and data reporting and visualization is strongly preferred.
• Business intelligence experience (i.e. Tableau, Business Objects, Cognos, Cerner HealtheIntent, Python, and/or R).
• Additional license/certification requirements as determined by the hiring department.

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met with or without reasonable accommodation. The performance of these physical demands is an essential function of the job. The employee may be required ambulate, remain in a stationary position and position self to reach and/or move objects above the shoulders and below the knees. The employee may be required to move objects up to 10 lbs.

Equal Employment Opportunity

The University of Missouri is an Equal Opportunity Employer.