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, 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 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/GitHub. 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.