Data Engineer
Agile
Agile Methodologies
Agile Scrum
Apache Airflow
Big Data
Bigdata
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Integration
Data Integration Tools
Data Pipeline
Data Platform
Data Processing
Data Warehouse
Database
Databases
ETL
Gcp Data Engineer
Google Cloud Bigquery
Informatica
Information Technology (IT)
Programming
Programming Language
Programming Languages
Software Development
Spark
SQL
Workflow Management
Workflow Orchestration
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
C