Data Engineer
Job Description
Seattle Children’s Hospital is seeking a Data Engineer to help design and deliver cloud-based data processing infrastructure in support of an Enterprise Data Warehouse. In this hybrid role in Seattle, you will work within an Agile team to build secure, scalable pipelines that collect, connect, centralize, and curate data from diverse sources.
This position focuses on engineering durable data workflows, transforming and moving data across systems efficiently, and supporting iterative delivery through small increments of work. You will also contribute to testing and deployment activities as part of an end-to-end SDLC process.
What you’ll do
- Build data processing pipelines to collect, connect, centralize, and curate data from internal and external sources for the Enterprise Data Warehouse.
- Use a variety of languages and tools to integrate and align systems across the data environment.
- Leverage modern cloud platforms and services to develop scalable, secure, and reliable data engineering solutions.
- Design, implement, test, and deploy cloud-based data processing infrastructure.
- Perform work in an Agile team environment.
- Break down and estimate work, providing just-in-time design for small increments of delivery.
Qualifications
- Bachelor’s Degree in computer science or related field, or an equivalent combination of education and experience/technical training demonstrating analytical and technical competency.
- At least 2 years of technology industry or related experience, including building highly scalable, scaled-out architectures on large-scale database platforms.
- 2 years of experience in a data engineering role.
- 2+ years building highly scalable applications using 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 working in a complex data infrastructure environment.
- Cloud platform experience with GCP preferred.
- Advanced SQL competency, including query optimization in large-scale database platforms.
- Experience across the SDLC lifecycle, including requirements gathering, analysis, architecture, design, implementation, testing, deployment, and technical support.
- Experience using industry-standard source control and project management tools.
- Experience writing test cases and test scripts for data quality assurance.
- Experience creating stored procedures and functions.
- Experience developing a dimensional data model using an industry-standard tool.
- Experience with Google BigQuery or equivalent.
Tools and technologies
- Python, SQL (Structured Query Language), Spark, Spark-SQL
- Airflow, GCP, Google BigQuery
- SDLC, stored procedures, functions, dimensional data model
Benefits
- Medical, dental, and vision plans
- 403(b)
- Life insurance
- Paid time off
- Tuition reimbursement
Preferred experience
- Experience in healthcare or a related industry
- Experience with GCP and data warehouse stores like BigQuery
- Experience productizing or automating predictive models using R, SAS, Python, SPSS, etc.
- Experience with 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
USD 110,122 - 165,182 per year (full-time, 2080 hours worked per calendar year). Offer decisions may vary within the range based on multiple factors including equity, skills, experience, and expertise.
Note for out-of-state applicants: The compensation range is specific to Seattle. Positions located outside of Seattle may be compensated differently depending on various factors.