Business Intelligence Analyst II

LOCATION: Columbia, Missouri

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.

SALARY RANGE $68,266 - $111,426

ABOUT US

MU Health Care is a growing academic health system in mid-Missouri comprised of multiple hospitals - including the region's only Level 1 Trauma Center and region's only Children's Hospital - and over 50 specialty clinics located throughout the region.

As an MU Health Care employee, you will be part of an exceptional team committed to our mission of saving and improving lives and supporting our team members to achieve their personal and professional goals. Our core values of inclusion, respect, service, discovery, responsibility, and excellence foster a collaborative work environment where you can grow your career.

Learn more about MU Health Care. Learn more about living in Columbia, MO.

EMPLOYEE BENEFITS

Health, vision, and dental insurance coverage starting day one

Generous paid leave and paid time off, including 9 paid holidays

Multiple retirement options, including 100% match 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.

ESSENTIAL FUNCTIONS

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

KNOWLEDGE, SKILLS, AND ABILITIES

• Strong critical thinking skills to help predict the needs of various business units and leaders across the system rather than require them to provide detailed prescriptive direction.

• Knowledge and familiarity with business intelligence tools such as Microsoft Power BI, Qlik or Tableau to design and develop reporting analytics and visualizations.

• Knowledge and familiarity with Microsoft Office suite software (Word, Excel, PowerPoint, Outlook, Visio, etc.).

• Interpersonal and communication skills to effectively work and communicate with others.

• Ability to quickly and demonstrate proficiency in new software tools.

• Analytical reasoning and problem-solving skills.

• Ability to document work and communicate progress to others.

• Ability to function with moderate supervision in a fast-paced environment.

• Ability to be detailed and accurate.

• Ability to work under tight deadlines in a highly dynamic environment. Strong analytic and problem-solving skills and ability to interpret results of query analyses.

REQUIRED QUALIFIATIONS

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.