Job Summary
Business Intelligence Developer
Role description
Business intelligence developers (BIDs) create analytics content for end users and third parties who require Epic data.
Key Responsibilities
1. To design and develop robust and scalable end-to-end solutions, covering both front-end and back-end development.
2. To enhance an existing application and/or product, to incorporate a new feature or modify an existing one.
3. To tackle complex technical challenges and provide innovative solutions.
4. To identify and address bottlenecks in both front-end and back-end systems and optimize application performance / responsiveness through code improvements.
5. To communicate effectively with team members , collaborate with cross-functional stakeholders to gather requirements and provide updates on project progress.
Skill Requirements
Responsibilities Configuring and testing Epic-released and Foundation System content for all applications, including: Reporting Workbench SlicerDicer Radar Cogito SQL Creating content to display Epic data from Chronicles, Clarity, and Caboodle Writing SQL and configuring Radar settings for custom SQL metrics Modifying existing reports, as necessary Distributing analytics content to data consumers Reviewing peer reports for validity Working with subject matter experts to understand the needs of data consumers Maintaining the Analytics Catalog and associated metadata records Testing analytics build in a specified testing environment and volume testing in live environments Reviewing upgrade documentation related to Cogito features and determining how to implement the changes BIDs might also be responsible for building and maintaining: Cubes Extracts SlicerDicer custom filters Third-party BI tools Epic data in Caboodle Key competencies A degree in engineering, physics, computer sciences, math, information systems, or statistics Strong communication skills Critical thinking and an analytical mind User-focused design and data visualization skills Proficiency with SQL and relational database concepts Proficiency and demonstrated experience with analytics tools Familiarity with Epic applications and database structure, through training that occurs early in the implementation Ability to gain an in-depth understanding of the data model through data model classes geared toward content areas Ability to understand data structures that could benefit the entire data environment For financial reporting: Prior experience working with an AR system is desirable, but not required For clinical reporting: Prior experience working with an EMR system is desirable, but not required Ideally, BIDs design and create analytics solutions based on an in-depth knowledge of operational system usage. This level of knowledge requires a deep understanding of system build, end user workflows, and patterns of use. The best BIDs have both the technical skills required to design and write reports and the operational knowledge to help them understand what report consumers need to see. Training and certification Each of the following tracks should be completed by at least one business intelligence developer at your organization, depending on their area of focus (note this means that a total of at least three BIDs should have completed at least one track each): Access Data Model Certification Clinical Data Model Certification Revenue Data Model Certification Business intelligence developers who don't complete one of the three tracks above should still follow one of the tracks as far as is necessary for them to be able to effectively develop reports In addition, BIDs who are developing reports for a specific application should study the materials for the data model knowledge track for that application Training in the fundamentals of report design for the third-party reporting tool you choose is strongly recommended for all BIDs Some organizations have BIDs shadow end users to gain an understanding of user workflows and how to present the data users need in a meaningful way All BIDs should be certified in Cogito Fundamentals (this is required to complete data model certification) One or more BID should be certified in Cogito Tools Administration