Business Solution Architect

University of California - Los Angeles Health; Los Angeles (CA); On-site; USD 95,400 - 208,300; Full time

Job summary

University of California - Los Angeles Health is seeking a Business Solutions Architect to design and deliver BI and analytics solutions for Managed Care decision-making. You will develop dashboards and reports using Tableau, Power BI, Epic Clarity, and Caboodle, and apply Python-based workflows for data transformation and advanced analytics.

The role partners with clinical, operational, and business stakeholders to translate needs into scalable analytics, with a focus on accuracy, reliability,

Qualifications

• 8+ years of progressively responsible BI/analytics experience
• Bachelor's degree or equivalent
• Interprets and models complex healthcare data (claims, authorizations, provider data)
• Strong SQL skills in MS SQL Server or Oracle
• Python for data processing and analytics workflows
• Designs and validates dashboards/reports in Tableau or Power BI
• Translates business questions into technical specs and data models
• Experience resolving data quality and reporting issues
• Excellent communication to technical and non-technical audiences

Responsibilities

• Design, develop, and maintain dashboards/reports using Tableau/Power BI, Epic Clarity, Caboodle
• Collaborate with stakeholders to gather requirements and translate into analytics solutions
• Apply Python for data transformation, automation, and advanced analytics workflows
• Analyze healthcare data (claims, authorizations, provider data) for trends and improvements
• Ensure data quality, validation, and troubleshooting of reporting outputs
• Monitor performance and optimize reporting across multiple analytics initiatives
• Provide end-user guidance and documentation for reporting and interpretation
• Support cross-functional analytics projects across clinical, operational, and business teams
• Leverage enterprise analytics tools and healthcare data models, including Epic Clarity

Skills

BI/analytics experience

SQL

Python

Tableau

Power BI

Epic Clarity

Caboodle

data modeling

dashboards/reports design

communication

Education

Bachelor's degree

Tools

Tableau

Power BI

Epic Clarity

Caboodle

MS SQL Server

Oracle

Job description

Description

The Business Solutions Architect designs and delivers business intelligence and analytics solutions that support Managed Care related operational and strategic decision‑making across UCLA Health's Faculty Practice Group. This role will be working closely with the Managed Care Department. This role partners with clinical, operational, and business stakeholders to develop dashboards, reports, applied AI and data solutions using Epic Clarity, Tableau, Power BI, and SQL‑based reporting tools.

Key Responsibilities

• Design, develop, and maintain complex dashboards, reports, and data extracts using Tableau, Power BI, Epic Clarity, and Caboodle.
• Leverage Python for data transformation, automation, and advanced analytics workflows.
• Integrate LLM‑based capabilities for summarization, classification, and insight generation (e.g., call center analytics, CRM insights).
• Analyze healthcare and managed care data, including claims, authorizations, and provider data, to identify trends, performance gaps, and opportunities for operational improvement.
• Partner with business and clinical stakeholders to gather reporting requirements and translate business needs into scalable analytics and reporting solutions.
• The position applies advanced knowledge of enterprise analytics tools and healthcare data models, including Epic Clarity, to deliver scalable and reliable reporting solutions.
• Perform data validation, quality assurance testing, and troubleshooting to ensure accuracy, reliability, and consistency of reporting outputs.
• Monitor and optimize reporting performance while resolving complex data and system issues.
• Support cross‑functional analytics initiatives by providing insights, documentation, and end‑user guidance related to reporting and data interpretation.

Salary Range: $95,400 - $208,300 annually

Qualifications

All items are required:

• Minimum 8 years or more of progressively responsible experience in business intelligence, analytics, or data reporting
• Bachelor's degree in a related field and/or equivalent combination of education and experience
• Interprets and models complex healthcare data, including managed care claims, authorizations, and provider datasets
• Applies advanced knowledge of business intelligence practices, analytical methodologies, and industry best practices
• Utilizes advanced SQL skills in enterprise databases such as MS SQL Server or Oracle
• Experience using Python for data processing, automation, and analytics workflows
• Designs and validates complex dashboards and reports using visualization tools such as Tableau or Power BI
• Translates complex business questions into technical specifications, data models, and analytical solutions
• Resolves highly complex data quality, integration, and reporting issues using structured problem‑solving approaches
• Communicates complex analytical findings clearly to technical and non‑technical audiences
• Manages multiple analytical initiatives independently under general direction
• Applies strong organizational and project coordination skills across large, multi‑stream analytics efforts

Highly Preferred

• Epic Clarity or Tapestry certification
• Tableau Desktop Specialist or equivalent
• Microsoft Power BI Data Analyst (PL 300)
• Demonstrates advanced collaboration skills with clinical, operational, and technical stakeholders
• Applies Epic Clarity reporting knowledge, particularly within managed care related modules