Data Engineer
Job Description
The Data Engineer designs and maintains scalable, secure data processing pipelines to collect, connect, centralize, and curate data for the Enterprise Data Warehouse. This role supports cloud-based data engineering work within an Agile team.
Role Summary
Build and operate cloud data processing infrastructure that enables efficient movement and transformation of data across systems. You will design, implement, test, and deploy solutions, supporting data integration workflows drawn from internal and external sources.
Key Responsibilities
- Build data processing pipelines that collect, connect, centralize, and curate data from internal and external sources using a variety of languages and tools to integrate systems for the Enterprise Data Warehouse.
- Use modern cloud platforms and services to develop scalable, secure, and reliable data engineering solutions for moving and transforming data across systems.
- Design, implement, test, and deploy cloud-based data processing infrastructure.
- Perform work in an Agile team environment.
- Break down, estimate, and provide just-in-time design for small increments of work.
Required Qualifications
- Bachelor’s Degree in computer science or related field, or an equivalent combination of education, experience, and technical training demonstrating analytical and technical competency.
- Minimum of two (2) years of technology industry or related experience, including experience building 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 using Python and SQL (Structured Query Language).
- 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 competency in SQL, including query optimization on large-scale database platforms.
- Experience across the SDLC process, 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 an industry-standard tool.
- Experience with Google BigQuery or an equivalent platform.
Technologies
- Python
- SQL (Structured Query Language)
- Spark and Spark-SQL
- Airflow
- GCP
- Google BigQuery
- SDLC
- Stored procedures and functions
- Dimensional data model
Preferred Experience
- Experience in Healthcare or a related industry.
- Experience with GCP and data warehouse stores such as BigQuery.
- Experience productizing or automating predictive models using R, SAS, Python, or SPSS.
- 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 frameworks and test-driven development methodology for analytic solutions.
- API development.
- Data visualization and/or dashboard development.
Location and Work Model
Seattle, WA (hybrid)
Compensation
USD 110,122 - 165,182 per year
This compensation range is 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.
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
- Medical, dental, and vision plans
- 403(b)
- Life insurance
- Paid time off
- Tuition reimbursement