Healthcare Business Intelligence Developer

Description

As a member of the Strategic Development & Analytics team the Healthcare Business Intelligence Developer is responsible for leading the development of reporting and analytics solutions for multiple business units in the Faculty Practice Group. Leveraging UCLA's electronic health record (Epic), the Healthcare BI Developer will gather business needs, document requirements, identify appropriate data sources, develop dashboards and reporting tools for stakeholders. The Healthcare BI Developer will act as lead strategic partner to support leadership's understanding of current performance trends and assist in the decision-making process. The incumbent is responsible for leading in depth and precise business process investigation, documentation of future-state reporting specifications and application reporting functionality. The Healthcare BI Developer must achieve in-depth knowledge of relevant software applications as well as understand policies, procedures and constraints.

Key responsibilities include :

• Meet with stakeholders to gather data requirements, document specifications, clarify needs, and ensure accuracy.
• Design, develop, validate, and test reports, dashboards, and data extracts using tools like Excel, Tableau, Power BI, SSRS, Caboodle, Clarity, and other BI platforms.
• Translate complex technical concepts and analytical findings for both technical and non-technical audiences, supporting collaboration and decision-making.
• Monitor BI outputs, identify performance issues, and implement optimizations to improve efficiency and accuracy.
• Analyze large sets of healthcare data, including EHRs, clinical, and financial data, to generate insights and recommendations.
• Improve documentation, scheduling, and administrative workflows to enhance operational efficiency and reduce errors.
• Train healthcare staff on informatics tools, create user guides and workshops, and provide ongoing support for dashboards, reports, and BI tools.
• Participate in data validation, QA efforts, and analytics development to ensure accurate and reliable reporting solutions.
• Manage the BI object inventory, ensuring metadata is meaningful, standardized, accurate, and consistently updated.
• Maintain reporting data models for assigned Epic applications, managing Clarity & Caboodle objects for both published and ad hoc analytics.
• Oversee Epic measures and metrics, ensuring alignment with the Epic Metrics Catalog and UCLA standards.
• Evaluate analytics tool upgrades, assess risks to existing BI outputs, and recommend mitigation strategies for seamless implementation.

Salary Range : $95,400 - $208,300 / Annually

Qualifications

Eight years or more of experience performing BI development and data analysis is required

Five or more years of experience in a healthcare related organization (Medical Group, Hospital, Health System or Insurance Plan) is required

Five or more years demonstrated expertise in MS SQL Server or Oracle is required

Bachelor's Degree in related field with a foundational experience in Bl, data analysis, programming, database management or statistical analysis, or a combination of equivalent years of education, training and experience

MS, MHA or MBA degree preferred

Consulting experience preferred

Epic Clarity Data Model certification in one or more modules (EpicCare Inpatient, Tapestry, Hospital Billing, Prelude ADT, Radiant, Willow, Optime) or Epic trained with several years of direct work experience strongly desired

Experience in Quality Measures Reporting preferred

Epic build experience in a live environment strongly preferred

Epic implementation experience specific to clinical workflows and order management strongly preferred

Strong SQL Programming Skills (MS SQL Server / Oracle platforms)

Knowledge of data warehouse concepts, data structures and reporting

Extensive knowledge of Microsoft Excel, Tableau dashboard, functions, features, and capabilities

Extensive knowledge of best practices regarding reporting, workflows, policies, procedures, systems and culture in the healthcare environment

Strong analytical, problem-solving and metadata skills

Ability to translate business questions and requirements into reports, views, and BI query objects

Ability to communicate with stakeholders at all levels to understand requirements

Ability to manage multiple and competing tasks while maintain timelines