Trainee Data Engineer

Air India Limited; Gurugram District; On-site; INR 600,000 - 1,000,000; Full time

Job summary

Air India Limited is seeking a data engineering professional to manage operational data, build scalable pipelines, and enable organization-wide reporting using the Microsoft ecosystem.

You will design end-to-end pipelines, optimize Power BI dashboards, implement RLS, and collaborate with stakeholders to deliver automated analytics and data models across Power BI, Power Apps, and Power Automate.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics or related field.
• 0 to 2 years of experience in data engineering, analytics or BI roles using the Microsoft stack.

Responsibilities

• Design and maintain end-to-end data pipelines using SQL, Microsoft Fabric, and Python to support operations and planning analytics.
• Develop and manage centralized databases and reusable data models for seamless integration across Power BI, Power Apps, and other analytics platforms.
• Build and optimize Power BI dashboards and data models, implementing Row-Level Security (RLS), performance tuning, and enterprise-wide report distribution.
• Collaborate with stakeholders to gather reporting requirements and deliver actionable insights via automated dashboards and self-service tools.
• Integrate Power Automate and Power Apps for workflow automation and operational process digitization.
• Maintain data accuracy, schedule refreshes, and monitor Power BI services and dataflows for uninterrupted delivery.
• Support adoption of Microsoft Fabric ecosystem including Dataflows, Lakehouses, Notebooks, and Pipelines for modern data architecture.

Skills

Data pipelines

Data modeling

DAX

Power Query

RLS

ETL

Dashboards

Analytics

Education

Bachelor's degree in CS/IS/Analytics

Tools

Power BI

Power Apps

Power Automate

Microsoft Fabric

SQL

Python

Job description

Job Description:

A. Job Purpose

• This role is central to managing the airline's operational data, building scalable data pipelines, enabling organization-wide reporting, and driving automation using the Microsoft ecosystem.

B. Key Accountabilities

Functional Activities

• Design and maintain end-to-end data pipelines using SQL, Microsoft Fabric, and Python to support operations and planning analytics.
• Develop and manage centralized databases and reusable data models for seamless integration across Power BI, Power Apps, and other analytics platforms.
• Build and optimize Power BI dashboards and data models, implementing Row-Level Security (RLS), performance tuning, and enterprise-wide report distribution.
• Collaborate with stakeholders to gather reporting requirements and deliver actionable insights via automated dashboards and self-service tools.
• Integrate Power Automate and Power Apps for workflow automation and operational process digitization.
• Maintain data accuracy, schedule refreshes, and monitor Power BI services and dataflows for uninterrupted delivery.
• Support adoption of Microsoft Fabric ecosystem including Dataflows, Lakehouses, Notebooks, and Pipelines for modern data architecture.

Any other additional responsibility could be assigned to the role holder from time to time as a standalone project or regular work. The same would be suitably represented in the Primary responsibilities and agreed between the incumbent, reporting officer and HR.

C. Skills Required for the role

Airline Operational Expertise Power BI - report development, data modeling, DAX, Power Query, and RLS.

SQL, Power BI, Python, Databases , Power Automate and Power Apps Familiarity with the Microsoft Fabric suite - including Dataflows, Pipelines, Lakehouse, and Fabric Notebooks.

D. Key Interfaces

Internal Interfaces

Mission Management,Flight Ops, CCD, AOD

• Making interactive dashboards and automation solutions doe all these teams to address their specific needs and ease the decision-making process

E. Educational and Experience Requirements

Minimum Education Requirement

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field
• 0 to 2 years of experience in data engineering, analytics, or business intelligence roles using the Microsoft stack

Requirements: