Senior BI Developer

$76,299 - $97,052/Yr

University of Colorado - Aurora, CO

Full-time - Mid Level

Remote - Aurora, CO

Educational Services

About the position

The Senior BI Developer at the University of Colorado Anschutz Medical Campus plays a crucial role in providing expert-level business intelligence and data analysis support for the Health Data Compass and the broader Anschutz community. This position involves analyzing complex datasets, developing reports, and creating robust BI solutions to meet the needs of healthcare investigators and faculty. The Senior BI Developer will also mentor junior team members and ensure compliance with HIPAA regulations while driving projects to completion and effectively communicating with stakeholders.

Responsibilities

• Act as a business intelligence and data analysis subject matter expert, mentoring and supporting the BI Developer team.
• Develop SQL queries for high-quality datasets and data marts, ensuring project scope, quality standards, and delivery timelines.
• Identify and communicate data anomalies, verifying HIPAA compliance of delivered data.
• 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, directing users to appropriate resources for storage and computing needs.
• Lead customer engagement, scoping, and documentation for data requests, ensuring alignment with organizational objectives and accurate project documentation through the Compass case management system.

Requirements

• Bachelor's degree in a health science-related field or a related field from an accredited institution.
• At least four 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 years of SQL programming experience.

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 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.

Benefits

• Health insurance
• Life insurance
• Retirement plans
• Tuition benefits
• ECO pass
• Paid time off - vacation, sick, and holidays