Lead Data Engineer

Ingrain Systems Inc; Pleasanton (CA); On-site; USD 140,000 - 190,000; Full time

Job summary

Ingrain Systems Inc is seeking a Lead Data Engineer to join the Data & AI Organization in Pleasanton, CA onsite. The role focuses on designing, developing, and delivering enterprise data products and analytics across Sourcing, Transportation, and WMS domains on cloud-native platforms.

Ideal candidates will lead technically, work with cross-functional teams, and drive scalable data solutions to enable analytics and AI-driven decision making using GCP, BigQuery, and dbt.

Qualifications

• 8+ years of experience in Data Engineering with demonstrated technical leadership on enterprise data projects.
• Strong hands-on experience with Google Cloud Platform (GCP).
• Expert-level proficiency in: BigQuery, SQL, dbt (Data Build Tool).
• Strong understanding of modern ETL/ELT architecture and large-scale data processing.
• Strong knowledge of data modeling techniques, including dimensional modeling, normalized data models, and analytical data warehouse design.
• Experience building scalable and maintainable cloud-native data pipelines.
• Experience with Git, CI/CD pipelines, and engineering best practices.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent verbal and written communication skills with the ability to collaborate effectively across cross-functional teams.

Skills

Data engineering

GCP

BigQuery

SQL

dbt

ETL/ELT

Data modeling

Data pipelines

Communication

Troubleshooting

Problem solving

Tools

Airflow

Kafka

PySpark

Python

Git

CI/CD

Job description

Lead Data Engineer – Data & AI, Supply Chain

Location: Pleasanton, CA- Onsite

About the Role

Experienced Lead Data Engineer to join the Supply Chain Data & AI Organization. This role will support the design, development, and delivery of enterprise data products and analytics solutions across the Sourcing, Transportation, and Warehouse Management (WMS) domains.

The ideal candidate is a hands-on technical leader with deep expertise in building modern cloud-native data platforms on Google Cloud Platform (GCP). You will collaborate with Product Managers, Solution Architects, Data Architects, Business SMEs, and engineering teams to develop scalable, high-quality data solutions that enable advanced analytics, and AI-driven decision making.

Required Technical Skills

• 8+ years of experience in Data Engineering with demonstrated technical leadership on enterprise data projects.
• Strong hands-on experience with Google Cloud Platform (GCP).
• Expert-level proficiency in:
  • BigQuery
  • SQL
  • dbt (Data Build Tool)
• Strong understanding of modern ETL/ELT architecture and large-scale data processing.
• Strong knowledge of data modeling techniques, including dimensional modeling, normalized data models, and analytical data warehouse design.
• Experience building scalable and maintainable cloud-native data pipelines.
• Experience with Git, CI/CD pipelines, and engineering best practices.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent verbal and written communication skills with the ability to collaborate effectively across cross-functional teams.

Preferred Technical Skills

• Experience with Apache Airflow for workflow orchestration.
• Experience integrating enterprise data platforms with Apache Kafka or other streaming technologies.
• Working knowledge of PySpark for distributed data processing.
• Proficiency in Python for data engineering, automation, and utility development.
• Familiarity with data quality, metadata management, and data governance best practices.

Domain Experience (Highly Desirable)

Candidates with experience in one or more of the following areas will be strongly preferred: