Business Intelligence Developer, Ambulatory Transformation and Performance

General Information

Press space or enter keys to toggle section visibility

Work Location: Los Angeles, CA, USA Onsite or Remote Flexible Hybrid Work Schedule Monday-Friday, 8am-5pm Posted Date 07/07/2025 Salary Range: $102500 - 227700 Annually Employment Type 2 - Staff: Career Duration Indefinite Job # 25464

Primary Duties and Responsibilities

Press space or enter keys to toggle section visibility

The Ambulatory Ops Business Intelligence Developer is an integral member of the Ambulatory Transformation and Performance (ATP) team, responsible for developing and delivering advanced reporting and analytics solutions to support the ATP mission in ensuring the efficient operation of ambulatory clinics to enhance financial viability, optimize performance, and foster informed, data-driven decision-making. This senior technical expert leads the design, implementation, and optimization of clinical informatics systems, with a focus on solving complex technical problems and mentoring junior analysts. The incumbent collaborates closely with clinical, technical, and business teams to ensure data integrity and system reliability, driving the development of actionable insights through advanced analytics. Responsible for developing reporting and analytics solutions for the department/health system users by gathering business needs, documenting requirements, identifying appropriate data sources, developing reports and dashboards, and delivering them to stakeholders. This involves designing and writing of new and/or modifying the existing applications to facilitate goals and meet information and automation needs of department/health system users. Interacts with key stakeholders, leadership, and subject matter experts to develop a deep understanding of analytical needs and translates requirements into business intelligence solutions that drive business decisions, insight, and outcomes through actionable, easy-to-read dashboards and reports.

• 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