Data Analyst​/Data Engineer Intern

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 strong, 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, Doc Types, 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 backend databases and dashboard outputs.
Improve dashboard usability, performance, and data freshness.
Support basic frontend customisation using  JavaScript, HTML, CSS, and Frappe client/server scripting  where required.

Additional Responsibilities
Use tools such as  Postman  for API testing and debugging.
Work with REST APIs, JSON payloads, authentication mechanisms, and webhook-based integrations.
Perform product and data QA before releases.
Support workflow automation across internal systems.
Use AI tools such as  ChatGPT, Claude, or similar LLMs  for coding assistance, data analysis, documentation, debugging, and workflow automation.
Prepare technical documentation, data dictionaries, SOPs, and implementation notes.
Quickly understand new systems and work across multiple technology platforms.

##Preferred Skills
Must-have / Strongly Preferred
Strong knowledge of  SQL , including joins, aggregations, CTEs, subqueries, and data manipulation.
Good working knowledge of  Python , particularly for data processing and automation.
Understanding of relational databases and data modelling.
Experience working with  ETL/ELT pipelines and scheduled data jobs .
Strong proficiency in  Microsoft Excel / Google Sheets .
Understanding of  REST APIs, JSON, and Postman .
Strong analytical and logical problem-solving skills.

Good to Have

Experience with  Frappe Framework / ERPNext .
Exposure to  AWS RDS, Amazon Redshift, PostgreSQL, MySQL, or similar databases .
Familiarity with cron jobs, schedulers, and basic Linux/server environments.
Knowledge of  JavaScript, HTML, and CSS .
Experience building dashboards or internal reporting tools.
Familiarity with Git/Git Hub.
Experience using AI coding/productivity tools such as  ChatGPT, Claude, Cursor, or similar platforms .

## Candidate Profile
We are looking for someone who:
Has strong computer science and data fundamentals.
Enjoys working with databases and solving data problems.
Can independently investigate why a pipeline, query, API, or dashboard is not working.
Is comfortable learning unfamiliar technologies quickly.
Pays close attention to data accuracy and edge cases.
Can work across engineering, product, and business requirements rather than operating only as a traditional analyst.
Is comfortable taking ownership of small technical projects from requirement gathering through implementation and testing.

## Internship Details
Role:
Data Analyst / Data Engineer Intern
Duration: 6–9 months

Location:

Gurugram – Work from Office
Joining:
Immediate
Team:
Product & Technology

The role will provide significant hands-on exposure to production data pipelines, AWS databases, Frappe-based applications, APIs, operational dashboards, workflow automation, and AI-assisted development.