Data Engineer | Onsite | Sunnyvale, California

Posted 21 Days Ago
Hiring Remotely in United States
Remote
48K-168K Annually
Senior level
Agency • Information Technology
The Role
Build and maintain scalable batch and incremental data pipelines using Python, SQL, and Snowflake. Develop warehouse models, transformations, automation, data quality checks, lineage, alerting, and performance optimizations. Collaborate with analysts, data scientists, and application teams to deliver trusted datasets, while documenting pipelines, schemas, and data contracts.
Summary Generated by Built In

Role Overview 

We need an experienced Data Engineer to build and maintain reliable, scalable data pipelines and warehouse models on Snowflake. You will turn raw data from many sources into trusted datasets for analytics, reporting, and downstream applications. 

Key Responsibilities 

  • Design, build, and operate batch and incremental data pipelines using Python and SQL. 
  • Develop and optimize data models and transformations in Snowflake. 
  • Write automation and operational scripts to orchestrate, monitor, and troubleshoot data workflows. 
  • Implement data quality checks, validation, lineage, and alerting. 
  • Tune query performance and manage warehouse cost and resource usage. 
  • Collaborate with analysts, data scientists, and application teams to understand requirements and deliver datasets. 
  • Document pipelines, schemas, and data contracts. 

Required Qualifications 

  • 7+ years of experience in data engineering or a closely related field. 
  • Strong Python skills and experience with scripting languages (for example Bash). 
  • Advanced SQL, including complex joins, window functions, and performance tuning. 
  • Hands-on experience with Snowflake (warehouses, stages, tasks, streams, role-based access). 
  • Solid understanding of data warehousing, dimensional modeling, and ETL/ELT patterns. 

Preferred Qualifications 

  • Experience with orchestration tools (for example Airflow) and transformation frameworks (for example dbt). 
  • Familiarity with AWS or GCP data services. 
  • Exposure to data governance, security, and privacy practices. 

Compensation, Benefits and Duration

Minimum Compensation: USD 48,000
Maximum Compensation: USD 168,000
Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role.
Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full time employees.
This position is available for independent contractors
No applications will be considered if received more than 120 days after the date of this post.
 

Skills Required

  • 7+ years of experience in data engineering or a closely related field
  • Strong Python skills and scripting experience, such as Bash
  • Advanced SQL skills, including complex joins, window functions, and performance tuning
  • Hands-on experience with Snowflake warehouses, stages, tasks, streams, and role-based access
  • Understanding of data warehousing, dimensional modeling, and ETL/ELT patterns
  • Experience with orchestration tools such as Airflow and transformation frameworks such as dbt
  • Familiarity with AWS or GCP data services
  • Exposure to data governance, security, and privacy practices
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: London
5,017 Employees
Year Founded: 2007

What We Do

Photon.com has emerged as one of the world’s largest and fastest-growing Digital Agencies. We work with 40% of the Fortune 100 on their Digital initiatives and are known for our ability to integrate Strategy Consulting, Creative Design, and Technology at scale. Please visit www.photon.com to learn more about us, how we work, and our customer case studies. Digital Transformation Starts Here.

Similar Jobs

Hilton Logo Hilton

Director Of Finance

Events • Food • Travel • Hospitality • Hotels & Resorts
Remote
United States
500000 Employees

Liberty Mutual Insurance Logo Liberty Mutual Insurance

Analytics Manager

Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Remote or Hybrid
Remote, OR, USA
40000 Employees
106K-197K Annually

Liberty Mutual Insurance Logo Liberty Mutual Insurance

Manager, Actuary, Homeowners State Actuarial Support

Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Remote or Hybrid
5 Locations
40000 Employees
137K-257K Annually

Liberty Mutual Insurance Logo Liberty Mutual Insurance

Product Owner

Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Remote or Hybrid
7 Locations
40000 Employees
94K-197K Annually

Similar Companies Hiring

NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Austin, TX
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
567 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account