Data Engineer

GEI Consultants, Inc.; Rancho Cordova (CA); Hybrid; USD 90,000 - 150,000; Full time

Benefits offered by this job

Market-Competitive Compensation

Comprehensive benefits program

Hybrid work schedules

Continuing education assistance

Paid holidays and time off

Job summary

A leading engineering firm in Rancho Cordova, California, is seeking a Data Engineer to design and maintain data pipelines that support AI initiatives. The ideal candidate will have over 4 years of data engineering experience, proficiency in Python and SQL, and experience with Azure services like Data Factory and Synapse Analytics. The position offers a salary range of $90,000 to $150,000 per year, comprehensive benefits, and the possibility for hybrid work schedules.

Qualifications

• 4+ years of data engineering experience with production data pipelines.
• Strong knowledge of data governance and security practices.
• Familiarity with infrastructure-as-code practices.

Responsibilities

• Design and maintain data pipelines for enterprise data.
• Develop integrations across data sources using various techniques.
• Implement data quality and governance controls.

Skills

Data engineering experience

Proficiency in Python

Proficiency in SQL

Experience with PySpark or Spark

Experience with Azure data services

Data modeling knowledge

Experience with ETL/ELT pipelines

Knowledge of data governance principles

Knowledge of security best practices

Tools

Azure Data Factory

Azure Synapse Analytics

Azure Data Lake Storage

Databricks

Terraform

Azure DevOps

Job description

Overview

Your role at GEI: As a Data Engineer, you will design, build, and maintain data pipelines and integrations that power GEI’s AI solutions and digital initiatives. This role focuses on ensuring enterprise data is accessible, reliable, and governed so AI capabilities can be deployed and scaled with confidence.

Responsibilities

• Design, build, and maintain data pipelines that ingest, transform, and deliver enterprise data to AI solutions and business applications.
• Develop and manage integrations across enterprise data sources using APIs, Graph connectors, event‑driven architectures, and batch/streaming patterns.
• Build and maintain data stores and indexing infrastructure that support retrieval‑augmented generation (RAG) and other AI consumption patterns.
• Implement data quality, validation, and lineage controls to ensure accuracy and trustworthiness of data feeding AI workflows.
• Support and optimize data models underpinning Power BI dashboards and AI‑enabled analytics.
• Collaborate with AI Engineers to define data contracts and ensure pipeline outputs meet solution requirements for schema, latency, and freshness.
• Instrument data pipelines for monitoring, alerting, cost control, and performance optimization.
• Implement data governance and security controls including access management, encryption, and compliance with organizational data policies.
• Identify data‑related risks and support mitigation strategies in collaboration with architecture and platform teams.

Qualifications

• 4+ years of data engineering experience, with demonstrated ability to build and operate production data pipelines.
• Proficiency in Python and SQL; experience with PySpark or Spark is strongly preferred.
• Experience with Azure data services, including Azure Data Factory, Azure Synapse Analytics, Azure Data Lake Storage, and Azure SQL.
• Familiarity with Azure AI Search, Cosmos DB, or similar services used to support AI retrieval and storage patterns.
• Experience building and managing ETL/ELT pipelines with structured, semi‑structured, and unstructured data sources.
• Knowledge of data modeling, schema design, and indexing strategies for both analytical and AI workloads.
• Familiarity with infrastructure‑as‑code and CI/CD practices for data pipeline deployment (e.g., Terraform, Azure DevOps).
• Knowledge of data governance principles, including data cataloging, lineage, access control, and privacy requirements.
• Knowledge of security best practices for data solutions, including encryption at rest and in transit, role‑based access control, and private networking.
• Experience with Databricks, including Delta Lake and Unity Catalog, is a plus.
• Prior experience in professional services, engineering, or construction environments is a plus.
• Azure or Databricks certifications (e.g., Azure Data Engineer Associate, Azure Solutions Architect Expert, Databricks Data Engineer Professional) are a plus.

Compensation and Benefits

• Pay Range for This Position: $90,000.00 – $150,000.00 per year.
• Market‑Competitive Compensation, including eligibility for an annual performance bonus.
• Comprehensive benefits program: medical, dental, vision, life, disability, and more.
• Well‑being program and paid parental leave.
• Hybrid work schedules and cell phone stipends.
• Continuing education assistance and tuition reimbursement.
• Paid holidays and generous paid time off.
• Rewards and recognition programs.

Equal Employment Opportunity

GEI is an AA/equal opportunity employer, including disabled and veterans.