AI-Ready Data Engineer: Pipelines & Governance

GEI Consultants, Inc; City of Niagara Falls (NY); Hybrid; USD 90,000 - 150,000; Full time

Benefits offered by this job

Hybrid Work Schedules and Cell PhoneSt

GEI University (GEIU) with ContinuingE

Paid Holidays and Generous Paid Time O

Job summary

GEI Consultants, Inc. is seeking a Data Engineer to design, build, and maintain data pipelines powering AI solutions and dashboards. You will ensure data is accessible, reliable, and governed, enabling scalable AI capabilities across GEI’s platforms.

You will collaborate with AI Engineers and platform teams to deploy production-ready data infrastructure, implement quality controls, and support retrieval patterns used by Power BI and other analytics tools.

Qualifications

• 4+ years of data engineering experience building production data pipelines.
• Proficiency in Python and SQL; PySpark experience preferred.
• Experience with Azure data services (ADF, Synapse, Data Lake Storage, SQL).
• Familiarity with Azure AI Search, Cosmos DB, or similar.
• Experience with ETL/ELT pipelines across structured, semi-structured, and unstructured data.

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 optimise 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 optimisation.
• Implement data governance and security controls including access management, encryption, and compliance with organisational data policies.

Skills

Python

SQL

PySpark

Azure Data Services

Data Governance

Data Modeling

CI/CD

Terraform

Security Best Practices

Tools

Databricks

Delta Lake

Unity Catalog

Azure DevOps

Job description

GEI Consultants, Inc. is seeking a Data Engineer to design, build, and maintain data pipelines powering AI solutions and dashboards. You will ensure data is accessible, reliable, and governed, enabling scalable AI capabilities across GEI’s platforms.

You will collaborate with AI Engineers and platform teams to deploy production-ready data infrastructure, implement quality controls, and support retrieval patterns used by Power BI and other analytics tools.