DeveloperJobs.io
← Back to all jobs

Job Description

Seattle Children’s Hospital is hiring a Data Engineer (hybrid) to build and maintain secure, scalable data processing pipelines for the Enterprise Data Warehouse.

Responsibilities

  • 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 help marry systems together across datasets and services
  • Leverage modern cloud platforms and services to deliver scalable, secure, reliable data engineering solutions
  • Develop infrastructure to move and transform data efficiently across systems
  • Design, implement, test, and deploy cloud-based data processing infrastructure
  • Perform work in an Agile team environment
  • Break down work, estimate effort, and provide just-in-time design for small increments

Requirements

  • Bachelor’s Degree in computer science or related field, or an equivalent combination of education and experience/technical training demonstrating analytical and technical competency
  • Minimum 2 years technology industry or related experience, including building highly scalable, scaled-out architectures on large-scale database platforms
  • 2 years experience in a data engineering role
  • Experience working in a complex data infrastructure environment
  • 2+ years building highly scalable applications using Python and SQL
  • Experience building scalable data pipelines using Spark or Spark-SQL with an Airflow scheduler/executor framework or similar scheduling tools
  • Experience with cloud platforms, with GCP preferred
  • Advanced SQL competency, including query optimization on large-scale database platforms
  • Experience with SDLC including requirements gathering, analysis, architecture, design, implementation, testing, deployment, and technical support
  • Experience with 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

Technologies

  • Python
  • SQL (Structured Query Language)
  • Spark, Spark-SQL
  • Airflow
  • GCP
  • Google BigQuery, BigQuery
  • SDLC
  • Stored procedures, functions
  • Dimensional data model

Benefits

  • Medical, dental, and vision plans
  • 403(b)
  • Life insurance
  • Paid time off
  • Tuition reimbursement

Compensation

  • USD 110,122 - 165,182 per year
  • Based on full-time employment (2080 hours worked per calendar year)
  • Offers determined by multiple factors including equity, skills, experience, and expertise, and may vary within the provided range

Location

  • Seattle, WA (hybrid)

Preferred

  • Experience in healthcare or related industry
  • Experience with GCP cloud services and data warehouse stores such as 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 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

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.

Similar Jobs