Data Engineer (Hybrid)

Job Description

Position Overview:

Our client has an immediate opening for a Data Engineer. The ideal candidate will play a critical role in designing, developing, and maintaining our data infrastructure.

Location:

Hybrid to Kirkland, WA ( Tu-Th in office)

Key Responsibilities:

Data Pipeline Development:

Design, implement, and maintain scalable data pipelines to collect, process, and store data from various sources.

Ensure data quality, accuracy, and consistency throughout the pipeline.

Data Integration:

Work closely with cross-functional teams to integrate data from diverse sources, including databases, APIs, and external data providers.

Develop and maintain ETL processes to transform and enrich raw data into actionable insights.

Performance Tuning:

Monitor and optimize the performance of data pipelines and databases to meet business requirements.

Identify and resolve bottlenecks and performance issues.

REQUIREMENTS:

Experience:

3+ years experience in SQL Query Design, SQL Performance Tuning and Query Optimization.

3+ years of relevant experience in Data Warehouse Design, Data Warehouse Technical Architectures, Development and Implementation.

3+ years of relevant experience in ETL Development, ETL Implementation, Unit Testing, Troubleshooting and Support of ETL Processes.

Knowledge and Skills:

Proficiency in SQL Query Design and Implementation.

Python programming skills.

Strong Experience with Relational Data Warehouse Systems.

Data Warehouse Management Systems.

Optimization by Indexing, Partitioning and Denormalization.

Strong Ability to build and optimize data sets, ‘big data’ data pipelines and architecture.

AWS experience

Strong analytical and problem-solving skills.

BENEFITS:

Compensation: $80,000-120,000 base pay

Flexible Time Off and Paid Holidays

Medical/Vision/Dental Insurance, Voluntary Life & AD&D Insurance, Short-Term & Long-Term Disability, Critical Illness & Accident Insurance

401(k) with employer matching

Hybrid/remote with flexible work schedule

Compensation Range: $80K - $120K

Full-time

Hybrid remote