Business Intelligence Analyst

Founded in 2007, The Oncology Institute of Hope and Innovation (TOI) is advancing oncology by delivering highly specialized, value-based cancer care in the community setting. TOI is dedicated to offering cutting edge, evidence-based cancer care to a population of more than 1.7 million patients including clinical trials, stem cell transplants, transfusions, and other care delivery models traditionally associated with the most advanced care delivery organizations. With 100+ employed clinicians and more than 700 teammates in 75+ clinic locations and growing. TOI is changing oncology for the better.

Founded in 2007, The Oncology Institute of Hope and Innovation (TOI) is advancing oncology by delivering highly specialized, value-based cancer care in the community setting. TOI is dedicated to offering cutting-edge, evidence-based cancer care to a population of more than 1.5 million patients including clinical trials, stem cell transplants, transfusions, and other care delivery models traditionally associated with the most advanced care delivery organizations. With 80+ employed clinicians and more than 600 teammates in 50 clinic locations and growing, TOI is changing oncology for the better. For more information visit www.theoncologyinstitute.com.

JOB PURPOSE AND SUMMARY:

As a Business Intelligence Analyst in oncology, you play a key role by analyzing complex data to identify cost-saving opportunities, optimize pricing strategies, and ensure that new partnerships are profitable. Your work directly supports the financial health of the organization while contributing to the accessibility of life-saving treatments for patients. It’s a chance to have a real impact on both the bottom line and the fight against cancer.

You will leverage your expertise in managed care settings such as health insurance companies, accountable care organizations (ACOs), or healthcare provider groups to help us analyze and interpret complex healthcare data to support strategic decision-making, cost containment efforts, and the optimization of healthcare delivery. 

Essential Roles and Responsibilities

• Generate analysis and develop key insights from various data sources to come up with actionable recommendations.
• Designing and building reports, dashboards, and analyses in Excel, SQL, and Power BI.
• Consult with internal clients to develop analyses that result in actionable insights that accelerate profitable growth or improvements.
• Prepares analysis of current or proposed operations and provides timely and concise recommendations to improve results and performance.
• Define and implement routine reports (weekly / monthly) of key performance metrics and action items and alerts.
• Work closely with other analysts and tech team to define, automate and validate the extraction of new metrics from various data sources for use in future analysis and reports.
• Work with the assigned team, as well as with other business units to solve problems with a holistic approach, owning the analytical portion.
• Perform detailed analysis on assigned projects, recommend potential business solutions, and assist with implementation.
• Identify and analyze user requirements, procedures, and problems to improve existing processes.
• Understand the "why" and "how" of data and be able to tell the story behind the information.
• Ability to thrive in a fast-paced, high-volume, and deadline-driven environment.
• Maintain confidentiality of all pertinent information.
• Bring inconsistencies and problems to the attention of management.
• Complete ad-hoc tasks and assignments as directed by manager.

Requirements

• Bachelor’s Degree in Business, Information Technology, Finance, or similar relevant field
• Has previously been in a role that uses quantitative and qualitative analysis
• Intermediate/Advanced SQL experience, query optimization preferred (2-3 years)
• Experienced with Power BI or willingness to learn (1-2 years)
• Strong Excel and VBA knowledge (2-3 years)
• Excellent working knowledge of PowerPoint and other visualization tools
• Experience presenting to non-technical audiences in a business-oriented manner – excellent written and oral communication skills
• Experienced with Python preferred
• Experienced with Salesforce preferred
• Knowledge or working knowledge of predictive, prescriptive, descriptive, and diagnostic analytics is preferred
• Healthcare Industry experience is preferred

Work Location:
Cerritos, CA (Hybrid – In-office 2x weekly)

Taglines

• World-class cancer care close to home