Cogito Business Intelligence Developer

#CA-FT

The role of the Cogito Business Intelligence Developer (CBID) involves implementing reporting content and analytics tools to meet clinical and business needs. This position requires an understanding of how data is captured in clinical workflows of multiple EMR applications. Responsibilities include managing customer relationships of all levels of organizational leadership, clinicians, and business operations staff and collaborating with Cogito Business Analysts, Business Intelligence Developers, SlicerDicer Administrators, and analysts on the EMR application teams. The focus of this role includes developing business intelligence solutions in Cogito Palette (Radar dashboards, Reporting Workbench reports) and other tools such as Tableau and Business Objects. Additionally, the position will be required to design and develop complex SQL queries.
The CBID is involved in every aspect of requirements gathering, designing, developing, implementing, and testing dashboards, reports, and metrics. This encompasses requirements gathering, data retrieval, validation, curation, and transforming data into insightful and actionable visualizations. The CBID is expected to create, follow, and uphold best practices and standards in business intelligence. Additional responsibilities include administering and maintaining Cogito hyperspace reporting tools and managing Cogito Security. As a technical leader and information resource, the CBID will provide support, troubleshooting, and problem solving at an advanced level.

Apply By Date: June 3, 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 training and certification in Cogito Fundamentals, Cogito Tools Administration, and Caboodle and Clarity Data Models to be completed within 6 months of onboarding.
• Bachelor's degree or equivalent in health care information technology, computer science, or related area, and/or equivalent combination of experience/training.
• Minimum 5 years of experience building business intelligence solutions using healthcare data.
• 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.
• Ability to apply advanced technical project management concepts with a full understanding of project management practices and IT policies and procedures to manage complex projects.
• Proven ability to lead a project team to successfully meeting project objectives and timelines.
• 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 training.
• 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 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.
• Previous involvement in projects related to hospital operations, critical care, emergency medicine, trauma, etc.
• Expert in Epic's reporting tools including Radar, Reporting Workbench, SlicerDicer
• Extensive experience designing, creating, testing, and implementing simple to highly complex reports using business intelligence tools such as Business Objects (Crystal Reports, WebI), Tableau, or other similar tools.
• Experienced in relational and dimensional data modeling principles and techniques.
• Expert in writing Structured Query Language (SQL) queries and query tuning and optimization.
• Experience developing in Oracle and SQL Server
• Ability to produce high quality deliverables in efficient manner.
• Ability to translate user requirements into report specifications.
• Expert level report writing skills and knowledge of multiple tools to aid in more complex report development.
• Experience with end user workflows for two or more Epic applications

Preferred Qualifications

• Experience provisioning data solutions for Epic Community Connect client organizations
• Knowledge of and experience with Epic's Clarity and/or Caboodle data models
• Tableau expertise
• Business Objects experience
• Skilled in creating visualizations
• Knowledge of Epic Clarity Console, Compass, troubleshooting, and upgrades
• Experience implementing or supporting the Epic electronic medical record system.
• Familiarity with data governance and data stewardship principles and practices
• Epic Cogito Fundamentals, Cogito Tools Administration, Clarity, and Caboodle Data Model Certification

Key Responsibilities

• 30% - Customer Relationship Management
• 40% - Business Intelligence Development
• 20% - Project Management
• 10% - Cogito Tools Administration and Maintenance

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. From raw EMR data sources to highly curated and validated datasets, our data assets go beyond making decisions about patients at the time of care to enabling deeper analyses of patient populations.

Department Specific Job Scope

The Cogito Business Intelligence Developer (CBID) role is part of the Cogito Tools Team within Data Access and Delivery in the Data Center of Excellence and will primarily focus on EMR data provisioning through Epic Cogito Palette, Business Objects, and Tableau business intelligence solutions.

POSITION INFORMATION

• Salary or Pay Range: $8,283.33 - $16,366.67
• 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): Day Time, 8am-5pm Pacific Time
• 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
• Twisting - Never 0 Hours
• Climbing (e.g., stairs or ladders) - Never 0 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.

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