LEAD DATA ENGINEER (EXPERIENCE WITH EPIC CLARITY DATA MODEL AND REPORTING REQUIRED)

Req #: 244299 Department: UW MEDICINE IT SERVICES Appointing Department Web Address: http://uwmits_hires.uwmedicine.org/ Job Location: Remote/Hybrid, Seattle - Downtown Job Location Detail: Primary work location may be fully remote within the US or at the Safeco Plaza Building on the corner of 4th and Madison in downtown Seattle Posting Date: 03/11/2025 Closing Info: Open Until Filled Salary: $10,772 - $13,084 per month Other Compensation: Shift: First Shift Benefits: As a UW employee, you will enjoy generous benefits and work/life programs. For a complete description of our benefits for this position, click here.

UW MEDICINE IT SERVICES has an outstanding job opportunity for a Lead Data Engineer 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

Values-based work environment

Active departmental Equity, Diversity, and Inclusion Committee

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

Support the direction and priorities of the Manager by coordinating, overseeing, and ensuring the team’s execution of the following operational activities and ensuring standard services are meeting appropriate targets:
o Translate customers’ business requirements into efficient data pipelines, logical, physical data model, then manage the data model version control and change control
o Provide high quality data, identify and define common data requirements, and design conceptual structure and plans to the current and long-term data requirements of UW Medicine constituents
o Define and maintain data technology architecture, data integration architecture, data warehouse (DW) taxonomies and namespaces, and meta-data architecture

Prioritize and distribute the workload throughout the team, manage the day-to-day workflow, and report to the manager the status of work assignments

Provide a point of escalation for operational and other service issues

Identify and propose service management improvements

Provide advice, coaching and mentorship to team on work techniques, best practices, and operational expertise

Serve as the manager’s delegate to represent the team to customers, project managers, technical leadership and organizational management

REQUIREMENTS

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

6 years’ experience must include the following:

6 years' recent healthcare or IT experience

1 year(s) of formal mentorship for technology professionals

Familiarity working with cloud data warehouse platforms such as Microsoft Azure SQL, AWS Redshift or Snowflake

3 years' experience with SQL to write complex, highly optimized queries across large volumes of data, database design, data warehouse design, query performance tuning and writing stored procedures

Strong applied experience leading small to medium scale projects working through the complete development lifecycle for analytics solutions including reports and applications, or interfaces

3 years' experience with programming tools including SQL Server programming, SSIS, C#, ASP.Net, Visual Studio or Java, and scripting

Familiarity with Epic Clarity Data Model and Reporting

Strong SQL Server Database programming experience, including complex query optimization and performance tuning

Extensive understanding of Data Modeling best practices

Extensive subject matter domain expertise

Extensive understanding of basic principles of data normalization/denormalization, abstraction, and dimensionality as interface, etc.

Extensive knowledge of optimizing and troubleshooting database development for performance, including analyzing query statistics and knowledge of how data in a relational database is stored, retrieved, and processed

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

Salary : $10,772 - $13,084