Database Analyst

In this exciting position at a growing worldwide airport consultancy, you will be analysing big data and developing models to support client’s effective decision-making and driving strategic delivery of consultancy. Clients include London Heathrow Airport (LHR) and other airports worldwide such as Schiphol, Budapest, GMR Hyderabad International, Leeds Bradford, London Stansted and Bristol.
As airports grow again after the Covid Pandemic and become capacity constrained, we model the movement of passengers, baggage, vehicles, and aircraft analysing future demand and capacity, operations, resilience, new automation technology and new IT. Reporting to the Technical Director the role will be to develop and support our in-house simulation tools known as TransvisionAiR® which has been principally developed in Python and XML. It will also require a good working knowledge of Microsoft Office tools including Excel, Access, Visio, and Visual Basic. In addition, you will be required from time to time to support a team of Airport Analysts and Airport Planners in the delivery of client projects.
Experience of Airport operations and processes is not required as full training will be undertaken against a comprehensive induction programme lasting 9-12 months.
You will be able to use your skills in a highly creative team and will have real accountability and responsibility. With appropriate security clearance you will be working Airside at LHR to gather a ‘hands on understanding’ of the systems and testing your models in the ‘real world’.

Postgraduate – Having studied one of the following; Engineering, Applied Mathematics, Data Analytics, Science or Technology, to Post Graduate level (Master’s Degree)
● Analysing big data
● Create process capacity models and simulations utilising Excel, Visual Basic and Python as appropriate. This includes allocation plans, databases, mitigations and network maps and simulations for baggage, ground handling, passenger and airport vehicle movements.
● Data gathering
● Develop spreadsheet and database queries for reporting complex mathematical problems in a simple visual, and engaging format
● Maintain and extend existing software tools
● Assist the future re-platforming of existing software tools
● Undertake airport data acquisition and cleansing
● Project management and client presentations
● Process analysis of data, developing queries and generating reports
● Postgraduate – Having studied one of the following; Engineering, Applied Mathematics, Data Analytics, Science or Technology, to Post Graduate level (Master’s Degree)
● Technical ability in either Applied Mathematics, Data Analytics, Computing, Physics or Engineering
● Program in at least one high level language at intermediate to expert level (Python is preferable but can be VB, C# or C++)
● Program at least one simulation platform (AutoMod, Unity, CAST)
● Program/Query databases (Access & SQL) and spreadsheets (Excel) 
● Produce high quality presentation materials
● More than one programming language (especially VB, C#, or C++)
● Web-based programming (XML)
● Our experienced team supports airport owners, operators, and stakeholders across the world’s airports to assess the entire system - passengers, baggage, aircraft, transfer systems and ground service equipment – providing the big picture and detailed analysis. We solve the most complex capacity and system challenges, assessing risk and future proofing operations. Our unique Airport Intelligence gives the big picture as well as highly detailed insights and analysis.
We have expertise in airport planning, simulation of systems, applied mathematics, engineering, architecture, airport operations and stakeholder management. Our bespoke modelling and simulation software TransvisionAiR® is at the heart of our business. 
We model or simulate at the level of detail that Big Data can support and aim to provide appropriate analysis and forecasts based on realistic assumptions and processes.
This can range from a simple pivot graph in a spreadsheet through to a minimal 2D model and all the way to a fully realized 3D simulation, perhaps with virtual reality.
Job Type: Full-time
Salary: £55k to £65k year, depending on experience

Based at Cranfield University Innovation Centre, but from time-to-time travel to our office at London Heathrow. Occasional travel to clients worldwide is possible. For overseas nationals already working or studying in the UK, AiQ operates a Certificate of Sponsorship scheme