Provide the tools necessary to deliver cutting-edge health care and groundbreaking research. As part of our Information Technology team, you’ll ensure that our medical professionals have access to the latest breakthroughs in technology, and you’ll play a key role in protecting our global patient community.
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 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.
Salary range: $102500- $227700
Required Skills:
- 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 Skills:
- 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.
EMPLOYMENT SCAM ALERT:
UCLA Health Recruitment is currently being targeted by scam artists through external job board sites. Review some tips in order to avoid becoming targeted. El reclutamiento de salud de UCLA actualmente está siendo atacado por estafadores a través de sitios de juntas de trabajo externos. Revisar algunos consejos para evitar ser apuntado.
“The environment is nurturing and fosters growth. When I come to work, I know what I'm doing matters.”
VINCENT, Sr. CLS Specialist, Toxicology
MONICA
I've been blessed to touch so many lives through my serving. It's a privilege to uplift other employees with words of encouragement and a smile.
SOZIT
The first thing i noticed when i joined the team was how everyone is very welcoming and friendly with supportive management. I did not feel like an outsider.
EDGAR
Once I joined, I knew UCLA Health was THE place to be due to the growth potential and training offered
RENE
If you want to grow professionally, this is the right place for you.
ERA
We are family here. We support each other. We collect together.
ELIZABETH
It’s so diverse and inclusive here. There’s always the opportunity to share your thoughts. It's a place where you feel you belong.
JERRY
Your career path at UCLA Health will enable you to follow a myriad of avenues and turns. It opens up a wide variety of opportunities.
ORLANDO
There’s a togetherness and higher level of commitment to teamwork at UCLA Health. We are several groups and teams that work together with a common goal which is to improve our patients experience.
DAVID
UCLA Health walks the walk and talks the talk! It's an incredible feeling to work for an organization that always puts the patient first. I am honored to work in full alignment with the UCLA Health Mission and Vision.
DR. ISLA GARRAWAY
UCLA has incredible resources and a team science approach. The ability to work with collaborative teams and access the amazing resources around campus is the best part about being at UCLA.
RADU
UCLA is very diverse in its personnel as well as its many research fields studied
JENNA
UCLA Health provides so many opportunities to exchange ideas, share moments and grow. I have learned a lot about team management and relationship building.
SHARON
I was looking for a job to further my career and continue to improve and learn as a therapist.
TARO
I have been blessed to be surrounded by supportive colleagues who aspire me to be the best version of myself.
Awards & recognition
