Intern-Data Engineering

Role Overview

The intern is responsible to build a standardized, governed data foundation so datasets can be discovered, understood, mapped, refreshed and consumed consistently across teams.

Qualification

B.Tech/B.E. in Computer Science, IT, Data Science or a related field. Exposure to databases, APIs, cloud data platforms or workflow automation. Interest in analytics, data governance and enterprise data architecture. Structured thinking and strong documentation discipline

Relevant Experience

• Python (Pandas, data processing, automation)

• SQL (joins, aggregations, transformations, data validation)

• Basic data engineering concepts: ETL/ELT, schemas, pipelines, keys and data quality

• Ability to create ERDs, conduct EDA and document business logic

• Strong communication and ability to work with multiple business stakeholders

• Roles & Responsibilities

• Partner with business teams to identify datasets, source systems, owners, refresh frequency, key fields and downstream use cases.

• Create and maintain enterprise data dictionaries, source inventories, field definitions and business metadata.

• Design mapping files to standardize entities such as SKU, brand, customer, distributor, channel, geography and time across sources.

• Create ER diagrams and document table relationships, keys, dependencies and data lineage.

• Perform EDA and data-quality checks to identify duplicates, missing values, inconsistent definitions and mapping gaps.

• Use Python and SQL to clean, transform, reconcile and apply business logic to datasets.

• Build simple repeatable pipelines/scripts so standardized datasets and mapping files are refreshed systematically.

• Define ownership and update processes for mapping/master files with clear business owners, controls and handover documentation.