BI Developer – Open Rank (Senior / Principal)

University of Colorado•Aurora, CO

9d•Hybrid

About The Position

The University of Colorado Anschutz Medical Campus, Department of Health Data Compass, is seeking a BI Developer for an Open Rank position (Senior / Principal). This role involves developing code from healthcare data, navigating electronic medical record databases, and creating SQL queries for high-quality datasets and data marts. The position requires ensuring HIPAA and multi-institutional compliance, maintaining project documentation, and acting as a subject matter expert in business intelligence and data analytics. The role also includes customer service responsibilities such as leading customer engagement, scoping data requests, and identifying data anomalies. For the Principal Level, there is an added emphasis on team collaboration, mentoring junior developers, enhancing data delivery processes, and facilitating code reviews.

Requirements

Bachelor’s degree in a health science-related field (e.g., biostatistics, epidemiology, etc.) or a related field from an accredited institution.
At least two (2) years of professional-level experience in a healthcare-related environment working with enterprise data warehouses, including data profiling, data quality assessments, data analysis/reporting, or data set curation, OR equivalent experience with SQL programming OR clinical healthcare data (for Senior Level).
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 (for Principal Level).
At least two (2) years of SQL programming experience.
Applicants must meet minimum qualifications at the time of hire.
Ability to communicate effectively and timely, both in writing and orally.
Ability to establish and maintain effective and professional working relationships with employees at all levels throughout the institution.
Outstanding customer service skills.
Advanced BI Developer skills.
SQL skills for querying data (especially for cloud computing).
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.
Must complete the Epic training plan and obtain certification within six months of hire.
Maintain Epic certifications and training throughout employment.

Nice To Haves

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., healthcare informatics, nursing, biostatistics, epidemiology, etc.) or a related field from an accredited institution.
Experience in standardized clinical code systems (e.g., SNOMED CT, LOINC, RxNorm) and common data models (OMOP).
Experience leading code reviews, including providing structured, actionable feedback to ensure code quality, accuracy, and adherence to team standards.
Demonstrated experience performing data quality and validation checks across datasets, including verifying completeness, consistency, and alignment with requirements; identifying anomalies such as duplicates, missing values, and out-of-range data; and resolving issues to ensure accurate and reliable outputs.
Experience managing terminology mapping documentation, data profiling, and data mapping documentation.
Experience working with secure web platforms for building and managing databases (e.g., REDCAP).
Experience working in an academic core service or support service.

Responsibilities

Develop Code from Healthcare Data
Navigate electronic medical record databases
Develop SQL queries for high-quality datasets and data marts
Verify HIPAA and mulit-institutional compliance requirements are complete before delivering data
Record and maintain accurate project documentation through the Compass case management system
Act as a business intelligence and data analytics subject matter expert
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
Mentor and support other members of the Data Delivery team (Principal Level)
Enhance data delivery processes and refine organizational policies to align with industry best practices (Principal Level)
Facilitate code reviews, mentor junior BI Developers, and share expertise to promote team skill development (Principal Level)
Collaborate with engineers to troubleshoot data quality issues and validate new data sources (Principal Level)