Data Engineer

Aeris Communications India; Gurugram District, Dadri; Hybrid; INR 800,000 - 1,500,000; Full time

Job summary

Aeris Communications India seeks a skilled candidate to build and maintain an enterprise data lake. Your role will include designing ETL pipelines, developing machine learning models for forecasting, and creating AI agent integrations using LLM APIs.

The ideal candidate should have expertise in Python, SQL, and GCP services. Responsibilities entail ensuring data quality and monitoring across pipelines.

Qualifications

• Strong knowledge of Python for ETL using libraries like Pandas and NumPy.
• Experience with complex SQL queries and schema design.
• Proficiency in GCP services including BigQuery and Cloud Storage.

Responsibilities

• Build and maintain data lake on BigQuery for ingestion and transformation.
• Design ETL pipelines across various data sources.
• Develop AI agents and integrate tools using LLM APIs.

Skills

Python ETL Pandas, NumPy

SQL

GCP

Data Lake Design

REST API

Git & CI/CD

Tools

BigQuery

Cloud Storage

CloudRun

MCP

BI Tools

Job description

Role Summary

Build and maintain the enterprise data lake, design ETL pipelines, develop ML models for forecasting, and create AI agents/MCP integrations using LLM APIs.

Required Skills:

• Python ETL Pandas, NumPy, data modelling, API integrations
• SQL — Complex queries, schema design, performance tuning
• GCP — BigQuery, Cloud Storage, CloudRun, Secret Manager
• Data Lake Design — Ingestion from ERP/CRM systems (NetSuite, Salesforce), schema evolution, data quality
• REST API — Development and consumption (OAuth, webhooks)
• Git & CI/CD — Version control and deployment basics

Preferred Skills:

• AI Agent Development — Tool-calling agents, MCP servers, LLM APIs (Claude, Gemini, OpenAI)
• Machine Learning — Time series forecasting, predictive modelling (Prophet, XGBoost, SARIMAX)
• BI Tools — Qlik or Looker
• Orchestration — Cloud Scheduler, Airflow, or cron-based job pipelines

Key Responsibilities:

1. Build and maintain data lake on BigQuery — ingestion, transformation, scheduling
2. Design and implement ETL pipelines (Python) across banking, ERP, and CRM sources
3. Experiment with and deploy ML models for cash forecasting and business predictions
4. Develop AI agents and MCP tool integrations using LLM APIs
5. Ensure data quality, monitoring, and alerting across pipelines