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 Sr. BI Developer 3!
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 (UWMC-Montlake), UW Medical Center-Northwest (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.
In collaboration with UW Medicine IT Services (‘ITS’) and under the general guidance of the Epic Reporting Manager, the primary focuses of the Senior Business Intelligence Developer 3 (‘Sr. BI Developer’) position are to (1) identify business and technical impacts of user requirements and articulates to all constituents, (2) assume responsibility for the quality and delivery of technology business solutions, and (3) create ad hoc queries, data sources, and reports to support the business. The Sr. BI Developer works closely collaborate with other Analytics Team members and internal UW Medicine customers to provide a service oriented, cross-functional, knowledgeable, single point of technical leadership for application tools and workflows.
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 Epic Clinical domain and works closely with UW Medicine ITS customers and a team of developers to provide analysis, recommend appropriate solutions, and develop those solutions using the best BI solutions available.
Areas of responsibility include, but are not limited to:
collaborating with Analytics leadership to help set direction, standards, process for a team of BI Developers;
working with Business Analysts and customers to gather, analyze, and document BI requirements;
designing, coding, testing, and maintain BI reporting and analytics objects, including extracts, utilizing industry best practices;
providing production support and respond to help desk tickets related to the BI development tool set;
mentoring and providing guidance, direction, and support to other developers;
utilizing Epic’s Cogito suite of tools to deliver data solutions.
BI Solutions Implementation (55%)
Provide technical guidance, establishing oneself as an advisor to various cross-functional BI stakeholders.
Perform design and code reviews of developed solutions for quality assurance.
Follow ITS Analytics report build standards and change control processes, with a focus on enterprise build and long-term system maintenance.
Design and develop metrics, reports and analyses to drive key business decisions.
Provide scheduled and ad hoc mentoring and professional development to team members.
Independently develop BI solutions in a proficient and timely manner, consistent with estimates created during design, with minimal technical assistance and support.
Independently test solutions developed prior to any external reviews or testing.
Lead 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 (20%)
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; utilize and assist leadership in communicating these best practices.
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.
Perform and complete all tasks in the agreed upon timelines.
Work independently on assigned tasks with minimal assistance.
Document incidents, problems, and system changes in accordance within organizational change control procedures.
Obtain and transfers knowledge appropriately when new software or hardware are implemented.
Project and Process Management (15%)
Prioritize tasks with guidance from designated lead, supervisor, or project manager.
Track and provide regular project status updates to leaders, customers, and stakeholders on progress and obstacles.
Guide small projects or larger project sub-components that may include cross-functional teams.
Follow required Change Control processes to ensure proper creation, approval, coordination, and communication of project tasks.
Manage and prioritize multiple tasks at once, adjusting for roadblocks and problems.
Communicate across multiple groups within ITS as well as with customers.
Analyze current and proposed business practices and workflows to identify testing and training needs associated with change.
Actively seek out and contribute to process improvement efforts.
Unit test all changes associated with assigned project tasks.
Execute functional and integrated test scripts, tracking defects to ensure quality project deliverables.
Research, inform and recommend opportunities to apply business and technology solutions to areas of assigned responsibilities.
Perform impact analysis, provide feedback on customer change requests, draw conclusions and recommend resolution.
Participate in research, planning, evaluation, selection and implementation of strategic systems.
Identify improvement opportunities through analysis.
BI Solutions Production Support (5%)
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.)
Other Duties (5%)
Participate in all aspects of improving the team, including education/training of other team members and contributing to process/communication improvement initiatives.
Manage external vendor relationships and agreements, including acting as primary contact for daily operations, evaluating possible vendor solutions and systems products, and managing and coordinating system or application upgrades.
Provide internal training communication for IT Services staff regarding billing updates, workflow changes, peer system impact, etc.
Work with manager to set professional goals for career development.
Act as back-up for other team members and functions, as needed.
Bachelor's degree in Computer Science, Health Information Systems, Math, Information Technology, Business Administration, or a related field or equivalent combination of education/experience.
Currently holds two or more current Epic clinical certifications OR has obtained Epic proficiency AND has consistently demonstrated technical competencies for 4+ years in relevant/functional business area.
4+ years’ experience must include the following:
4+ years recent healthcare or IT experience.
4+ years' experience with BI reporting tools.
4+ 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.
Strong, applied experience with Epic Clarity Data Model and Reporting for medium to large scale projects.
Strong, applied experience with Epic Cogito tools (e.g., SlicerDicer, SQL Metrics, Reporting Workbench, Radar Dashboards, and Epic BI Integration).
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.
Advanced understanding of database structures, data definitions, and data relationships.
Proficiency with desktop computers and Microsoft Office, and familiarity with Visio and Project applications.
Previous experience in and knowledge of academic healthcare systems and/or operational environments.
7+ years' experience with Epic Clarity Clinical data model and reporting.
7+ years' experience with Business Objects Enterprise/Crystal Reports.
7+ years' experience with SQL.
7+ years' experience working through the complete report development lifecycle.
5+ years' experience working with large data sets.
Knowledge of Clinical healthcare concepts and workflows.
Previous experience in a healthcare environment preferred.
Ability to understand complex data models and schemas.
Experience with formal project management methods desirable.
An understanding of department/clinical operations, workflow, policies, and procures.
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 effectively in English, both verbally and in writing.
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.