Healthcare Business Intelligence Developer

Acord (association For Cooperative Operations Research And Development); Los Angeles (CA); On-site; USD 92,000 - 203,000; Full time

Job summary

An established industry player is seeking a Healthcare Business Intelligence Developer to lead the development of reporting and analytics solutions for various business units. This role involves collaborating with stakeholders to gather requirements, designing dashboards, and analyzing large healthcare datasets to drive insights. The ideal candidate will have extensive experience in BI development, particularly within healthcare, and will be adept at using tools like SQL, Tableau, and Power BI. If you are passionate about data and its impact on healthcare, this is an exciting opportunity to contribute to meaningful projects.

Qualifications

• 8+ years in BI development and data analysis, preferably in healthcare.
• Strong SQL skills and experience with various BI tools required.

Responsibilities

• Develop and test reports and dashboards for healthcare stakeholders.
• Analyze large healthcare datasets to generate insights and recommendations.

Skills

BI Development

Data Analysis

SQL Programming

Healthcare Data Analysis

Effective Communication

Problem-Solving

Education

Bachelor's Degree in a related field

MS, MHA, or MBA degree

Tools

MS SQL Server

Oracle

Excel

Tableau

Power BI

SSRS

Caboodle

Clarity

Job description

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 within the Faculty Practice Group. Leveraging UCLA’s electronic health record (Epic), the Healthcare BI Developer gathers business needs, documents requirements, identifies data sources, and develops dashboards and reporting tools for stakeholders. The role acts as a strategic partner to support leadership in understanding performance trends and aids decision-making. The incumbent conducts in-depth business process investigations, documents future-state reporting specifications, and ensures application reporting functionality. The Healthcare BI Developer must attain in-depth knowledge of relevant software applications and understand policies, procedures, and constraints.

Key Responsibilities

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

Salary Range

$92,600 - $202,200/Annually

Qualifications

• Eight or more years of experience in BI development and data analysis.
• Five or more years of experience in a healthcare-related organization (Medical Group, Hospital, Health System, or Insurance Plan).
• Five or more years demonstrated expertise in MS SQL Server or Oracle.
• Bachelor’s Degree in a related field with foundational experience in BI, data analysis, programming, database management, or statistical analysis, or equivalent education, training, and experience.
• MS, MHA, or MBA degree preferred.
• Consulting experience preferred.
• Epic Clarity Data Model certification in one or more modules or extensive Epic training and experience.
• Experience in Quality Measures Reporting preferred.
• Epic build experience in a live environment strongly preferred.
• Epic implementation experience related to clinical workflows and order management strongly preferred.
• Strong SQL programming skills on MS SQL Server/Oracle platforms.
• Knowledge of data warehouse concepts, data structures, and reporting.
• Extensive knowledge of Microsoft Excel, Tableau, and reporting best practices in healthcare.
• Strong analytical, problem-solving, and metadata skills.
• Ability to translate business requirements into reports and BI objects.
• Effective communication skills with stakeholders at all levels.
• Ability to manage multiple tasks while maintaining timelines.