Business Intelligence Developer

#CA-FT

Provide technical leadership and perform a variety of duties relating to reporting Clinical Information Systems data. The position will focus on developing reporting solutions to support ongoing operations of UC Davis Health. The incumbent will work with UCDH clinicians and administrators to extract complex datasets from Epic's relational and dimensional databases (Clarity and Caboodle) as well as other databases (e.g., OMOP). This process includes requirements gathering, data retrieval from a variety of clinical and financial data sources, validation, and curation. Projects will require translation of data into informative and actionable visualizations using Tableau, WebI, and Crystal Reports.

Apply By Date: September 25, 2025 at 11:59pm. Selection activities may start at any time.

Minimum Qualifications - For full consideration, applicants are encouraged to upload license and/or certification if required of the position

• Epic certification in one of the following modules: Clarity, Caboodle, or Cogito or equivalent training/experience. If no current certification must obtain certification in two attempts within first 6 months of employment
• Bachelor's degree in Computer Science, Information Systems, Health Informatics, Public Health, Health Care Administration or equivalent experience/training
• Extensive experience designing, creating, testing, and implementing simple to highly complex reports using Business Objects Enterprise reporting tools, Power BI, SlicerDicer, and Tableau.
• 2 years developing data visualizations with Tableau
• 2 years experience with user security for user management and permissions in Tableau Server
• 5 years writing SQL queries and working on query optimization
• 5 years translating user requirements into report specifications
• Proficient use of office automation software (word processing, spreadsheets, visual presentations, etc.)
• Experience with analysis, build, implementation, and support of healthcare information systems
• Work with relational database management systems such as Oracle and/or SQL Server
• Use of a workflow management system such as ServiceNow
• Designing, creating, testing, and implementing simple to highly complex reports using Business Objects Enterprise reporting tools, Power BI, SlicerDicer, and Tableau.
• Ability to execute complex Tableau concepts required to meet difficult requirements
• Ability learn assigned applications and meet proficiency testing requirements, and maintain certification in assigned applications
• Tableau workbook performance troubleshooting in Tableau Desktop and Server
• Understanding of user security for user management and permissions in Tableau Server
• Expert level report writing skills and knowledge of multiple tools to aid in more complex report development
• Knowledge of relational and dimensional data modeling principles and techniques
• Complex SQL concepts and query optimization
• Highly effective interpersonal and communication skills to establish and maintain positive and productive working relationships
• Strong analytical and critical thinking skills
• Knowledge of quality assurance and improvement principles, practices, and tools to reports and reporting tools development
• Highly motivated self-starter with demonstrated leadership and mentoring skills
• Strong written and verbal communication skills
• General knowledge of statistics and analytics
• Proficient in office automation software (word processing, spreadsheets, visual presentations, etc.)
• Knowledge of data security and data governance concepts.
• Expert at workbook performance troubleshooting in Tableau Desktop and Server

Preferred Qualifications

• Epic certifications in all of the following modules: Clarity, Caboodle, and Cogito.
• Experience in an area of healthcare clinical operations.
• Work with Epic's Clarity and/or Caboodle data models
• Experience working with clinical information systems, preferably Epic
• Dashboard development using Tableau, SlicerDicer, and/or Epic Radar.
• Experience creating, testing, and implementing Epic Reporting Workbench reports.
• Experience implementing or supporting an electronic medical record system
• Knowledge of Epic Clarity Console, Compass, troubleshooting, and upgrades
• SQL Server Integration Services
• Knowledge and understanding of University practices, policies, and procedures.
• Knowledge of clinical information systems and electronic medical records, preferably Epic
• Cogito tools including Reporting Workbench, Radar, and Cogito SQL

Key Responsibilities

• 40% - Business Intelligence Development
• 30% - Project Management and Asset Management
• 10% - Data Security and Integrity
• 15% - Communication - Internal and External
• 5% - Personal and Professional Development

Department Overview

The Data Center of Excellence provides clinicians, faculty, and staff the ability to leverage the data-rich electronic health records at UC Davis Health. We integrate clinical, financial, and operational data to provide timely information that adds knowledge and identifies opportunities to improve efficiency and patient care. We develop a variety of data related assets from raw EMR data sources to complex data visualizations.

Department Specific Job Scope

The Business Intelligence Developer (BID) role is part of the EMR Reporting Team within Data Access and Delivery in the Data Center of Excellence and will primarily focus on EMR data provisioning through SQL development, Business Objects, and Tableau business intelligence solutions.

POSITION INFORMATION

• Salary or Pay Range: $8,533.33-$16,866.66
• Salary Frequency: Monthly
• Salary Grade: Grade 25
• UC Job Title: CLIN INFORMATICS SPEC 4
• UC Job Code: 006049
• Number of Positions: 1
• Appointment Type: Staff: Career
• Percentage of Time: 100
• Shift (Work Schedule): Monday-Friday
• Location: UCDHAS Building (HSP165)
• Union Representation: 99 - Non-Represented (PPSM)
• Benefits Eligible: Yes
• This position is hybrid (mix of on-site and remote work)
• This position is not an H-1B visa opportunity.

Benefits

Outstanding benefits and perks are among the many rewards of working for the University of California. UC Davis offers a full range of benefits, resources and programs to help you bring your best self to work, as well as to help you and your family achieve your health, wellness, financial and career goals. Learn more about the benefits below and eligibility rules by visiting either our handy Benefits Summary for UC Davis Health Employees or Benefits Summary for UC Davis Employees and our Benefits Page.

If you are represented by a union, benefits are negotiated between the University of California (UC) and your union and finalized in a contract. Read your bargaining unit's employment contract, stay abreast of current negotiations and learn about collective bargaining at UC: https://ucnet.universityofcalifornia.edu/labor/bargaining-units/index.html

* High quality and low-cost medical plans to choose from to fit your family's needs
* UC pays for Dental and Vision insurance premiums for you and your family
* Extensive leave benefits including Pregnancy and Parental Leave, Family & Medical Leave
* Paid Holidays annually as stipulated in the UC Davis Health Policies or Collective Bargaining Agreement
* Paid Time Off/Vacation/Sick Time as stipulated in the UC Davis Health Policies or Collective Bargaining Agreement
* Continuing Education (CE) allowance and Education Reimbursement Program as stipulated in the UC Davis Health Policies or Collective Bargaining Agreement
* Access to free professional development courses and learning opportunities for personal and professional growth
* WorkLife and Wellness programs and resources
* On-site Employee Assistance Program including access to free mental health services
* Supplemental insurance offered including additional life, short/long term disability, pet insurance and legal coverage
* Public Service Loan Forgiveness (PSFL) Qualified Employer & Student Loan Repayment Assistance Program for qualified roles
* Retirement benefit options for eligible roles including Pension and other Retirement Saving Plans. More information on our retirement benefits can be found here

Physical Demands

• Standing - Frequent 3 to 6 Hours
• Walking - Frequent 3 to 6 Hours
• Sitting - Frequent 3 to 6 Hours
• Lifting/Carrying 0-25 Lbs - Occasional Up to 3 Hours
• Pushing/Pulling 0-25 Lbs - Occasional Up to 3 Hours
• Bending/Stooping - Occasional Up to 3 Hours
• Squatting/Kneeling - Occasional Up to 3 Hours
• Keyboard use/repetitive motion - Occasional Up to 3 Hours

Mental Demands

• Sustained attention and concentration - Frequent 3 to 6 Hours
• Complex problem solving/reasoning - Frequent 3 to 6 Hours
• Ability to organize & prioritize - Frequent 3 to 6 Hours
• Communication skills - Frequent 3 to 6 Hours
• Numerical skills - Occasional Up to 3 Hours
• Constant Interaction - Occasional Up to 3 Hours
• Customer/Patient Contact - Occasional Up to 3 Hours
• Multiple Concurrent Tasks - Frequent 3 to 6 Hours

Work Environment

UC Davis is a smoke and tobacco free campus effective January 1, 2014. Smoking, the use of smokeless tobacco products, and the use of unregulated nicotine products (e-cigarettes) will be strictly prohibited on any UC Davis owned or leased property, indoors and outdoors, including parking lots and residential space.

On-call and any other extraordinary tasks.

Special Requirements - Please contact your recruiter with questions regarding which activities apply by position

• This is a critical position, as defined by UC Policy and local procedures, and as such, employment is contingent upon clearing a criminal background check(s) and may include drug screening, medical evaluation clearance and functional capacity assessment
• This position is designated as a mandated reporter under CANRA and UC policy, and employment is contingent on compliance with applicable policies, procedures and training requirements

Misconduct Disclosure Requirement: As a condition of employment, the final candidate who accepts a conditional offer of employment will be required to disclose if they have been subject to any final administrative or judicial decisions within the last seven years determining that they committed any misconduct; received notice of any allegations or are currently the subject of any administrative or disciplinary proceedings involving misconduct; have left a position after receiving notice of allegations or while under investigation in an administrative or disciplinary proceeding involving misconduct; or have filed an appeal of a finding of misconduct with a previous employer.

A Culture of Opportunity and Belonging

At UC Davis, we're committed to solving life's most urgent challenges and building a healthier, more resilient world. We believe in growing through every challenge, continually striving to improve, and welcoming new perspectives that strengthen our community. We recognize that a vibrant and innovative organization values both individual strengths and shared purpose. The best ideas often emerge when people with different experiences come together.

As you consider joining UC Davis, we invite you to explore our Principles of Community, our Clinical Strategic Plan and strategic vision for research and education. We believe you belong here. The University of California, Davis is an Equal Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age or protected veteran status.

To view the University of California's Anti-Discrimination Policy, please visit: https://policy.ucop.edu/doc/1001004/Anti-Discrimination

Because we want you to feel seen and valued, our recruitment process at UC Davis supports openness and authenticity. Research shows that some individuals hesitate to apply unless they meet every qualification. You may be an excellent fit for this role-or the next one. We encourage you to apply even if your experience doesn't match every listed requirement. #YouBelongHere

To learn more about our background check program, please visit: https://hr.ucdavis.edu/departments/recruitment/ucd/selection/background-checks