Note: This is a hybrid position in Seattle, WA.
The Data Engineer responsibilities include building a data processing pipeline that collects, connects, centralizes, and curates data from various internal and external sources using a variety of languages and tools to marry systems together for the Enterprise Data Warehouse. This includes leveraging modern cloud platforms and services to develop highly scalable, secure and reliable data engineering solutions for efficiently moving and transforming data across systems. Additional responsibilities include designing, implementing, testing, and deploying cloud-based data processing infrastructure; performing work in an Agile team setting; and breaking down, estimating, and providing just-in-time design for small increments of work. This role is pivotal to the mission and vision of Seattle Children's Enterprise Analytics team to transform healthcare for children by providing patient safety, predictive analysis to cure diseases, lowering cost of treatment, etc.
Required Education and Experience
Bachelor's Degree in computer science or related field, or equivalent combination of education and experience/technical training that demonstrates analytical and technical competency.
Minimum of two (2) years technology industry or related experience, including items such as:
- Build highly scalable, scaled-out architectures on large scale database platforms.
- Experience working in a complex data infrastructure environment.
Two (2) years of experience in a data engineering role.
2+ years of experience building highly scalable applications, specifically with coding languages such as Python and SQL (Structured Query Language).
Experience building scalable data pipelines using Spark or Spark-SQL with Airflow scheduler/executor framework or similar scheduling tools
Experience with cloud platforms with GCP preferred.
Advanced competency in SQL with ability to perform query optimization in large scale database platforms.
Experience in SDLC process with requirements gathering, analysis, architecture, design, implementation, testing, deployment and technical support.
Experience with any industry standard tool for Source Control and Project Management.
Experience writing test cases and test scripts for data quality assurance.
Experience creating stored procedures and functions.
Experience developing dimensional data model with any industry standard tool.
Experience with Google BigQuery or equivalent
Required Credentials
N/A.
Preferred
Experience in Healthcare or related industry.
Experience GCP cloud services and data warehouse stores like BigQuery
Experience productizing/automating predictive models that use R, SAS, Python, SPSS, etc.
Experience in version control and CI/CD (Continuous integration and continuous delivery) tools.
Familiarity with test-driven development methodology for analytic solutions.
Familiarity with Agile framework and test-driven development methodology for analytic solutions.
API development.
Data visualization and/or dashboard development.
Compensation Range
$110,122.00 - $165,182.00 per year
Salary Information
This compensation range was calculated based on full-time employment (2080 hours worked per calendar year). Offers are determined by multiple factors including equity, skills, experience, and expertise, and may vary within the range provided.
Disclaimer for Out of State Applicants
This compensation range is specific to Seattle, positions located outside of Seattle may be compensated differently depending on various factors
Benefits Information
Seattle Children's offers a generous benefit package, including medical, dental, and vision plans, 403(b), life insurance, paid time off, tuition reimbursement, and more. Additional details on our benefits can be found on our website www.seattlechildrens.org/careers/benefits.