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 dashboard components.
Debug data discrepancies between backen

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