Data Engineer Analyst – ELT & Feature Store

Overview

Job Title: Data Engineer / Analyst – ELT & Feature Store
Type: Full-Time
Industry: IT / Software
Location: Gurgaon, Haryana, India (Required)
Experience: 2 Years (Required)

Job Summary:
We are seeking a hands-on Data Engineer / Analyst to build and optimize ELT pipelines and feature stores that power forecasting and machine learning workflows. You'll work on transforming multi-source datasets into trusted, auditable data products while ensuring data quality, performance, and documentation standards.

Key Responsibilities:

• Build scalable ELT pipelines and star-schema models using TypeScript + Drizzle ORM.
• Implement data quality checks (nulls, schema drift, outliers) and post-COVID re-weighting logic.
• Develop and manage feature stores (e.g., holiday events, promo tracking, customer segments).
• Optimize ingestion and transformation performance using chunked uploads and materialized views.
• Maintain up-to-date data dictionaries, ERDs, and lineage documentation.

Required Skills:

• Advanced SQL & PostgreSQL tuning
• TypeScript and/or Python
• dbt-style modular transformations
• Git, Docker, and CI/CD basics

Good to Have:

• Experience with Airflow or Airbyte
• Familiarity with Parquet or columnar formats
• BI-level validation and support

Job Type: Full-time

Pay: ₹700,000.00 - ₹1,100,000.00 per year

Application Question(s):

• Do you have at least 2 years of professional experience in a data engineering or analytics role?
• Are you proficient in writing and optimizing Advanced SQL queries?
• Have you worked with PostgreSQL and performed query tuning?
• Are you experienced in TypeScript or Python for data scripting and transformation?
• Have you built ELT pipelines or transformations using dbt-style (modular, version-controlled) approaches?
• Have you implemented any data quality checks such as null checks, schema drift detection, or outlier handling?
• Are you familiar with data orchestration tools like Airflow or Airbyte?

Work Location: In person

Application Deadline: 07/06/2025