Senior BI Developer

The Senior BI Developer provides expert-level business intelligence and data analysis support for Health Data Compass and the Anschutz research community. This role is responsible for delivering complex, high-value datasets in response to faculty and investigator requests, developing reports and visualizations, and designing scalable BI solutions within a HIPAA-compliant cloud environment., Senior BI Developers serve as subject matter experts for healthcare and research data, taking ownership of projects from intake through delivery. They lead work independently, set and manage expectations with stakeholders, and mentor junior team members while contributing to the overall quality, consistency, and reliability of Compass's data services., Develop Code from Healthcare Data - 70%

• Expertly navigate electronic medical record databases.
• Develop SQL queries for high-quality datasets and data marts.
• Verify HIPAA and institutional compliance requirements are complete before delivering data.
• Ensure accurate project documentation through the Compass case management system.
• Act as a business intelligence and data analysis subject matter expert.

Customer Service - 20%

• Lead customer engagement, scoping, and documentation for data requests.
• Ensure project scope, quality standards, and delivery timelines are met.
• Identify and communicate data anomalies in a timely manner.
• Direct users to appropriate resources for storage and computing needs.

Team Collaboration - 10%

• Mentor and support other members of the Data Delivery team.
• Enhance data delivery processes and refine organizational policies to align with industry best practices.
• Facilitate code reviews, mentor junior BI Developers, and share expertise to promote team skill development.
• Collaborate with engineers to troubleshoot data quality issues and validate new data sources.

Work Location:

Hybrid - this role is eligible for a hybrid schedule of 3 days per week on campus and as needed for in-person meetings.

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., * Hybrid - this role is eligible for a hybrid schedule of 3 days per week on campus and as needed for in-person meetings.

• BI developers are required to complete the Epic training plan and obtain certification within six months of hire.
• Maintain Epic certifications and training throughout employment.

• Bachelor's degree in a health science-related field (e.g., biostatistics, epidemiology, 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 experience. *, * 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 a related field from an accredited institution.

• 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 working with secure web platforms for building and managing databases (e.g., REDCAP).

• Experience working in an academic core service or support service.

Knowledge, Skills and Abilities:

• Ability to communicate effectively, both in writing and orally.
• Ability to establish and maintain effective working relationships with employees at all levels throughout the institution.
• Outstanding customer service skills.
• Advanced BI Developer skills.
• 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).
• 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.

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: 15/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., The starting salary range (or hiring range) for this position has been established as $90,000 - $100,247.

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.