What are the responsibilities and job description for the Business Intelligence Developer position at UCSF Health?
Job Description
The Business Intelligence Developer (BID) functions as the expert for clinical informatics, Electronic Health Record (EPIC) reports and data visualization tools. The BID has expert knowledge on the EHR applications and applies superior ability to work with reporting and data analytics customers to understand, design and document complex reporting and analytics needs and are able to coordinate all issues that arise during the reporting and data analytics assignments and projects. The business intelligence developer will analyze problems often without precedent and/or existing structure within UCSF Health and Benioff Children’s Hospitals, and address complex problems with an organization-wide scope. The BID will perform data analysis using independent judgment and technical expertise. This position will support the delivery of outstanding patient care, operational performance, quality, and improvement efforts to help streamline processes and decision making with a focus on EHR reporting, data analysis and visualization for UCSF Health, Benioff Children’s Hospitals and our affiliates. As part of the data analysis and reporting efforts, this position will focus on providing expertise across different data systems (All Epic EHR reporting tools, SQL, Tableau, etc.). This position also will be part of the clinical systems application teams to manage the analysis of data, evaluation of data, getting feedback from key stakeholders and using data to support the performance of our hospitals, clinics, staff, programs, and operations.
Attention to detail and strong communication are critical skills for this position. Works to help other users learn and adopt the development standards and enjoys helping users enhance their data visualization and reporting skills. Requires strong EHR application knowledge and technical skills, and expert analytical abilities in the areas of data extraction, report generation, and information visualization, including but not limited to all EHR Epic reporting tools, reporting workbench, radar, SlicerDicer, SQL server and tableau. The BID might also develop user training aids and train end users in the use of reports & reporting functions & tools.
At UCSF, collaboration and innovation are at the heart of our mission — in our hospitals and clinics, classrooms, labs, and offices. To advance excellence in support of patient care, research, and education, we are strengthening our on-site presence across the university. As part of this commitment, most IT teams are expected to work in some capacity to support campus-based work. This role will be expected to work onsite on a rotational or alternative basis as determined by the hiring manager. You may also be required to attend onsite events as scheduled by your management team.
Responsibilities
Key Responsibilities
%
of time
Essential Function (Yes/No)
Key Responsibilities
(To be completed by Supervisor)
5
No 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.
25
Yes
Serves as a an EHR application and analytics technical leader in collaborating with business operations, healthcare clinicians, and IT applications and technical teams at Benioff Childrens 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.
30
Yes 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.
20
Yes 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.
20
Yes As a technical leader and information resource, understands and will assess downstream data impacts of workflow changes.Will provide support, troubleshooting, and problem solving at an advanced level, and may produce and deliver user training curricula.
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%.)
Knowledge Skills And Abilities (KSAs)
Knowledge, Skills and Abilities Req / Pref
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. Req
Prior experience developing self-service analytic tools utilizing slicerdicer, tableau desktop and/or tableau server Req
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. Req
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. Req
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. Req
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. Req
Advanced ability to serve as a technical leader and information resource, 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. Req
Having an in depth understanding of both the clinical and business workflows to achieve strategic outcomes for the implementation Pref
May be responsible for leading/mentoring other developers within the team Req
Expertise on EHR application(s) and a good working knowledge of how the application(s) collect and store data.
Req
Expertise on epic clarity and caboodle data structures, with the ability to independently analyze new data models to support analytic and data needs of customers
Req
Qualifications
REQUIRED QUALIFICATIONS
ABOUT US
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.
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 .
Join us to find a rewarding career contributing to improving healthcare worldwide.
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
About The Team
The UCSF IT EIA (Enterprise Information Architecture) Health Finance department is dedicated to developing and managing data-driven technology solutions that optimize financial operations and enhance decision-making within UCSF�s healthcare ecosystem. By leveraging enterprise information architecture, the department ensures the integration and accessibility of financial data to support UCSF�s academic, clinical, and research missions. Specializing in financial data systems, analytics, and reporting, the EIA Health Finance team provides tools and insights that empower UCSF�s leadership, finance teams, and healthcare administrators to make informed decisions. From revenue cycle management and budgeting to cost analysis and forecasting, the department delivers scalable solutions that enable efficient financial planning and resource allocation across UCSF�s healthcare operations. Collaboration is at the core of the department�s approach, working closely with finance teams, IT stakeholders, and institutional leaders to design systems that align with UCSF�s strategic goals. By integrating financial systems with clinical and operational data, the department ensures a holistic view of UCSF�s financial health, enabling seamless workflows and strategic decision-making. The department prioritizes compliance, data security, and accuracy, ensuring that financial systems meet regulatory standards and institutional policies while safeguarding sensitive information. Through innovative technologies and continuous system enhancements, the team supports UCSF�s efforts to modernize financial processes and adapt to changing healthcare demands. Through its commitment to service excellence, collaboration, and innovation, the UCSF IT EIA Health Finance department plays a vital role in supporting UCSF�s mission to advance health worldwide. By enabling data-driven financial strategies, the department ensures UCSF�s resources are effectively managed to sustain excellence in patient care, research, and education.
The Business Intelligence Developer (BID) functions as the expert for clinical informatics, Electronic Health Record (EPIC) reports and data visualization tools. The BID has expert knowledge on the EHR applications and applies superior ability to work with reporting and data analytics customers to understand, design and document complex reporting and analytics needs and are able to coordinate all issues that arise during the reporting and data analytics assignments and projects. The business intelligence developer will analyze problems often without precedent and/or existing structure within UCSF Health and Benioff Children’s Hospitals, and address complex problems with an organization-wide scope. The BID will perform data analysis using independent judgment and technical expertise. This position will support the delivery of outstanding patient care, operational performance, quality, and improvement efforts to help streamline processes and decision making with a focus on EHR reporting, data analysis and visualization for UCSF Health, Benioff Children’s Hospitals and our affiliates. As part of the data analysis and reporting efforts, this position will focus on providing expertise across different data systems (All Epic EHR reporting tools, SQL, Tableau, etc.). This position also will be part of the clinical systems application teams to manage the analysis of data, evaluation of data, getting feedback from key stakeholders and using data to support the performance of our hospitals, clinics, staff, programs, and operations.
Attention to detail and strong communication are critical skills for this position. Works to help other users learn and adopt the development standards and enjoys helping users enhance their data visualization and reporting skills. Requires strong EHR application knowledge and technical skills, and expert analytical abilities in the areas of data extraction, report generation, and information visualization, including but not limited to all EHR Epic reporting tools, reporting workbench, radar, SlicerDicer, SQL server and tableau. The BID might also develop user training aids and train end users in the use of reports & reporting functions & tools.
At UCSF, collaboration and innovation are at the heart of our mission — in our hospitals and clinics, classrooms, labs, and offices. To advance excellence in support of patient care, research, and education, we are strengthening our on-site presence across the university. As part of this commitment, most IT teams are expected to work in some capacity to support campus-based work. This role will be expected to work onsite on a rotational or alternative basis as determined by the hiring manager. You may also be required to attend onsite events as scheduled by your management team.
Responsibilities
Key Responsibilities
%
of time
Essential Function (Yes/No)
Key Responsibilities
(To be completed by Supervisor)
5
No 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.
25
Yes
Serves as a an EHR application and analytics technical leader in collaborating with business operations, healthcare clinicians, and IT applications and technical teams at Benioff Childrens 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.
30
Yes 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.
20
Yes 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.
20
Yes As a technical leader and information resource, understands and will assess downstream data impacts of workflow changes.Will provide support, troubleshooting, and problem solving at an advanced level, and may produce and deliver user training curricula.
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%.)
Knowledge Skills And Abilities (KSAs)
Knowledge, Skills and Abilities Req / Pref
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. Req
Prior experience developing self-service analytic tools utilizing slicerdicer, tableau desktop and/or tableau server Req
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. Req
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. Req
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. Req
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. Req
Advanced ability to serve as a technical leader and information resource, 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. Req
Having an in depth understanding of both the clinical and business workflows to achieve strategic outcomes for the implementation Pref
May be responsible for leading/mentoring other developers within the team Req
Expertise on EHR application(s) and a good working knowledge of how the application(s) collect and store data.
Req
Expertise on epic clarity and caboodle data structures, with the ability to independently analyze new data models to support analytic and data needs of customers
Req
Qualifications
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’ related experience.
- Certifications:
- Clarity Data Model
- 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
- 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.
- 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, 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
- Expertise on EHR application(s) and a good working knowledge of how the application(s) collect and store data.
- Expertise on epic clarity and caboodle data structures, with the ability to independently analyze new data models to support analytic and data needs of customers
- Master’s degree or doctorate in computer science or related area.
- 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 US
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.
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 .
Join us to find a rewarding career contributing to improving healthcare worldwide.
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
About The Team
The UCSF IT EIA (Enterprise Information Architecture) Health Finance department is dedicated to developing and managing data-driven technology solutions that optimize financial operations and enhance decision-making within UCSF�s healthcare ecosystem. By leveraging enterprise information architecture, the department ensures the integration and accessibility of financial data to support UCSF�s academic, clinical, and research missions. Specializing in financial data systems, analytics, and reporting, the EIA Health Finance team provides tools and insights that empower UCSF�s leadership, finance teams, and healthcare administrators to make informed decisions. From revenue cycle management and budgeting to cost analysis and forecasting, the department delivers scalable solutions that enable efficient financial planning and resource allocation across UCSF�s healthcare operations. Collaboration is at the core of the department�s approach, working closely with finance teams, IT stakeholders, and institutional leaders to design systems that align with UCSF�s strategic goals. By integrating financial systems with clinical and operational data, the department ensures a holistic view of UCSF�s financial health, enabling seamless workflows and strategic decision-making. The department prioritizes compliance, data security, and accuracy, ensuring that financial systems meet regulatory standards and institutional policies while safeguarding sensitive information. Through innovative technologies and continuous system enhancements, the team supports UCSF�s efforts to modernize financial processes and adapt to changing healthcare demands. Through its commitment to service excellence, collaboration, and innovation, the UCSF IT EIA Health Finance department plays a vital role in supporting UCSF�s mission to advance health worldwide. By enabling data-driven financial strategies, the department ensures UCSF�s resources are effectively managed to sustain excellence in patient care, research, and education.