Overview

The Seattle Cancer Care Alliance (SCCA), located in Seattle, Washington, is part of a dynamic collaboration among three organizations known nationally and internationally for their patient care and research: Fred Hutchinson Cancer Research Center, University of Washington, and Seattle Children’s. Over the past 25 years, these institutions have worked together to support their mission of adult and pediatric oncology patient care services, research and education.

 

The Data Platform Team within SCCA Information Technology is responsible for designing, developing, and supporting SCCA data systems, for both operational and analytical purposes.

 

Under the guidance of the Data Platform Manager, the Data Engineer Lead (Data Engineer III) is responsible for the development and implementation of scalable, stable, and secure solutions for data acquisition, data distribution, and workflow orchestration in SCCA’s data warehouse. The role will also be responsible for leading the Data Engineering function in the maintenance and optimization of existing data pipelines from a wide variety of internal and external data sources, including partner data warehouses and repositories. They will work closely with team members, end users, and other stakeholders to provide solutions that support and empower internal business partners and drive enterprise analytics and data science objectives.

Responsibilities

  • Design, implement and support ETL/ELT processes sourcing data from various internal applications and external data repositories including our partner EPIC EMR implementations.
  • Monitor and maintain build and release pipelines in Azure Devops using continuous development best practices.
  • Develop and support data infrastructure primarily built with Microsoft technologies.
  • Partner with Test Engineer to target areas of the warehouse and associated processes where testing infrastructure improvements are needed.
  • Lead and mentor Data Engineers and foster a collaborative environment both on the Data Platform team and with IT and Business partners.
  • Work with data engineers, and systems and business analysts to support and empower technical and non-technical internal stakeholders in their analytics and reporting requirements.

Qualifications
Required:

  • Excellent knowledge and experience developing, performance tuning, and supporting on-prem data engineering systems using Microsoft SQL Server
  • Excellent knowledge of ETL tools and various data processing techniques and best practices
  • Expert in database architecture and design, performance tuning, coding, and administration
  • Experience with complex relational data models and very large data sets
  • Excellent knowledge of data warehousing design and concepts
  • Experience in dealing with large and complex data sets and performance tuning

Preferred:

  • B.Sc or M.Sc degree in quantitative field (Engineering, Computer Science, Information Systems, etc.), or equivalent training or professional experience
  • Prior experience in scripting languages (Powershell, Python, or similar)
  • Prior experience in AWS or Azure cloud data tools/technologies
  • Experience leading Data Engineering teams
  • Experience with Cerner and/or Epic healthcare systems
  • Familiarity with healthcare financial and/or clinical data
  • Familiarity with HIPAA regulations and data warehousing security best practices