Senior Business Intelligence Developer 3 - Hospital Capacity and Patient Flow
**职位描述** **UW 医学 IT 服务**有一个优秀的机会 **高级商业智能开发人员 医院容量和患者流动**. **工作时间表** - 100% FTE - 月 日 金；UW 医学 IT சேவை的主要时间是8:00 5:00 (PST) - 天班 ** DEPARTMENT DESCRIPTION** **U W Medicine IT Services (ITS) **是一个支持所有 UW 医学的共享服务组织。UW 医学由哈佛视医疗中心 (HMC),UW 医疗中心-蒙特莱克校园 (UWMC-Montlake),UWli 医疗中心 - 西北校园 (USWMC-NW Care),UW Medicine Primary (UWPC),UW 医学医生 (UWWP),SOM (UWSW School of Medicine),以及空中 (UWN Northwest). ITS 负责持续支持和维护这些机构的基础设施和应用程序，以及实施用于支持和推进 UW 医学使命的新服务和应用程序。**POSITION HIGHLIGHTS** - 100%远程机会 - 15天假期你的第一年 还每年12天病假，1个个人假期和11个付费假期 - 100%匹配，100%立即获得403(b) **PRIMARY JOB RESPONSABILITIES** - 为容量管理和患者流动倡议提供持续的报告和数据支持 - 作为运营利益相关者关键合作伙伴，将要求转化为可操作的仪表板，报告和数据见解，这些数据对我们的组织具有相关性和影响力。- 专注于开发和优化支持决策，能力监测和患者吞吐量的分析工具，同时使临床和运营领导人能够推动流程改进。- 为运营团队采取行动改善病人流动和医院容量提供必要的分析基础。** Analytics**组在 ITS 和 UW 医学学院都有双重报告，并为 UW 医学部的主要分析平台和工具提供运营监督。分析是 UW 医学向基于价值的医疗保健转变的一个关键支持功能.Epic 报告团队为 UW Medicine 提供了整个 UW 医学领域的分析解决方案，特别是用于金融，运营，机构质量改善，研究和临床分析。该职位集中在患者流动和能力管理领域，与 UW 药物 ITS 客户密切合作，开发人员团队协作提供分析，建议适当方法
查看英文原文
**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 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
**ABOUT UW MEDICINE – WHERE YOUR IMPACT GOES FURTHER**
UW Medicine is Washington’s only health system that includes a top-rated medical school and an internationally recognized research center. UW Medicine’s mission is to improve the health of the public by advancing medical knowledge, providing outstanding primary and specialty care to the people of the region, and preparing tomorrow’s physicians, scientists and other health professionals.
All across UW Medicine, our employees collaborate to perform the highest quality work with integrity and compassion and to create a respectful, welcoming environment where every patient, family, student and colleague is valued and honored. Nearly 29,000 healthcare professionals, researchers, and educators work in the UW Medicine family of organizations that includes: Harborview Medical Center, UW Medical Center - Montlake, UW Medical Center - Northwest, UW Medicine Primary Care, UW Physicians, UW School of Medicine, and Airlift Northwest.
[Become part of our team](https://www.uwmedicine.org/jobs). Join our mission to make life healthier for everyone in our community.
**Compensation, Benefits and Position Details**
**Pay Range Minimum:**
$120,000.00 annual
**Pay Range Maximum:**
$146,808.00 annual
**Other Compensation:**
-
**Benefits:**
For information about benefits for this position, visit https://www.washington.edu/jobs/benefits-for-uw-staff/
**Shift:**
First Shift (United States of America)
**Temporary or Regular?**
This is a regular position
**FTE (Full-Time Equivalent):**
100.00%
**Union/Bargaining Unit:**
Not Applicable
**ABOUT UW MEDICINE – WHERE YOUR IMPACT GOES FURTHER**
UW Medicine is Washington’s only health system that includes a top-rated medical school and an internationally recognized research center. UW Medicine’s mission is to improve the health of the public by advancing medical knowledge, providing outstanding primary and specialty care to the people of the region, and preparing tomorrow’s physicians, scientists and other health professionals.
All across UW Medicine, our employees collaborate to perform the highest quality work with integrity and compassion and to create a respectful, welcoming environment where every patient, family, student and colleague is valued and honored. Nearly 29,000 healthcare professionals, researchers, and educators work in the UW Medicine family of organizations that includes: Harborview Medical Center, UW Medical Center - Montlake, UW Medical Center - Northwest, UW Medicine Primary Care, UW Physicians, UW School of Medicine, and Airlift Northwest.
**Our Commitment**
The University of Washington is committed to fostering an inclusive, respectful and welcoming community for all. As an equal opportunity employer, the University considers applicants for employment without regard to race, color, creed, religion, national origin, citizenship, sex, pregnancy, age, marital status, sexual orientation, gender identity or expression, genetic information, disability, or veteran status consistent with [UW Executive Order No. 81](https://policy.uw.edu/directory/po/executive-orders/eo-81-prohibiting-discrimination-harassment-and-sexual-misconduct/).
To request disability accommodation in the application process, contact the Disability Services Office at 206-543-6450 or [dso@uw.edu](mailto:dso@uw.edu).
Applicants considered for this position will be required to disclose if they are the subject of any substantiated findings or current investigations related to sexual misconduct at their current employment and past employment. Disclosure is required under [Washington state law](https://app.leg.wa.gov/RCW/default.aspx?cite=28B.112.080).