Role Overview:

We are looking for a
Data Analyst / Data Engineer Intern
to work closely with the Product & Technology team on building and maintaining data pipelines, internal dashboards, reporting systems, and data-driven workflows.

This is a hands-on role suited for someone who is technically robust, comfortable working with databases and data pipelines, and interested in understanding how data is used to build operational products.

Key Responsibilities

1. Data Engineering & Data Pipelines

A major part of the role will involve managing data flowing across multiple systems and databases.
- Build, maintain, and troubleshoot data pipelines across sources such as **AWS RDS, Amazon Redshift, application databases, APIs, Google Sheets, and other internal systems**.
- Write and optimize
SQL queries
for data extraction, transformation, reconciliation, and reporting.
- Develop Python scripts for **ETL/ELT workflows, data transformation, validation, and automation**.
- Manage and monitor scheduled **cron jobs and recurring data workflows**.
- Identify pipeline failures,



missing records, duplicates, schema inconsistencies, and other data-quality issues.
- Create data validation and reconciliation checks between source systems and downstream dashboards.
- Work with APIs and JSON-based integrations to move data between different applications.
- Support documentation of data sources, schemas, transformations, and dependencies.

2. Dashboarding & Frappe-Based Applications

The second major responsibility will be building and maintaining operational dashboards and internal tools, primarily using
Frappe Framework / ERPNext
.
- Develop and maintain dashboards, reports, DocTypes, forms, workflows, and views in
Frappe
.
- Connect Frappe applications with databases, APIs, and internal data pipelines.
- Build operational dashboards for Product, Technology, Field, and Business teams.
- Translate business requirements into structured datasets, KPIs, filters, and dashboar

📌 Data Analyst/Data Engineer Intern (Gurugram)
🏢 DeHaat
📍 Gurugram