IT Business Intelligence Developer

About the role

The Business Intelligence Developer (BID) serves as an expert in clinical informatics, Epic Electronic Health Record (EHR) reporting, and enterprise data visualization tools. The BID applies deep knowledge of Epic applications and demonstrates exceptional skill in partnering with reporting and analytics stakeholders to understand, design, and document complex data needs. This role coordinates all issues that arise during reporting and analytics initiatives and frequently addresses problems without precedent or existing structure across UCSF Health, Benioff Children’s Hospitals, and affiliated organizations.

The BID performs advanced data analysis using independent judgment and technical expertise to support outstanding patient care, operational performance, quality improvement, and strategic decision-making. Core responsibilities include developing and optimizing EHR reporting, data analysis, and visualization solutions across multiple systems—Epic reporting tools, SQL, Tableau, and related platforms. This position also participates in clinical systems application teams to evaluate data, gather stakeholder feedback, and leverage analytics to support hospital, clinic, staff, program, and operational performance.

This role includes dedicated responsibility to support Beaker analytic reporting for UCSF Health and affiliates, ensuring high-quality laboratory analytics, operational insights, and clinical reporting across the enterprise. The BID helps users adopt development standards, improve reporting practices, and enhance data visualization capabilities. The role requires expert knowledge of Epic applications and reporting tools—including Reporting Workbench, Radar, SlicerDicer, SQL Server, and Tableau—as well as advanced analytical abilities in data extraction, report generation, and information visualization. The BID may also develop training materials and educate end users on reporting tools and functions.

This role will be expected to work onsite on a rotational or alternative schedule as determined by the hiring manager, and may be required to attend onsite events as scheduled by management.

Responsibilities

• Develop and optimize EHR reporting, data analysis, and visualization solutions using Epic reporting tools, SQL, Tableau, and related platforms.
• Support Beaker analytic reporting for UCSF Health and affiliates, ensuring high-quality laboratory analytics, operational insights, and clinical reporting.
• Coordinate and address issues arising during reporting and analytics initiatives, including problems without precedent or existing structure.
• Perform advanced data analysis to support patient care, operational performance, quality improvement, and strategic decision-making.
• Participate in clinical systems application teams to evaluate data, gather stakeholder feedback, and leverage analytics for performance improvement.
• Help users adopt development standards, improve reporting practices, and enhance data visualization capabilities.
• Develop training materials and educate end users on reporting tools and functions.
• Apply advanced problem-resolution skills to highly complex issues, diagnose problems, and implement effective solutions.
• Serve as a technical leader and information resource for Beaker, collaborating with senior staff and management on policy, functionality, and system efficiency.
• Lead or mentor other developers within the team.

Requirements

• Bachelor's degree in health care information technology, computer science, or related area, and/or equivalent combination of experience/training.
• 5 – 7 years of related experience.
• Expertise in EHR applications and a strong understanding of how the applications collect and store data.
• High proficiency with EHR reporting tools, SQL, and business intelligence tools such as SAP universe, web intelligence, and Crystal Reports.
• Ability to perform complex data analysis with large volumes of data.
• Prior experience developing self-service analytic tools using SlicerDicer, Tableau Desktop, and/or Tableau Server.
• Broad or in-depth knowledge of 1-2 clinical informatics specialty areas, particularly Beaker.
• Knowledge of controlled terminology, clinical workflows, user interface optimization, clinical decision support, rules development, data integration and mining, clinical ontologies, and technology adoption.
• In-depth knowledge of clinical informatics software and systems, especially Beaker, and of complex concepts, principles, and best practices related to patient care and electronic medical data management in the UC health care system.
• Advanced interpersonal communication skills to convey technical information clearly to all levels of clinical users, provide support, and develop training materials.
• Advanced analytical skills for documentation, reporting, metrics, query design, data collection, and performance analysis.

Preferred Qualifications

• Master’s degree or doctorate in computer science or related area.
• Advanced organizational and project management skills, with the ability to lead teams and prioritize tasks.
• In-depth understanding of both clinical and business workflows to achieve strategic outcomes.

Required Certifications

• Clarity Data Model
• Cogito Fundamentals
• Access / Clinical / Revenue Data Model
• Caboodle Data Model

Pay

The final salary and offer components are subject to additional approvals based on UC policy. Placement within the salary range is dependent on factors including work experience and internal equity. For represented positions, placement will be guided by the collective bargaining agreement.

Benefits

To learn more about the benefits of working at UCSF, including total compensation, please visit: UCnet Benefits.