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.