BI Developer – Open Rank (Senior / Principal)
About The Position
Develop Code from Healthcare Data Senior Level – 80%25 | Principal Level – 70%25 Expertly 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. Customer Service – 20%25 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%25 (Principal Level) 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.
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.
- 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.
- 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.
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 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.
- 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.
Benefits
- Medical: Multiple plan options
- Dental: Multiple plan options
- Additional Insurance: Disability, Life, Vision
- Retirement 401(a) Plan: Employer contributes 10%25 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
