Indiana University Health is looking for an Epic BI Developer II to design, develop, and maintain business intelligence solutions within the Epic EHR environment to support clinical, financial, and operational decision-making across the healthcare organization.
Requirements
- Proficiency in SQL for writing complex queries and optimizing database performance.
- Experience with BI and reporting tools like Crystal Reports, Tableau, Power BI, or similar.
- Familiarity with Epic-specific BI tools such as Cogito, SlicerDicer, and Caboodle.
- Certification in one or more Epic modules (e.g., Cogito, Caboodle Data Model, Clarity Data Model, Revenue Data Model) is highly desirable.
- Familiarity with IT solutions and interfacing is a plus.
Responsibilities
- Responsible for designing, developing, and maintaining business intelligence solutions within the Epic EHR environment.
- Build, test, and maintain custom reports and dashboards using Epic Clarity (SQL-based reporting database) and Epic Caboodle (data warehouse).
- Develop SQL queries to extract and aggregate data from Epic modules (e.g., Ambulatory, Inpatient, Resolute Billing) for clinical, operational, and financial reporting.
- Design and implement interactive dashboards using tools like Epic Cogito and SlicerDicer to provide end-users with insights into key performance indicators (KPIs).
- Perform ETL (Extract, Transform, Load) processes to integrate data from Epic systems with external sources for advanced analytics.
- Ensure that all BI solutions adhere to organizational data governance and security policies, including compliance with HIPAA and other regulatory requirements.
- Monitor report performance and optimize SQL queries and data structures to improve load times and efficiency.
Other
- This position will involve some onsite work in Indianapolis, Indiana
- Work closely with clinical, financial, and operational teams to gather reporting requirements and translate them into technical specifications for BI solutions.
- Engage with department leaders to ensure reports meet their needs, from patient care insights to financial performance monitoring.
- Assist non-technical stakeholders with data interpretation and usage of BI tools.
- Ability to travel to assigned sites as required.
