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.
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.
UW Medicine Supply Chain Management has an outstanding opportunity for a full-time, day shift, Supply Chain Business Intelligence (BI) Analyst. The Supply Chain Business Intelligence (BI) Analyst will work as a member of the UW Medicine (UWM) Supply Chain Informatics team to further ongoing initiatives of streamlining and enhancing operational reporting for Supply Chain. This role's focus will be on, but not limited to, enabling Business Intelligence (BI) and data-driven decision-making for UWM Supply Chain.
Reporting/ Analytics Design and Development
Utilize Business Intelligence reporting tools such as Tableau, Spotfire, Microsoft SQL Server Reporting Services (SSRS), Excel, in the design and development of data analytics projects for Supply Chain Department
Partner with the UW Medicine ITS and other technology teams to deliver a stable and highly available platform for publishing and distribution of reports
Develop SQL queries, views or stored procedures for more complex reporting needs; collaborating with Data Analytics Manager
Apply strong problem solving skills and analytical capabilities to enable business leadership to make effective, data-driven decisions
Understand how data flows between HEMM and its downstream and upstream systems, MPOUS and HSM, to ensure data is organized properly for reporting/analytics
Provide actionable intelligence with existing metrics or identify, develop and propose new metrics; streamline and enhance operational reporting
Clearly convey the key insights or “story” the data reveals in a visual format that is grouped, summarized, or formatted to be easily understood and actionable
Define Customer Requirements
Work with SCM's internal and external customers on BI projects to understand requirements, analyzing the request, providing estimeates of effort involved and developing an effective solution to address the request
Create Ad Hoc Reporting, as needed, per requester specifications and agreed upon dates/specifications
Apply strong problem solving skills and analytical capabilities to enable business leadership to make effective, data-driven decisions.
Ensure current report provides necessary support and properly answers questions for SCM internal and external customers and make necessary adjustments as needed.
Documentation & Manage Tasks
Collaborate with IS Application Support Manager and Application support team in testing new reports and analytics for validation, accuracy and usability; create test plans and scripts for system and user acceptance testing
Document existing data sources and uses of data. Facilitate a high standard of documentation that will ensure a successful representation fo data knowledge over time
Collaborate on building data repository of HEMM data, how it relates to DAWG, pre and post D1, and in preparation for Workday
Secure resources from appropriate UW Medicine entities and project leaders for projects or problem resolution
Work with SCMIS Application Support for resolution of custom reporting applications/ analytics developed in-house
Bachelor's degree in Business, Computer Information Systems or equivalent
3-5 years experience to include: - Minimum 2 year of experience developing and implementing reports and dashboards
Ability to transform business level requirements to efficient dashboards and visualizations
Experience working with large datasets and optimization - Minimum 2 years of experience in healthcare Supply Chain Management
Working experience with McKesson applications, specifically HEMM, HEFM HSM, MPOUS (Point-of-Use)
Proficiency in SQL query skills
Proficiency in SSRS (SQL Server Reporting Services) Reporting
Proficiency in Microsoft Excel and Access
Experience with Tableau dashboards
Equivalent experience may substitute for degree.
Experience with Tibco Spotfire dashboards design, development, and R integration
Excellent verbal and written communication skills
Ability to work successfully in a dynamic, ambiguous environment
Ability to develop new ideas and creative solutions Experience analyzing data and communicating the results to stakeholders
Advanced problem-solving skills for difficult to complex issues
UW Medicine includes Harborview Medical Center, UW Medical Center - Montlake, UW Medical Center - Northwest, Valley Medical Center, UW Neighborhood Clinics, UW Physicians, UW School of Medicine, and Airlift Northwest.
Founded in 1861, the University of Washington is one of the oldest public institutions in the west coast and one of the preeminent research universities in the world. The University of Washington is a multi-campus university comprised of three different campuses: Seattle, Tacoma, and Bothell. The Seattle campus is made up of sixteen schools and colleges that serve students ranging from an undergraduate level to a doctoral level. The university is home to world-class libraries, arts, music, drama, and sports, as well as the highest quality medical care in Washington State and a world-class academic medical center. The teaching and research of the University’s many professional schools provide undergraduate and graduate students the education necessary toward achieving an excellence that will serve the state, the region, and the nation. As part of a large and diverse community, the University of Washington serves more students than any other institution in the Northwest.