Senior Business Intelligence Developer 3 - Cogito/Caboodle/Clarity/Access/Radar/Grand Central (Hospital Capacity and Patient Flow)

Job Description

UW Medicine IT Services has an outstanding opportunity for a Senior Business Intelligence Developer – Hospital Capacity and Patient Flow.

WORK SCHEDULE

• 100% FTE
• Monday – Friday; Core hours for UW Medicine IT Services are 8:00 – 5:00 (PST)
• Day Shift

DEPARTMENT DESCRIPTION

UW Medicine IT Services (ITS) is a shared services organization that supports all of UW Medicine.  UW Medicine is comprised of Harborview Medical Center (HMC), UW Medical Center-Montlake Campus (UWMC-Montlake), UW Medical Center-Northwest Campus (UWMC-NW), UW Medicine Primary Care (UWMPC), UW Physicians (UWP), UW School of Medicine (SOM), and Airlift Northwest (ALNW).  ITS is responsible for the ongoing support and maintenance of the infrastructure and applications which support all these institutions, along with the implementation of new services and applications that are used to support and further the UW Medicine mission.

POSITION HIGHLIGHTS

• 100% remote opportunity
• 15 days of vacation your first year – Also, 12 days of sick time, 1 personal holiday, and 11 paid holidays each year
• 100% matching, 100% immediately vesting 403(b)

PRIMARY JOB 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

The Analytics group has a dual report into both ITS and UW School of Medicine and provides operational oversight for the major analytics platforms and tools at UW Medicine.  Analytics is a key support function as UW Medicine transitions towards value based health care.  The Epic Reporting team provides analytic solutions across UW Medicine, specifically for finance, operations, institutional quality improvement, research and clinical analytics.  This position is focused to the Patient Flow and Capacity Management area and works closely with UW Medicine ITS customers and a team of developers collaborate to provide analysis, recommend appropriate approaches, and implement them using the best Cogito BI tools available.

Areas of responsibility include, but are not limited to:

• 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 the 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

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 of experience must include:

• 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