Senior Business Intelligence (BI) Developer

University Staff Description

University of Colorado Anschutz Medical Campus

Department : Health Data Compass

Job Title : Senior Business Intelligence ( BI) Developer

Position # : 00811713 - Requisition # : 30402

Job Summary :

The primary responsibility of the Senior BI Developer is to analyze and deliver datasets in response to faculty healthcare data requests.

The Senior BI Developer will contribute to Compass' mission of serving the Anschutz research community within a HIPAA-compliant environment.

The Senior BI Developer will support and mentor the data delivery team, as well as support health care investigators, faculty, and staff, internal and external to Compass.

A successful Senior BI Developer candidate will own and drive requests and projects to completion, communicate expectations, be a creative problem solver, and write documentation clearly and concisely.

Supervision Received : This position will report to the Data Request Program Manager

Supervision Exercised : None

Examples of Work Performed :

Independently writes and delivers SQL queries to create high-quality data sets or data marts. The Senior BI Developer executes assigned data requests within scope, quality, and targeted timeline for delivery.

As necessary the Senior BI Developer will identify and communicate data anomalies.

• Strives for positive customer experiences as determined by project completion surveys and customer interviews. The Senior BI Develop demonstrates strong reliability and responsiveness by communicating internally and externally within 24 business hours.
• Works closely with Compass Data Analyst for data requests where Compass Data Analyst leads customer engagement, scoping, and request documentation.

For projects without an assigned Compass Data Analyst the Senior BI Developer will fulfill this role and communicate directly with clinicians or researchers.

• Conducts accurate and timely documentation of project effort and status using the Compass case management system.
• Schedules and coordinates meetings with faculty or study teams as necessary to discuss data requests.
• Contributes to data delivery process optimization and organizational policy refinement.
• May facilitate, process, and / or escalate user requirements for data and infrastructure in the Compass Google Cloud Platform, following organizational policies and procedures.
• Supports the team by conducting code reviews, mentoring more junior BI Developers, and disseminating knowledge to peers.
• Helps troubleshoot data quality concerns and helps validate novel data sources.

This description is a summary only and describes the general level of work being performed, it is not intended to be all-inclusive.

The duties of this position may change from time to time and / or based on business needs. We reserve the right to add or delete duties and responsibilities at the discretion of the supervisor and / or hiring authority.

Work Location :

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

Why Join Us :

Health Data Compass (Compass) is the technology innovation arm of the Research Informatics Office. Compass maintains, develops, and innovates within a data integration and analytics platform on cutting-edge, cloud-based technologies to support biomedical research and clinical excellence throughout the CU research enterprise and our hospital partners.

The University of Colorado offers a comprehensive benefits package that includes health insurance, life insurance, retirement plans, tuition benefits, ECO pass, paid time off - vacation, sick, holidays and more.

To see what benefits are available, please visit :

Diversity and Equity :

The University of Colorado Anschutz Medical Campus is committed to recruiting and supporting a diverse student body, faculty, and administrative staff.

The university strives to promote a culture of inclusiveness, respect, communication and understanding. We encourage applications from women, ethnic minorities, persons with disabilities, persons within the LGBTQ+ community and all veterans.

The University of Colorado is committed to diversity and equality in education and employment.

Qualifications :

Minimum Qualifications :

Bachelor's degree in a health science-related field (e.g., biostatistics, epidemiology, etc.) or technology (e.g., computer science, engineering, etc.

or a related field from an accredited institution.

• At least four (4) years of professional-level experience in a healthcare-related environment working with enterprise data warehouses, including data profiling, data quality assessments, data analysis / reporting, data set curation, or equivalent experience.
• At least two (2) years of SQL programming expertise.

Applicants must meet minimum qualifications at the time of hire.

PLEASE NOTE : Candidates will be responsible for travel expenses related to the interview process and any relocation expenses, if applicable.

Preferred Qualifications :

• Epic Certified in Caboodle Data Model, Clarity Data Model, and / or Clinical Data Model.
• Master's degree in a health science-related field (e.g., biostatistics, epidemiology, etc.) or technology (e.g., computer science, engineering, etc.

or a related field from an accredited institution.

• Advanced BI Developer skills.
• Experience managing terminology mapping documentation, data profiling, and data mapping documentation.
• Experience in standardized clinical code systems (e.g., SNOMED CT, LOINC, RxNorm) and common data models (OMOP).
• Experience with data manipulation languages (e.g., SAS, R, Python).
• Experience working with secure web platforms for building and managing databases (e.g., REDCAP).

Competencies / Knowledge, Skills, & Abilities :

• Experience working in an academic core service or support service.
• Excellent customer service skills.
• Excellent written and oral communication skills.
• SQL skills for querying data (especially for cloud computing).
• BI developer skills (e.g., Tableau reports, Power BI).
• Experience working within HIPAA-compliant and other sensitive data environments.
• Extensive experience with clinical data (e.g., Epic proficiencies or certifications).
• Strong analytical skills, critical thinking, attention to detail and accuracy, and strong interpersonal skills.
• Ability to support the development of BI dashboards and reports, and data analytic initiatives.

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 : [email protected]

Screening of Applications Begins :

Immediately and continues until position is filled.

Anticipated Pay Range :

The starting salary range ( or hiring range ) for this position has been established as $76,126 to $96,831.

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 :

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.

[email protected].

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 :

The University of Colorado has a requirement for COVID-19 vaccinations and full completion thereof by 9 / 1 / 21 or upon start date.

Information regarding this requirement, and exemptions can be found at :

Anschutz :

Unit-Specific Exemptions :

Anschutz Campus - Accommodations may be granted for medical or religious reasons.

The University of Colorado seeks individuals with demonstrated commitment to creating an inclusive learning and working environment.

We value the ability to engage effectively with students, faculty and staff of diverse backgrounds.

Application Materials Required : Cover Letter, Resume / CV, List of References Job Category : Information Technology Primary Location : Aurora Department : U0001 Anschutz Med Campus or Denver - 21538 - ADM VCHA COMPASS GENOPS Schedule : Full-time Posting Date : Nov 21, 2023 Unposting Date : Ongoing Posting Contact Name : Kelli Hodge Posting Contact Email : Kelli.

[email protected] Position Number : 00811713