• Use business requirements to develop BI solutions, including ad hoc operational and analytical reports, dashboard applications, and scheduled reports.
• Translate clinical and operational requirements into standardized metrics, KPIs, and dashboard designs that support care delivery, quality improvement, and performance monitoring.
• Develops BI solutions using the following tools: Business Objects: BOBJ Web Intelligence and Crystal. Epic: Reporting Workbench reports & templates, Radar dashboards, SlicerDicer analyses, Column Editor, PAF creation, CER rules. Clarity and Caboodle data warehouses. Azure and Power BI.
• Identifies opportunities for optimizing solutions and leveraging existing reporting assets to meet business requirements.
• Standardizes metric definitions and ensures alignment with organizational, regulatory, and oncology-specific reporting frameworks.
• Works closely with other KCI Data Operations and OHSU IT staff to meet expectations for design reviews and coding standards.
• Provides issue resolution during Quality Assurance / User testing. Troubleshoot and analyze data processing failures and data issues using Chart review, Record Viewer, Clarity Data dictionary, and Caboodle Data Dictionary.
• Work through established processes to resolve system or data problems, and communicate updates and status to affected groups.
• Recommend changes to data models and metadata models to improve existing structures and code to increase performance, reliability, and efficiency.
• Provides clinical informatics and technical expertise to departmental analysts, engineers, and clinical customers, including guidance on metric interpretation, dashboard utilization, and data-driven decision-making.
• Request migration of solution object through the SDLC. Validating and testing with the customer as frequently as necessary to get sign-off that the solution meets the requirements.
• Ensures that validated outputs accurately reflect clinical workflows, operational definitions, and intended use in decision-making.
• Delivers end-user training on dashboards, reports, and metrics, including education on appropriate interpretation and limitations of the data.
• Conduct discovery sessions with KCI/KCG end users, front line staff, leadership, Workflow Analysts, and Informaticians to gather and document detailed requirements that inform the design and development of new or modifications to existing BI solutions.
• Facilitate discussions to define clinical and operational metrics, ensuring alignment with institutional standards, quality programs, and oncology-specific initiatives.
• Workflow and Data analysis for incoming requests. Assess current-state vs. future-state workflows to ensure proposed reporting solutions align with clinical practice and operational goals.
• Profiling of source data to identify data lineage, source tables, data definitions, and business rules.
• Design intuitive, user-centered dashboards and reporting solutions that support clinical workflows and enable actionable insights.
• Review Epic Userweb, Epic hosted foundation, and TS support to leverage Epic foundation and Epic integrated solutions when possible.
• Incorporate clinical best practices and benchmark metrics when available to ensure consistency with industry standards.
• Serve as a clinical informatics and analytics content expert, ensuring that data, metrics, and reporting outputs align with clinical intent and organizational priorities.
