Healthcare Business Intelligence Developer Job Description Template

The healthcare business intelligence developer builds the data warehouse, models and reporting layer that an organization’s analytics depend on. The role is more engineering focused than analysis, covering pipelines, dimensional models and the performance of reports that clinical and financial leaders use routinely. Consistent definitions across the warehouse are the main deliverable.

Typical Duties and Responsibilities

• Design and build data models supporting healthcare reporting
• Develop and maintain extract, transform and load pipelines
• Build reports and dashboards on the warehouse
• Implement consistent measure definitions across the reporting layer
• Optimize query and report performance
• Integrate data from clinical, financial and operational source systems
• Implement data quality monitoring and validation
• Manage access control appropriate to sensitive health data
• Document data lineage and model design
• Support analysts and end users with data questions

Education

• Bachelor’s degree in computer science, information systems or a related field

Required Skills and Experience

• 3+ years building business intelligence solutions, ideally in healthcare
• Strong SQL and dimensional modeling skills
• Experience with ETL or ELT tooling
• Proficiency with a reporting platform such as Power BI or Tableau
• Understanding of healthcare source system data structures
• Experience implementing consistent measure definitions
• Attention to data quality and validation
• Understanding of access control for protected health information

Preferred Qualifications

• Experience with Epic Clarity or Caboodle
• Cloud data warehouse experience