GEI Consultants, Inc.

Data Engineer

Wakefield, Massachusetts, USA · full-time

Sponsorship not specified$90k-$150kDetected 102 days ago

PythonSQLDatabricksAzureTerraformCI/CDDevOpsRESTSparkData EngineeringData VisualizationRAGCybersecurityUnityLeadershipCollaboration

About the role

This role focuses on ensuring enterprise data is accessible, reliable, and governed so that AI capabilities can be deployed and scaled with confidence.
The Data Engineer plays a hands-on role by preparing and integrating the data foundations that AI solutions depend on.
Instrument data pipelines for monitoring, alerting, cost control, and performance optimization.

The Data Engineer is responsible for designing, building, and maintaining the data pipelines and integrations that power GEI's AI solutions and digital initiatives.
This includes building ingestion pipelines, managing data stores, implementing quality and governance controls, and supporting retrieval patterns such as RAG.
Essential Responsibilities & Duties 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.
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.

Experience with Azure data services, including Azure Data Factory, Azure Synapse Analytics, Azure Data Lake Storage, and Azure SQL.
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.
Our range of expertise, project types, and culture make us the choice for top talent in the AEC industry.
Minimum 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.

Proficiency in Python and SQL
experience with PySpark or Spark is strongly preferred.
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.

We are technical experts, collaborators, and entrepreneurs who draw from diverse backgrounds to solve our clients' most complex challenges.
With several offices across North America, we offer a range of engineering, science, and technical consulting services.

Usual workday hours: x 8 10 12 Other work hours GEI is an AA/equal opportunity employer, including disabled and veterans.

This listing is sourced directly from GEI Consultants, Inc.'s careers page and normalized into a canonical job model.