Data Engineer Analyst – ELT & Feature Store

Job Description

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