Senior BI Developer (Epic Cogito) - Remote

University of Washington; Seattle (WA); On-site; USD 120,000 - 147,000; Full time

Benefits offered by this job

Remote work

Flexible hours

Job summary

University of Washington, UW Medicine IT Services, is seeking a Senior BI Developer (Clinical/ Pharmacy) to lead data solutions using Epic Cogito, Willow, and Caboodle.

You will design and deliver reports, dashboards, and data extracts supporting clinical and pharmacy operations across UW Medicine.

Qualifications

• Bachelor's degree or equivalent combination of education/experience required.
• Epic certification in Clinical Data Model; Cognito Fundamentals; Caboodle Data Model Fundamentals; Clarity Data Model; Cogito Tools Administration.
• Experience with Epic Willow reporting; Caboodle data models and reporting for large-scale projects.
• Experience with Cogito tools (SlicerDicer, SQL Metrics, Reporting Workbench, Radar Dashboards, Cogito SQL).
• 4+ years of healthcare or IT experience; 3+ years BI reporting tools; 3+ years SQL performance tuning and data warehouse design.

Responsibilities

• Identify business and technical impacts of user requirements and articulate to all constituents.
• Assume responsibility for quality and delivery of technology business solutions.
• Create ad hoc queries, data sources, and reports to support operations.
• Collaborate with Analytics leadership to set direction, standards, and process for BI Developers.
• Gather, analyze, and document reporting requirements with cross-functional teams.
• Deliver data solutions using Epic Cogito tools.
• Design, code, test, and maintain reporting and analytics objects including extracts.
• Provide production support and respond to Help Desk tickets for BI tools.
• Mentor other developers.

Skills

Epic Willow reporting

SQL

BI tooling

Data modeling

Communication with stakeholders

Education

Bachelor's degree in Computer Science, Health Information Systems, Math, Information Technology, Business Administration, or related field or equivalent combination of education/experience

Tools

Epic Cogito Fundamentals

Caboodle Data Model Fundamentals

Clarity Data Model

Cogito Tools Administration

Cogito SQL

SlicerDicer

SQL Metrics

Reporting Workbench

Job description

Job Description

Job Description

UW MEDICINE IT SERVICES has an outstanding job opportunity for a Senior Business Intelligence Developer 3 (Clinical / Pharmacy) position.

WORK SCHEDULE

• 100% FTE – 40 hours per week
• Day Shift – UW MEDICINE ITS SERVICES CORE HOURS ARE 08:00 – 17:00 (PST), Monday-Friday
  
  

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), Valley Medical Center (VMC), 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

• Identify business and technical impacts of user requirements and articulate to all constituents
• Assume responsibility for the quality and delivery of technology business solutions
• Create ad hoc queries, data sources, and reports to support the operations
• Collaborate with Analytics leadership to help set direction, standards, and process for a team of BI Developers
• Work with other BI Developers, Cogito Developers, Analytics Business Analysts, Clinical Informatics, application teams, and operational and clinical customers to gather, analyze, and document reporting requirements
• Utilize Epic’s Cogito suite of tools to deliver data solutions
• Design, code, test, and maintain 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 and Epic Cogito suite
• Mentor and provide guidance, direction, and support to other developers
  
  

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 Cogito 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.

Requirements

• Bachelor’s degree in Computer Science, Health Information Systems, Math, Information Technology, Business Administration, or related field or equivalent combination of education/experience
• Epic certification in Clinical Data Model
• Epic certifications in Epic Cogito Fundamentals, Caboodle Data Model Fundamentals, Clarity Data Model, and Cogito Tools Administration
• Strong, applied experience with Epic Willow reporting
• Strong, applied experience with Epic Clarity and Caboodle Data Models and Reporting for medium to large scale projects
• Strong, applied experience with Epic Cogito tools (SlicerDicer, SQL Metrics, Reporting Workbench, Radar Dashboards, Cogito SQL)
• 4 years of experience must include the following:
• 4+ years of recent healthcare or IT experience
• 3+ years of experience with BI reporting tools
• 3+ years of 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
  

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, Valley Medical Center, UW Medicine Primary Care, UW Physicians, UW School of Medicine, and Airlift Northwest.

Become part of our team. 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

Benefits

Other Compensation:

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 The UW

Working at the University of Washington provides a unique opportunity to change lives – on our campuses, in our state and around the world.

UW employees bring their boundless energy, creative problem-solving skills and dedication to building stronger minds and a healthier world. In return, they enjoy outstanding benefits, opportunities for professional growth and the chance to work in an environment known for its diversity, intellectual excitement, artistic pursuits and natural beauty.

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.

To request disability accommodation in the application process, contact the Disability Services Office at 206-543-6450 or [e-mail].

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.