Panorama City, California
United States - Nationwide
Pittsburgh, Pennsylvania
Davis, California
Pittsburgh, Pennsylvania
Pittsburgh, Pennsylvania
Posted: 06-Jun-25
Location: Los Angeles, California
Internal Number: 147749700
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.
- 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
