Intern

Job Description

Job Posting Title: Intern, Data Analyst

Position Summary

A highly motivated Intern with a background in Computer Science, Data Science, Data Analytics, Data Engineering or Software Engineering. In this role, you will tackle a critical operational challenge: transforming disorganized, scattered production and repair logs into a highly structured, centralized data ecosystem. Your primary objective will be to design, build, and deploy automated data pipelines and advanced dashboards that provide real-time visibility to department leadership.

Key Responsibilities

• Data Centralization: Audit, clean, and consolidate disparate data sources scattered across regional spreadsheets, local files and departments.

• Pipeline Data Engineering: Build and optimize relational data structures using Google BigQuery or advanced Google Sheets architecture.

• Dashboard Development: Design and deploy intuitive, automated visualization dashboards using Looker Studio, Tableau, or Power BI.

• Process Automation: Write scripts (e.g., Python, Google SQL or Google Apps Script) to automate manual data extraction and scheduling tasks.

• Stakeholder Collaboration: Partner with Warehouse, Maintenance and Engineering Support Team to translate raw technical metrics into actionable departmental KPIs.

Required Qualifications

• Education: Currently pursuing a Bachelor’s degree in Computer Science, Data Science, Data Analytics, Data Engineering, Software Engineering, or a related technical field.

• Database Skills: Strong foundational knowledge of SQL queries, data modelling, and database normalisation.

• Analytics Tools: Hands-on familiarity with Google BigQuery, advanced Google Sheets formulas (e.g., Query, ArrayFormula), or cloud data warehouses.

• Visualization: Experience creating clean, interactive user interfaces and performance dashboards.

• Programming: Basic proficiency in Python, R, or Javascript/Google Apps Script is highly preferred.

What You Will Learn & Gain

• Ownership: Direct responsibility for architectural decisions from raw data ingestion to final executive visualisation.

• Domain Expertise: Deep understanding of Airline/MRO operations, Asset and Component repair process and conversant in the Engineering support chain ecosystem.

• Mentorship: Direct guidance from experienced operations managers to help bridge the gap between academic theory and enterprise reality.