BI Developer

University of Colorado

1d•Hybrid

About The Position

The BI Developer provides business intelligence and data analysis support for Health Data Compass and the Anschutz research community. This role is responsible for delivering complex and high-value datasets in response to faculty and investigator requests within a HIPAA-compliant cloud environment. BI Developers serve as subject matter experts for healthcare and research data, taking ownership of projects from intake through delivery. They support work independently, manage expectations with stakeholders, and contribute to the overall quality, consistency, and reliability of Compass’s data services.

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 experience working with enterprise data warehouses, including data profiling, data quality assessments, data analysis/reporting, data set curation OR experience with SQL programming OR experience with clinical healthcare
Experience may be obtained simultaneously.
Applicants must meet minimum qualifications at the time of hire.
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.
Strong customer service skills.
SQL skills for querying data (especially for cloud computing).
Experience working within HIPAA-compliant and other sensitive data environments.
Experience with clinical data
Strong analytical skills, critical thinking, attention to detail and accuracy, and strong interpersonal skills.
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.

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., 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 in an academic core service or support service.

Responsibilities

Develop Code from Healthcare Data – 80%25
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.
Customer Service – 20%25
Support 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.