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 IT Services department has an outstanding opportunity for a Business Intelligence Developer! This position will focus on the Epic clinical domain. This position is currently 100% remote due to COVID-19. When restrictions are lifted and staff can return to the workplace, there is a high likelihood of partial ongoing remote work in the future.
UW Medicine’s Information Technology Services (ITS) department 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), Valley Medical Center (VMC), UW Neighborhood Clinics (UWNC), UW Physicians (UWP), UW School of Medicine (SOM) and Airlift Northwest (ALNW). In addition, UW Medicine shares in the ownership and governance of Children’s University Medical Group and Seattle Cancer Care Alliance (a partnership between UW Medicine, Fred Hutchinson Cancer Research and Seattle Children’s). ITS is responsible for the ongoing support and maintenance of the infrastructure and applications which support all of these institutions, along with the implementation of new services and applications that are used to support and further the UW Medicine mission.
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 Business Intelligence (BI) team provides analytic solutions across UW Medicine, specifically for finance, operations, institutional quality improvement, research and clinical analytics. The primary focus of the Business Intelligence Developer (BI Developer) is within the Epic clinical domain. The BI Developer works closely with UW Medicine ITS customers and a team of analysts to provide analysis, recommend appropriate solutions, and develop those solutions using the best BI solutions available.
The BI Developer identifies business and technical impacts of user requirements and creates ad hoc queries, data sources and reports to support the business.
The primary responsibilities of the BI Developer are to:
Work with Business Analysts and customers to gather, analyze, and document BI requirements;
Design, code, test, and maintain BI reporting and analytics objects, including extracts, utilizing industry best practices;
Provide production support and respond to help desk tickets related to the BI development tool set.
Data analytics is a strategic function within UW Medicine with a large set of growing demands. The proper execution of the BI Developer function is essential to both tactical and strategic success of UW Medicine overall. This role provides crucial support to UW Medicine and its partners. The analytics solutions developed by this role are used to support clinical, operational, and financial reporting and analysis and are key to the success of the organization as a whole. Adhering to best practices and standards helps support enterprise-wide goals and ensures data standardization across the enterprise
BI Solutions Implementation (55%)
Provide technical guidance to various cross-functional BI stakeholders.
Perform design and code reviews of developed solutions for quality assurance.
Collaborate with team members to develops BI solutions in a proficient and timely manner, consistent with estimates created during design.
Test solutions developed prior to any external reviews or testing.
Participate in interactions with customers to communicate status, resolve issues, and obtain signoffs (design complete, testing complete/ready for promotion).
Perform efficient, complete hand-offs to other developers when required.
Report project status and issues to the reporting team supervisor in a timely manner.
Planning and Documentation (25%)
Maintain a high level of awareness of the current and future BI technologies and best practices and fully understand the various organizational structures of UW Medicine and their unique requirements.
Coordinate with Business Analysts, Data Architects, Structured Quality Language (SQL) Administrators, BI Administrators and others to understand and document technical requirements, capabilities, and limitations.
Collaborate with Business Analysts, Data Architects, SQL Administrators, BI Administrators and others to design appropriate BI solutions based on business and technical requirements.
Perform project planning related to BI solutions development tasks including effort and completion date estimates.
Work with minimal supervision on assigned tasks and complete tasks in agreed upon timelines.
Obtain and transfer knowledge appropriately when new software or hardware are implemented.
BI Solutions Production Support (20%)
Research questions and issues involving Production BI solutions.
Work with data architects, SQL administrators, BI administrators, BI Developers, and others as needed to resolve to production issues.
Provide on-call production support for selected times (i.e., month end processing, year end processing, system upgrades, etc.)
Bachelor's degree in Information Systems, Computer Science, or related area or equivalent combination of education/experience.
2+ years experience must include the following:
2+ years' experience with Business Objects Enterprise and/or Crystal Reports.
2+ years' experience with SQL.
2+ years’ experience with Epic Clarity Clinical Data Model and Reporting.
Minimum of one (1) Epic Data Model certifications, or completion of certification within first 6 months of employment.
2+ years' experience working through the complete report development lifecycle.
The successful candidate will also possess:
Values consistent with those of UW Medicine's mission 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.
Complete and demonstrable understanding of BI reporting best practices.
Ability to translate complex issues into comprehensible ideas and concepts with both technical and non-technical staff.
Proven customer service orientation with a history of delivering high quality products on time.
Excellent written and oral communication abilities with the ability to convey a positive and professional image in person, on the telephone and in correspondence.
Strong interpersonal skills with the ability to work effectively with a diversity of personalities while forging effective partnerships.
Flexibility with proven ability to conform to shifting priorities, demands, and timelines through analytical and problem-solving capabilities.
Strong organizational, multitasking, and collaboration skills in various work environments including complex, matrix environments with proven attention to detail.
Proven ability to work creatively and analytically in a problem-solving environment demonstrating teamwork, innovation, and excellence.
Proven ability to work in an ambiguous environment and collaborate across multiple areas in order to achieve a common business objective.
Must be able to learn, understand, and apply new technologies.
Previous experience in and knowledge of academic healthcare systems and/or operational environments.
4+ years' experience with Epic Clarity Clinical data model and reporting.
Knowledge of clinical healthcare concepts and workflows.
Previous experience in a healthcare environment preferred.
4+ years' experience with Business Objects Enterprise/Crystal Reports.
4+ years' experience with SQL.
4+ years' experience working through the complete report development lifecycle.
4+ years' experience working with large data sets.
Ability to understand complex data models and schemas.
Experience with formal project management methods desirable.
Demonstrated analytical ability to effectively perform all phases of projects.
Internal motivation to be action oriented and results driven with ability to adapt to change.
Decisiveness in resolving business problems, making decisions, and identifying priorities.
CONDITIONS OF EMPLOYMENT
This is an Information Technology deadline-driven work environment.
Program operates within the confines of standard IT methodology: Design Review, IT Project Management, Change Control, Risk Assessment, and Code Management.
The individual in this position is expected to work normal daytime hours. The majority of work is performed in an office environment during normal business hours or by telecommuting with manager approval; however, significant off-hours and weekends may be needed to resolve problems and respond to emergencies. This individual is expected to be available for emergencies (business continuity/disaster recovery efforts) on a 24x7 basis as needed.
Because of the physically separated sites for UW Medicine, this position requires the ability to travel to alternative work locations as needed.
Interacts with a variety of individuals within UW Medicine and ITS specifically.
Must coordinate projects without direct supervisory authority.
Must work within the constraints of multiple technical environments.
ITS provides services to all UW Medicine organizations – HMC, UWMC-Montlake, UWMC-NW, VMC, UWNC, UWP, SOM, and ALNW. The individual in this position must learn many organizational structures and cultures and continually foster collaboration.
Ability to communicate clearly in English, both verbally and in writing. #monster
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.