Business Intelligence Analyst II

University of Missouri Health Care • Columbia, MO

2d • $68,266 - $111,426 • Onsite

About The Position

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.

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.

Requirements

• 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.

Nice To Haves

• 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.

Responsibilities

• 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.

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level