University of Colorado Anschutz Medical Campus

School of Medicine | Department of Psychiatry

Job Title: Business Intelligence Developer (Intermediate – Senior Level)

Position: #00835756 – Requisition: #36981

Job Summary

Business Intelligence (BI) Developer is the Department of Psychiatry’s Business Intelligence professional responsible for analyzing, reporting, visualization & dashboarding in key domains including finance, revenue cycle, clinical operations, quality & productivity, human resources, and clinical research. This position works under the supervision of the BI Manager to create and maintain databases, database objects, reports, Epic artifacts, and dashboards and performs analyses using these functions.

The BI Developer collaborates closely with key stakeholders in the Department to ensure the intelligence and analyses are accurate, user-friendly, and impactful. To be able to work independently, BI Developer must have intimate knowledge of finance (including but not limited to sponsored projects, clinical, and auxiliary enterprise finance), accounting, revenue cycle, clinical operations, and human resources. The overall goal of this position is to advance the Department’s capacity for data-driven decision making in key domains to achieve the vision of Brain Health for All, For Life.

Key Responsibilities

Maintain existing database to house financial data from multiple organizations including CU Anschutz, CU Medicine, the CU Foundation, and other organizations as appropriate.
Achieve and maintain Epic certifications that enable access to data and dashboarding capabilities at hospital partners (e.g., Children’s Hospital Colorado and UCHealth).
Maintain and improve unified system for FTE planning and clinical FTE reporting. Develop research project-specific reports and dashboards with PI and stakeholders as prioritized by Data Governance Committee
Create and maintain end user documentation that defines fields, metrics, business rules, and best practices to allow users to use reporting and analytics efficiently and effectively.
The BI Developer may have other duties and responsibilities as assigned such as user training, change management, presentations, and professional development.

Work Location

Remote – This role is eligible to work remotely, but the employee must be in the United States.

Why Join Us

The Department of Psychiatry is one of the largest units in the UCD-SOM and is comprised of 5 Divisions. The CU Department of Psychiatry sets the standard for Education and Training of leaders in psychiatry and mental health care, conducts Updated July 2023 Page 9 of 7 ground-breaking research that aims to eradicate suffering due to psychiatric and substance use disorders, provides ready access to state of-the-art mental health preventions and interventions across the continuum of care, and collaborates with the community and other key stakeholders to promote well-being among all Coloradans. We accomplish this vision in a manner that respects, values and advocates for the dignity and worth of each individual and family.

Why work for the University?

We have AMAZING benefits and offer exceptional amounts of holiday, vacation, and sick leave! The University of Colorado offers an excellent benefits package including:

Medical: Multiple plan options
Dental: Multiple plan options
Additional Insurance: Disability, Life, Vision
Retirement 401(a) Plan: Employer contributes 10% of your gross pay
Paid Time Off: Accruals over the year
Vacation Days: 22/year (maximum accrual 352 hours)
Sick Days: 15/year (unlimited maximum accrual)
Holiday Days: 10/year
Tuition Benefit: Employees have access to this benefit on all CU campuses
ECO Pass: Reduced rate RTD Bus and light rail service

There are many additional perks & programs with the CU Advantage.

Qualifications

Minimum Qualifications

Intermediate Level

A bachelor’s degree in business intelligence, information technology, data analysis, or a directly related field from an accredited institution.
A combination of education and related technical/paraprofessional experience may be substituted for the bachelor’s degree on a year for year basis.
One (1) year of experience creating reports, visualizations, and/or analytics within a large organization (serving over 100 employees).
Experience with common business intelligence tools such as PowerBI and Tableau and integrating such tools with various database technologies.

Senior Level

A bachelor’s degree in business intelligence, information technology, data analysis, or a directly related field from an accredited institution.
A combination of education and related technical/paraprofessional experience may be substituted for the bachelor’s degree on a year for year basis.
Two (2) years of experience creating reports, visualizations, and/or analytics within a large organization (serving over 100 employees).
Experience with common business intelligence tools such as PowerBI and Tableau and integrating such tools with various database technologies.

Applicants must meet minimum qualifications at the time of hire.

Preferred Qualifications

A master’s or higher in business intelligence, information technology, mathematics, statistics, data analysis, or a directly related field from an accredited institution.
One (1) year of experience with Epic Caboodle data warehouse and extending Caboodle.
One (1) year of experience with Epic Clarity and creating custom tables enriched by Clarity data using scheduler and stored procedures.
Experience with non-Epic enterprise data warehouses using various database technologies such as Microsoft and Oracle.
Experience creating and maintaining stored procedures, tables, scheduled jobs, and other database artifacts.
Experience using PeopleSoft Finance and HR, Microsoft AX, or other systems used by CU Anschutz or its affiliates.
Experience in behavioral health.
Experience with Power Automate, DAX, VBA, Python, and/or R.
Experience in finance, revenue cycle management, clinical operations, and human resources practices at CU Anschutz or its affiliates.
Experience in academic medicine or healthcare.
Experience in mental health and knowledge of mental health billing.
Experience with data structures, data table design, and data pipelining.

Conditions of Employment

Epic Certifications in Cogito, Clarity, and Caboodle, and at least one of Clinical Data Model or Revenue Cycle Data Model or ability to obtain required certifications within twelve months of hire.

Knowledge, Skills, and Abilities

Basic level knowledge of Structured Query Language (SQL) and Power Automate, DAX, VBA, Python, and/or R.
Expert level knowledge of Microsoft Access, Power BI, and Microsoft Excel.
Knowledge of Microsoft 365 suite including Outlook, Word, Power Point, and Teams.
Proficiency with Epic Cogito, Clarity, and Caboodle.
High level of analytical ability.
Experience with or knowledge of research methods, data gathering and dissemination.
Ability to communicate effectively, both in writing and orally.
Ability to work independently and under minimal supervision.
Ability to establish and maintain effective working relationships with employees at all levels throughout the institution.
Outstanding customer service skills and ability to navigate competing priorities and demands from stakeholders.

How to Apply

For full consideration, please submit the following document(s):

A letter of interest describing relevant job experiences as they relate to listed job qualifications and interest in the position.
Curriculum vitae / Resume
Three to five professional references, including name, address, phone number (mobile number if appropriate), and email address.

Questions should be directed to: Quinton Powell, quinton.washingtonpowell@cuanschutz.edu

Screening of Applications Begins

Immediately and continues until position is filled. For best consideration, apply by July 1st, 2025.

Anticipated Pay Range

The starting salary range (or hiring range) for this position has been established as:

Intermediate Level: $63,391 – $80,633

Senior Level: $68,531 – $87,171

The above salary range (or hiring range) represents the University’s good faith and reasonable estimate of the range of possible compensation at the time of posting. This position may be eligible for overtime compensation, depending on the level.

Your total compensation goes beyond the number on your paycheck. The University of Colorado provides generous leave, health plans and retirement contributions that add to your bottom line.

Total Compensation Calculator

Equal Employment Opportunity Statement

The University of Colorado (CU) is an Equal Opportunity Employer and complies with all applicable federal, state, and local laws governing non-discrimination in employment. We are committed to creating a workplace where all individuals are treated with respect and dignity, and we encourage individuals from all backgrounds to apply, including protected veterans and individuals with disabilities.

ADA Statement

The University will provide reasonable accommodations to applicants with disabilities throughout the employment application process. To request an accommodation pursuant to the Americans with Disabilities Act, please contact the Human Resources ADA Coordinator at hr.adacoordinator@cuanschutz.edu .

Background Check Statement

The University of Colorado Anschutz Medical Campus is dedicated to ensuring a safe and secure environment for our faculty, staff, students, and visitors. To assist in achieving that goal, we conduct background investigations for all prospective employees.

Vaccination Statement

CU Anschutz strongly encourages vaccination against the COVID-19 virus and other vaccine preventable diseases. If you work, visit, or volunteer in healthcare facilities or clinics operated by our affiliated hospital or clinical partners or by CU Anschutz, you will be required to comply with the vaccination and medical surveillance policies of the facilities or clinics where you work, visit, or volunteer, respectively. In addition, if you work in certain research areas or perform certain safety sensitive job duties, you must enroll in the occupational health medical surveillance program.

University Staff

Job Category

Information Technology

Primary Location

Remote

Department

U0001 -- Anschutz Med Campus or Denver

Schedule

Full-time

Posting Date

Aug 20, 2025

Unposting Date

Ongoing

Posting Contact Name

Quinton Powell

Posting Contact Email

quinton.washingtonpowell@cuanschutz.edu

Position Number

00835756

Qualifications

To be able to work independently, BI Developer must have intimate knowledge of finance (including but not limited to sponsored projects, clinical, and auxiliary enterprise finance), accounting, revenue cycle, clinical operations, and human resources
A bachelor’s degree in business intelligence, information technology, data analysis, or a directly related field from an accredited institution
A combination of education and related technical/paraprofessional experience may be substituted for the bachelor’s degree on a year for year basis
One (1) year of experience creating reports, visualizations, and/or analytics within a large organization (serving over 100 employees)
Experience with common business intelligence tools such as PowerBI and Tableau and integrating such tools with various database technologies
A bachelor’s degree in business intelligence, information technology, data analysis, or a directly related field from an accredited institution
A combination of education and related technical/paraprofessional experience may be substituted for the bachelor’s degree on a year for year basis
Two (2) years of experience creating reports, visualizations, and/or analytics within a large organization (serving over 100 employees)
Experience with common business intelligence tools such as PowerBI and Tableau and integrating such tools with various database technologies
Applicants must meet minimum qualifications at the time of hire
Epic Certifications in Cogito, Clarity, and Caboodle, and at least one of Clinical Data Model or Revenue Cycle Data Model or ability to obtain required certifications within twelve months of hire
Basic level knowledge of Structured Query Language (SQL) and Power Automate, DAX, VBA, Python, and/or R
Expert level knowledge of Microsoft Access, Power BI, and Microsoft Excel
Knowledge of Microsoft 365 suite including Outlook, Word, Power Point, and Teams
Proficiency with Epic Cogito, Clarity, and Caboodle
High level of analytical ability
Experience with or knowledge of research methods, data gathering and dissemination
Ability to communicate effectively, both in writing and orally
Ability to work independently and under minimal supervision
Ability to establish and maintain effective working relationships with employees at all levels throughout the institution
Outstanding customer service skills and ability to navigate competing priorities and demands from stakeholders
A letter of interest describing relevant job experiences as they relate to listed job qualifications and interest in the position
Curriculum vitae / Resume
Three to five professional references, including name, address, phone number (mobile number if appropriate), and email address
In addition, if you work in certain research areas or perform certain safety sensitive job duties, you must enroll in the occupational health medical surveillance program

Benefits

We have AMAZING benefits and offer exceptional amounts of holiday, vacation, and sick leave!
The University of Colorado offers an excellent benefits package including:
Medical: Multiple plan options
Dental: Multiple plan options
Additional Insurance: Disability, Life, Vision
Retirement 401(a) Plan: Employer contributes 10% of your gross pay
Paid Time Off: Accruals over the year
Vacation Days: 22/year (maximum accrual 352 hours)
Sick Days: 15/year (unlimited maximum accrual)
Holiday Days: 10/year
Tuition Benefit: Employees have access to this benefit on all CU campuses
ECO Pass: Reduced rate RTD Bus and light rail service
There are many additional perks & programs with the CU Advantage
Intermediate Level: $63,391 – $80,633
Senior Level: $68,531 – $87,171
The above salary range (or hiring range) represents the University’s good faith and reasonable estimate of the range of possible compensation at the time of posting
This position may be eligible for overtime compensation, depending on the level
Your total compensation goes beyond the number on your paycheck
The University of Colorado provides generous leave, health plans and retirement contributions that add to your bottom line
Total Compensation Calculator

Responsibilities

Business Intelligence (BI) Developer is the Department of Psychiatry’s Business Intelligence professional responsible for analyzing, reporting, visualization & dashboarding in key domains including finance, revenue cycle, clinical operations, quality & productivity, human resources, and clinical research
This position works under the supervision of the BI Manager to create and maintain databases, database objects, reports, Epic artifacts, and dashboards and performs analyses using these functions
The BI Developer collaborates closely with key stakeholders in the Department to ensure the intelligence and analyses are accurate, user-friendly, and impactful
Maintain existing database to house financial data from multiple organizations including CU Anschutz, CU Medicine, the CU Foundation, and other organizations as appropriate
Achieve and maintain Epic certifications that enable access to data and dashboarding capabilities at hospital partners (e.g., Children’s Hospital Colorado and UCHealth)
Maintain and improve unified system for FTE planning and clinical FTE reporting
Develop research project-specific reports and dashboards with PI and stakeholders as prioritized by Data Governance Committee
Create and maintain end user documentation that defines fields, metrics, business rules, and best practices to allow users to use reporting and analytics efficiently and effectively
The BI Developer may have other duties and responsibilities as assigned such as user training, change management, presentations, and professional development
If you work, visit, or volunteer in healthcare facilities or clinics operated by our affiliated hospital or clinical partners or by CU Anschutz, you will be required to comply with the vaccination and medical surveillance policies of the facilities or clinics where you work, visit, or volunteer, respectively

Business Intelligence Developer (Intermediate – Senior Level)

Job Type