Senior Business Intelligence Developer 3 (Hospital Capacity and Patient Flow)

University of Washington•Seattle, WA

24d•$120,000 - $146,808•Remote

About The Position

UW Medicine IT Services has an outstanding opportunity for a Senior Business Intelligence Developer – Hospital Capacity and Patient Flow. This role is 100% remote and offers a competitive benefits package including vacation, sick time, personal holiday, paid holidays, and a 401(b) matching program. The position is part of the Analytics group, which supports UW Medicine's transition towards value-based healthcare and provides analytic solutions across various departments, with a specific focus on Patient Flow and Capacity Management. The developer will collaborate with stakeholders to translate requirements into actionable insights and develop/optimize analytics tools for decision-making and process improvement.

Requirements

Bachelor’s degree in Computer Science, Health Information Systems, Math, Information Technology, Business Administration, or related field or equivalent combination of experience/education
Minimum Epic certifications in Epic Cogito Fundamentals, Caboodle Data Model Fundamentals, and Clarity Data Model
Epic certification in Access Data Model
Epic certifications in Cogito Tools Administration and badge in Radar SQL Metrics
Experience in the Grand Central application, certifications, or combination of the two
4+ years’ recent healthcare or IT experience
3+ years' experience with BI reporting tools
3+ years' experience with SQL writing complex, highly optimized queries across large volumes of data, database design, data warehouse design, query performance tuning and writing stored procedures
3+ years’ experience with Epic’s Grand Central application to support Patient Flow and Capacity Management
Strong, applied experience with Epic Clarity Data Model and Reporting for medium to large scale projects
Strong, applied experience with Epic Caboodle fundamentals and reporting for medium to large scale projects
Strong, applied experience with Epic Cogito tools (SlicerDicer, SQL Metrics, Reporting Workbench (including Cogito SQL), Radar Dashboards, Cogito Registries)
Strong, applied experience working through the complete report development lifecycle for medium to large scale projects
Complete and demonstrable understanding of BI reporting best practices
High level of awareness of the current and future BI technologies

Responsibilities

Provide sustained reporting and data support for capacity management and patient flow initiatives
Serve as a key partner with operational stakeholders, translating requirements into actionable dashboards, reports, and data insights that are relevant and impactful to our organization
Focus on development and optimization of analytics tools supporting decision-making, capacity monitoring, and patient throughput, while enabling clinical and operational leaders to drive process improvement
Provide the analytic foundation needed for operational teams to take action to improve patient flow and hospital capacity
Collaborate with Analytics leadership, Business Analysts, application analysts, and hospital Patient Flow stakeholders to gather, document, and confirm business requirements for ad hoc queries, extracts, metrics, reports, and dashboards to support capacity management and improvement
Design, develop, validate, deploy, and maintain both out of box and custom Cogito solutions to meet agreed upon requirements
Ensure all deliverables align with established acceptance criteria for completeness and accuracy
Provide ongoing analytic support for operations teams engaged in capacity management and patient flow process improvement initiatives
Maintain and refine dashboards and reporting tools to reflect changing needs and priorities
Support adoption of analytic tools through training and technical documentation
Provide production support and respond to help desk tickets related to the BI development tool set and Epic Cogito Suite
Mentor and provide guidance, direction, and support to other Analytics developers