Enterprise Data Analyst – AGOS Aviation

Opportunity Overview

Enterprise AI & ULD Data Analytics Workflow

The Enterprise Data Analyst at AGOS Aviation bridges enterprise backend data (CosmosDB, MS-SQL) with front-end aviation operational systems (ULD Control), building real-time visualisations and AI-driven predictive insights:

┌───────────────────────────────────────────┐
│ 1. Data Warehousing & Ingestion (Azure)   │ ➔ Extract & validate operational ULD data from CosmosDB & MS-SQL database instances
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 2. Data Modeling & ETL Processing         │ ➔ Design scalable data models and clean data pipelines using Python, SQL, and Azure APIs
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 3. Visualization & Frontend Integration   │ ➔ Deploy Power BI reports and connect charts ((vue)-Chart.js/Recharts) to web applications
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 4. GenAI Automation & Process Improvement │ ➔ Build Generative AI proof-of-concepts to automate reporting workflows & trend analysis
└───────────────────────────────────────────┘

Key Responsibilities

• Enterprise Dashboarding & Reporting: Design, deploy, and maintain interactive Power BI reports and KPI trackers for cross-functional aviation teams.

• ULD Database Management: Query, clean, and model datasets hosted on Azure CosmosDB and MS-SQL to track Unit Load Device (ULD) inventory, movement, and efficiency.

• Frontend Web Integration: Collaborate with software engineering teams to surface analytical feeds on Vue.js web applications using Fastify/Express backends and JS charting libraries (Chart.js, Recharts).

• Generative AI Prototyping: Build practical proof-of-concepts (PoCs) leveraging Generative AI and machine learning to automate analytics workflows and surface trend insights.

• Governance & Model Monitoring: Ensure rigorous data security compliance, audit data model performance, and maintain documentation across Git environments.

Qualification Matrix & Technical Skill Stack

Core Requirements

Key Focus Areas for Interview Preparation

1. NoSQL & CosmosDB Data Modeling: Practice connecting Power BI and web frontends to NoSQL databases like CosmosDB, focusing on JSON document parsing and query performance.

2. Aviation Logistics & ULD Operations: Review aviation ground-handling and ULD tracking metrics, such as ULD Utilization Rate, Tare Weight Balance, Demurrage/Loss Tracking, and Turnaround Times.

3. Full-Stack Analytics Integration: Be prepared to explain how to expose Python/SQL analytics outputs as web APIs (using Fastify/Express) to power Vue.js frontend dashboards.