Data Engineer, Lead
Job Description
Seattle Children’s Hospital is hiring a Lead Data Engineer to help design and deliver secure, scalable data processing capabilities that support an Enterprise Data Warehouse. In this hybrid role in Seattle, WA, you will work in an Agile environment to plan, build, test, and deploy data engineering infrastructure that collects, connects, centralizes, and curates data for integrated analytics and reporting.
This position focuses on modern cloud-based data platforms and end-to-end delivery of data pipelines, from requirements and architecture through implementation, testing, deployment, and technical support. The salary range for this full-time role is USD 146,572 - 219,858 per year and reflects compensation calculations based on 2080 hours worked per calendar year.
Responsibilities
- Build data processing pipelines that collect, connect, centralize, and curate data from internal and external sources for the Enterprise Data Warehouse, using a variety of languages and tools.
- Architect and leverage modern cloud platforms and services to design, develop, and implement scalable, secure, and reliable data engineering solutions for moving and transforming data across systems.
- Design, implement, test, and deploy data processing infrastructure.
- Work in an Agile team setting.
- Break down and estimate work, providing just-in-time design for small increments of delivery.
Requirements
- Bachelor’s Degree in computer science or a related field, or an equivalent combination of education and experience/technical training demonstrating analytical and technical competency.
- Minimum of 9 years of technology industry or related experience.
- 3 years building highly scalable, scaled-out architectures on large-scale database platforms.
- Minimum 5 years with cloud platforms, with GCP preferred.
- Minimum 5 years experience with Google BigQuery or an equivalent platform.
- Experience building scalable data pipelines using Spark or Spark-SQL with an Airflow scheduler/executor framework or similar scheduling tools.
- Experience working in complex data infrastructure environments.
- Experience in a technical lead role supporting integrated data solutions across customer groups, or 3 years in a senior data engineering role.
- Extensive and in-depth data pipeline development experience with industry-standard data integration tools.
- Advanced competency in SQL, including the ability to optimize queries and mentor others in query optimization for large-scale database environments.
- Experience leading full development life cycle management, including requirements gathering, analysis, architecture, design, implementation, testing, deployment, and technical support.
- Experience with industry-standard tools 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 models using industry-standard tools.
Technologies
- GCP
- Google BigQuery
- Spark
- Spark-SQL
- Airflow
- SQL
- R
- SAS
- Python
- SPSS
- CI/CD
- Source Control
- Project Management
- API development
- Data visualization
- Dashboard development
Benefits
- Medical, dental, and vision plans
- 403(b)
- Life insurance
- Paid time off
- Tuition reimbursement
Note: This is a hybrid position in Seattle, WA.
Preferred
- AI experience
- Experience in Healthcare or related industry
- Experience with GCP cloud services and data warehouse stores like BigQuery
- Experience productizing or automating predictive models using R, SAS, Python, SPSS, etc.
- Experience in version control and CI/CD (Continuous integration and continuous delivery) tools
- Familiarity with Agile framework and test driven development methodology for analytic solutions
- API development
- Data visualization and/or dashboard development
- Demonstrated ability to achieve stretch goals in a highly innovative and fast-paced environment
Out-of-state applicants: The compensation range listed is specific to Seattle. Positions located outside of Seattle may be compensated differently based on various factors.