Data Engineer

Keka Technologies Private Limited; Gurugram District; On-site; INR 800,000 - 1,200,000; Full time

Job summary

ESP Engineered is looking for a Data Engineer in Gurugram, Haryana to ensure reliable data flow for the Nutrabay analytics engine. Your role will involve building and managing ingestion pipelines using AWS Glue, optimizing Amazon Redshift for performance, and implementing data quality checks. Candidates should have 2-5 years of experience and be proficient in Python, SQL, and AWS tools. A strong reliability mindset and problem-solving capabilities are essential for success in this position. Work will be in-office on Golf Course Road.

Qualifications

• 2-5 years of experience as a Data Engineer.
• Proficiency in AWS data stack, specifically AWS Glue, Redshift, and S3.
• Advanced skills in Python and SQL.

Responsibilities

• Build ingestion pipelines using AWS Glue to sync data.
• Manage and optimize Amazon Redshift for query efficiency.
• Implement automated checks for data reliability.
• Collaborate on dbt infrastructure setup.

Skills

AWS Glue

Python

SQL

Database Administration

API Integration

DevOps

Job description

The Data Engineer is the backbone of the Nutrabay analytics engine. Your mission is to ensure that data flows seamlessly and reliably from our production, third party channels, warehouse management system, ERP, Logistics, and Marketing APIs into our warehouse. You are responsible for the "Reliability" of the system. You will build the infrastructure that allows our analysts to work with clean, updated, and validated raw data every single morning.

You should apply if you have:

• Cloud Data Pipeline Mastery: Strong hands‑on experience with AWS Glue (Python/Spark) and S3.
• Database Administration: Experience managing Amazon Redshift, including performance tuning, vacuuming, and schema management.
• API Integration Skills: Ability to write robust Python scripts to fetch data from third‑party logistics, marketing platforms and marketplaces.

You should not apply if you:

• Are not proficient in Python and SQL.
• Do not have experience with the AWS data stack.
• Prefer building one‑off reports over building scalable, automated pipelines.

What will you do?

• Build Ingestion Pipelines: Own the AWS Glue jobs that sync data from RDS, Vinculum, ClickPost, and MoEngage into Redshift.
• Warehouse Administration: Ensure Redshift is optimized for query speed and cost. Manage staging and raw schemas.
• Data Reliability (QC): Implement automated checks to ensure the record counts in the warehouse match the source systems.
• dbt Infrastructure: Collaborate with the Senior Analyst to provide the server/environment (GitHub Actions/EC2) where dbt runs.

Skills Required

• AWS Stack: Expert in AWS Glue, S3, and Redshift.
• Python: Advanced scripting for ETL and API integrations.
• SQL: Expert‑level query writing and database performance optimization.
• DevOps: Basic understanding of Git/GitHub for version controlling ingestion scripts.
• API Integration, REST APIs
• DBT

Business & Soft Skills

• Reliability Mindset: Obsession with pipeline uptime and data accuracy.
• Problem Solving: Ability to debug complex sync issues between fragmented source systems.

Work Experience

2‑5 years

Location

Golf Course Road, Gurugram, Haryana (Work from Office)