Data Engineer

Photon; Sunnyvale (CA); On-site; USD 140,000 - 210,000; Full time

Job summary

Photon is a Digital Engineering and Digital Modernization partner founded in 1999, delivering AI, cloud-native, and next-generation digital solutions to Fortune 500 clients. We seek a Data Engineer to design, build, and maintain scalable data pipelines and warehouse models on Snowflake, turning raw data into trusted datasets for analytics and downstream apps.

You will collaborate with analysts, data scientists, and application teams, implement data quality checks, and optimize performance and

Qualifications

• 7+ years of data engineering experience or closely related field.
• Strong Python skills and scripting (e.g., Bash).
• Advanced SQL including joins, window functions, and performance tuning.
• Hands-on Snowflake experience (warehouses, stages, tasks, streams, RBAC).
• Solid data warehousing, dimensional modeling, and ETL/ELT understanding.

Responsibilities

• Design, build, and operate batch and incremental data pipelines using Python and SQL.
• Develop and optimize Snowflake data models and transformations.
• Write automation scripts to orchestrate and monitor data workflows.

Skills

Python

SQL

Bash

Data Pipelines

Data Modeling

Tools

Snowflake

Airflow

dbt

AWS

GCP

Job description

We hope you are good. We are hiring for Data Engineer to join our Digital Engineering team.

About Photon

Photon is a Digital Engineering and Digital Modernization company founded in 1999. We partner with leading global enterprises, including Fortune 500 organizations, to build and modernize digital platforms and experiences. Our teams work across AI, cloud-native technologies, and next-generation digital solutions.

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 modelling, 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.