Apply on Employer Site

UCLA Health · 2 months ago

Business Intelligence Developer, Ambulatory Transformation and Performance

Los Angeles, CA

Full-time

Onsite

Mid, Senior Level

$102K/yr - $228K/yr

5+ years exp

UCLA Health is seeking a Business Intelligence Developer to join their Ambulatory Transformation and Performance team. The role involves developing and delivering advanced reporting and analytics solutions to enhance the operation of ambulatory clinics, ensuring data integrity and system reliability while collaborating with clinical, technical, and business teams.

Hospital & Health Care

Responsibilities

Lead the development and optimization of complex SQL queries, views, and stored procedures for data analysis and reporting for ambulatory operations

Design, develop, and perform thorough functional testing of reports and dashboards utilizing reporting tools and data sources such as CDW/Clarity, Reporting Workbench, Data Marts, Tableau, and other Business Intelligence Tools

Monitor the performance of reports and take corrective action to optimize or improve the performance when necessary

Perform advanced quality assurance testing and document system changes to ensure high standards of performance

Track operational metrics and perform sensitivity analysis to explain the contribution of factors affecting various measures

Assess the impact of attributes (e.g., physicians, departments, practice locations) on measures at both summary and drill-down levels

Serve as a subject matter expert in clinical informatics, providing advanced technical support and troubleshooting

Lead the development and implementation of the organization's clinical information systems and tools, ensuring they align with the needs of ambulatory operations

Collaborate with business, technical, and clinical leaders to plan, develop, implement, and analyze complex clinical informatics systems

Design integrated architecture to ensure optimal user experience, functionality, integrity, and reliability of systems

Manage the operational analytics program life cycle through initiation, planning, validation, execution, and deployment

Lead project teams, including advanced business and clinical staff, to improve clinical informatics results and provide sophisticated metrics and analytics to support management’s decision-making processes

Provide operational analysis and calculate physician productivity; produce the PSRA Summary Report

Produce monthly Tableau dashboards for senior department leadership and ambulatory operations directors, focusing on referral leakage, KPI metrics, new patient lag days, exam room utilization, and financial and operational trends

Assist in the collection of data from clinic and division Managers, Operations Directors, Departmental Finance, and other offices

Collaborate with stakeholders to understand business needs for reporting requests. Gather requirements, document, clarify, and interpret specifications, reviewing for completeness and accuracy

Work closely and collaboratively with end-users and other stakeholders to ensure the right reporting tools are used to maximize value

Provide guidance to other team members to promote the use of published data reports

Work with end-users to resolve problems promptly, ensuring tasks are completed with quality and within expected timeframes

Provide ongoing user training and produce and deliver user training curricula

Qualification

SQL programmingData architectureHealthcare experienceAnalytical skillsProject managementInterpersonal communicationPythonTableauDatabricksAzure DevOpsMicrosoft FormsPower AutomateMicrosoft Visual StudioGit

Required

Minimum of 3+ years of experience in a healthcare-related organization

Minimum of 5+ years of experience in data architecture with strong SQL programming skills (MS T-SQL and/or Oracle PL/SQL)

Bachelor's degree in healthcare information technology, computer science, or a related area, or equivalent combination of experience and training

Proficient understanding of controlled terminology, clinical workflows, user interface optimization, clinical decision support, rules development, data integration and mining, clinical ontologies, and the adoption of technology in healthcare settings

Advanced organizational and project management skills, including the ability to lead teams, prioritize tasks, and manage projects from inception to completion, ensuring timely delivery

Strong interpersonal communication skills, with the ability to clearly and concisely convey highly technical information to all levels of clinical users, provide technical support, and develop and deliver training materials as needed

Advanced problem-resolution skills, capable of diagnosing complex issues quickly and implementing effective solutions in a timely manner

Expertise in analytical skills, documentation, and reporting, with the ability to apply metrics, design and run queries, collect and analyze performance data, and produce sophisticated reports for management use

Proven ability to serve as a technical leader and information resource, working collaboratively with senior staff and management across departments to provide advice, counsel, and analysis on policy, system functionality, efficiency, upgrades, business analytics, and industry trends

Preferred

2+ years of experience in Tableau

Experience with Python

Experience with Databricks

Experience with Azure DevOps

Experience with Microsoft Forms

Experience with Power Automate

Experience with Microsoft Visual Studio

Experience with Git

Company

UCLA Health

Glassdoor3.9

For more than half a century, UCLA Health has provided the best in healthcare and the latest in medical technology to the people of Los Angeles and throughout the world.

Founded in 1955

Los Angeles, CA, US

10001+ employees