Job 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: $98,200 - $214,600/Annually 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 As a condition of employment , the final candidate who accepts an offer of employment will be required to disclose if they have been subject to any final administrative or judicial decisions within the last seven years determining that they committed any misconduct; or have filed an appeal of a finding of substantiated misconduct with a previous employer. Current/former UC employees are subject to a personnel file review.

Requirements

Must-haves

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.
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
Epic Clarity or Tapestry certification
Tableau Desktop Specialist or equivalent
Microsoft Power BI Data Analyst (PL 300)

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

aisqlpythonllm

Platform: avature
Effort: medium