IT Business Intelligence Developer

University of California - San Francisco; San Francisco (CA); On-site; USD 140,000 - 190,000; Full time

Job summary

University of California, San Francisco is seeking a Business Intelligence Developer to lead clinical informatics reporting and analytics across Epic EHR systems, Beaker, Tableau, and related platforms.

The role emphasizes expert data visualization, advanced SQL, and collaboration with UCSF Health and affiliated hospitals to drive operational performance and patient care improvements.

Qualifications

• Bachelor's degree or equivalent in health care IT, CS or related field.
• 5–7 years of related experience.
• Expert knowledge of EHR applications and data handling.

Responsibilities

• Develop and optimize EHR reporting and analytics across Epic tools and Tableau.
• Lead data extraction, reporting, and visualization for clinical operations and management decisions.
• Support Beaker analytic reporting for UCSF Health and affiliates with high-quality insights.
• Collaborate with clinical and IT teams to translate workflows into technical requirements.

Skills

Clinical informatics

Epic applications knowledge

Strong communication

Education

Bachelor's degree in health care IT / CS

Tools

Tableau

SQL Server

Reporting Workbench

Radar

SlicerDicer

Crystal Reports

Beaker

Job description

Certain terms and conditions of employment for this position, including the rate of pay, benefits, etc., are currently subject to negotiation with the appropriate union.

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 decisionmaking. 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.

Attention to detail and strong communication skills are essential. 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.

At UCSF, collaboration and innovation are central to our mission across hospitals, clinics, classrooms, labs, and administrative environments. To advance excellence in patient care, research, and education, we are strengthening our onsite presence across the university. As part of this commitment, most IT teams support campus-based work. 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.

Department Overview

Enterprise Information and Analytics (EIA) advances UCSF's institutional priorities by enhancing access to and the use of data and analytics, including appropriate data platforms and data governance, in a manner that meets the unique needs across the education, research, and care mission areas

• 10% Collaborates with Benioff Children’s Hospitals and UCSF Health business, technical, and clinical leaders to plan, develop, implement, and analyze highly-complex clinical informatics systems, and to design integrated architecture to ensure an optimal and efficient user experience and functionality, integrity, and reliability of systems.
• 15% Serves as an EHR application and analytics technical leader in collaborating with business operations, healthcare clinicians, and IT applications and technical teams at Benioff Children’s Hospitals and UCSF Health to translate operations workflow and patient experience objectives into technical requirements. Communicates clearly and effectively to others using all communication forms. Develops and maintains good working relationships with customers and teams with whom they work with.
• 20% Develops high quality data and analytics solutions within all EHR reporting tools including but not limited to reporting workbench, radar, slicerdicer, and crystal reports to improve clinical informatics results and to provide advice and sophisticated metrics and analytics to support management/decision-making processes for systems modifications that are cost-effective, scalable, and meet present and future needs.
• 25% Designs and runs SQL (Structured Query Language) queries for enhanced and complex medical data access, and performs highly-complex quality assurance testing, and plans, develops, and writes documentation of design and deployment processes, workflows, and results.
• 15% As a technical leader and information resource, may provide support, troubleshooting, and problem solving at an advanced level, and may produce and deliver user training curricula.
• 15% SlicerDicer expertise in Beaker data models.
• 100% (To update total %, enter the amount of time in whole numbers (without the % symbol - e.g., 15, 20) then highlight the total sum (e.g., 1%) at the bottom of the column and press F9. The total sum should add up to 100%. )

REQUIRED QUALIFICATIONS

• 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 on EHR application(s) and a good working knowledge of how the application(s) collect and store data.
• High proficiency with EHR reporting tools, SQL, as well as in the use of 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 utilizing Slicerdicer, Tableau Desktop and/or Tableau Server
• Broadly encompassing or highly in-depth knowledge of 1-2 areas of focus in clinical informatics specialty areas, but predominantly in Beaker. Knowledge of controlled terminology, clinical workflows, user interface optimization, clinical decision support, rules development, data integration and mining, clinical ontologies, and adoption of technology.
• In-depth knowledge of all relevant clinical informatics software and systems, especially Beaker, and of the highly complex concepts, principles, policies, methodologies, techniques, best practices, regulations, and standards practices involved with patient care and electronic medical data management in the UC health care system.
• Advanced interpersonal communications skills, to convey highly technical information and instructions to all levels of clinical users in a clear and concise manner, to provide technical support, and to develop and deliver training materials as needed.
• Ability to apply advanced problem-resolution skills to highly complex issues, quickly diagnose problems, and develop, test, and implement appropriate and effective solutions in a timely manner.
• Advanced analytical skills and expertise in documentation and reporting, with the ability to apply metrics, design and run queries, collect and analyze performance data, and produce sophisticated reports and analyses for management use.
• Advanced ability to serve as a technical leader and information resource for Beaker, and to work collaboratively with senior staff and management across departments, providing advice, counsel, and analysis on issues of policy, functionality, system efficiency, upgrades, business analytics, and industry advances and trends.
• May be responsible for leading/mentoring other developers within the team

REQUIRED CERTIFICATIONS

• Clarity Data Model

PREFERRED QUALIFICATIONS

• Master's degree or doctorate in computer science or related area.
• Advanced organizational and project management skills, with the ability to lead a team, prioritize tasks, and see projects through from inception to completion on schedule.
• Having an in depth understanding of both the clinical and business workflows to achieve strategic outcomes for the implementation
• CERTIFICATIONS
  • Cogito Fundamentals
  • Access / Clinical / Revenue Data Model
  • Caboodle Data Model

About UCSF

The University of California, San Francisco (UCSF) is a leading university dedicated to promoting health worldwide through advanced biomedical research, graduate-level education in the life sciences and health professions, and excellence in patient care. It is the only campus in the 10-campus UC system dedicated exclusively to the health sciences. We bring together the world's leading experts in nearly every area of health. We are home to five Nobel laureates who have advanced the understanding of cancer, neurodegenerative diseases, aging and stem cells.

Join us to find a rewarding career contributing to improving healthcare worldwide.

Pride Values

UCSF is a diverse community made of people with many skills and talents. We seek candidates whose work experience or community service has prepared them to contribute to our commitment to professionalism, respect, integrity, diversity and excellence - also known as our PRIDE values.

In addition to our PRIDE values, UCSF is committed to equity - both in how we deliver care as well as our workforce. We are committed to building a broadly diverse community, nurturing a culture that is welcoming and supportive, and engaging diverse ideas for the provision of culturally competent education, discovery, and patient care. Additional information about UCSF is available here.

Equal Employment Opportunity

The University of California is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected status under state or federal law.

Salary Information

The final salary and offer components are subject to additional approvals based on UC policy.

Your placement within the salary range is dependent on a number of factors including your work experience and internal equity within this position classification at UCSF. For positions that are represented by a labor union, placement within the salary range will be guided by the rules in the collective bargaining agreement.

To learn more about the benefits of working at UCSF, including total compensation, please visit: https://ucnet.universityofcalifornia.edu/compensation-and-benefits/index.html