The Data Platform Team within SCCA’s Information Technology Department is responsible for designing, developing, and supporting SCCA data systems and integration 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.

Successful candidates will have strong engineering, communication, and mentorship skills as well as expert level knowledge in on-prem SQL Server data systems. Familiarity with common cloud data tools, best practices and migration strategies is a plus as well as agile development methodologies.

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
• Strong verbal/written communication skills, including an ability to effectively communicate with the business: technical and non-technical teams.
• Ability to work independently, manage competing priorities and to adapt to new and changing technologies

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

SCCA has a mandatory COVID-19 vaccination policy, and there are no exceptions for any employee who is patient-facing and/or requires access to SCCA facilities.

Exceptions exist only for employees whose positions are fully remote, with no required access to campus. As a condition of employment, newly hired employees requiring access to campus must provide proof of vaccination before their first day of employment.

Our Commitment to Diversity

We are proud to be an Equal Employment Opportunity (EEO) and Vietnam Era Veterans Readjustment Assistance Act (VEVRAA) Employer. We are committed to cultivating a workplace in which diverse perspectives and experiences are welcomed and respected. We do not discriminate on the basis of race, color, religion, creed, ancestry, national origin, sex, age, disability (physical or mental), marital or veteran status, genetic information, sexual orientation, gender identity, political ideology, or membership in any other legally protected class. We are an Affirmative Action employer. We encourage individuals with diverse backgrounds to apply and desire priority referrals of protected veterans. If due to a disability you need assistance/and or a reasonable accommodation during the application or recruiting process, please send a request to our Employee Services Center at \hrops@fredhutch.org or by calling 206-667-4700.