CEENTA's Business Intelligence Developer is responsible for analyzing, providing specifications for, and writing individual reports for assigned applications to support the needs of end users, senior leadership, and the Epic project team. This position serves as the primary reporting resource for the Epic Cogito application and has the responsibility for system support maintenance, analysis, design, and change control of all reporting components used to build and manage CEENTA’s reporting.
Requirements
- In-depth knowledge and experience with relational database concepts and query tools.
- Sound knowledge of SQL tuning and data extraction methodologies.
- Ability to use OLAP and OLTP technologies along with knowledge of data warehouses/data stores and data marts to execute SQL query techniques
- Extensive knowledge of reporting programs and tools reports creation and maintenance including Epic Reporting Workbench, Epic Clarity, Chronicles, and Crystal Reporting writing will be utilized on the Reporting Team.
- Ability to adapt to a changing environment, problem solve and develop solutions.
- Experience with Microsoft Office or similar software required.
- 2 + years of Epic Cogito experience preferred.
Responsibilities
- Define report requirements; design/develop/test/install/implements report-based programs; report programming designs; and code/test/debug/document system scripts, programs, and reports in application, web, and database environments.
- Design, code, test, and maintain BI reporting and analytics objects, including extracts, utilizing industry best practices
- Responsible for maintaining data integrity and the ongoing quality control of delivered reports.
- Validates system build/reports designs and performs audit and report findings of security and data controls.
- Work with external organizations and third-party vendors to securely extract and share data.
- Designs and documents the general functional requirements and detailed technical specifications for a report/database.
- Validate model system reports and identify advanced reporting needs with report consumers.
Other
- Collaborate with Subject Matter Experts and members of leadership to gather, analyze, and document BI requirements
- Assesses reporting needs to Epic customers through investigations, analysis and evaluation to create desired reports.
- Collaborate and partner with executive leadership, shareholders, and leaders within information systems, clinic operations, management, and reporting.
- Ability to meet the physical and mental demands of the position.
- The ability to work on-site.
