Job Description

As a Strategic Planning Data Analyst you are responsible for overhauling our modelling capability and airport capacity analysis, to fully exploit our data and help drive data-driven decision-making.


This is a key role in the Strategic Planning team, where you'll be designing and creating scalable, data pipelines to power forward-thinking and business-critical decisions that support our growth aspirations.


This role requires a hands-on approach to data analytics, working across multiple stakeholders and managing complex datasets to provide valuable insights.

Main Tasks and Responsibilities:

Develop and maintain dashboards and reports in Fabric and Power BI to support business needs. Create intuitive and user-friendly interfaces for internal teams, making sure that all software products are highly usable and meet the users' requirements. Designing, building, and optimising data pipelines across multiple sources using Microsoft Fabric and other Azure technologies Ensuring data quality and integrity through validation and cleansing techniques Write and optimize SQL queries (views and select statements) to transform and extract data efficiently. Leverage Power Automate to streamline and enhance business processes. Utilize Python for data analysis, automation, and workflow optimization. Collaborate with internal and external stakeholders, including directors, Finance, and operational staff, to understand data requirements and deliver actionable insights.

Key Competencies:

Problem Solving. Seeks solutions to problems in a practical and pragmatic way, demonstrating a logical and analytical approach. Passion for Business Analysis. Passionate and knowledgeable about Business Analysis and industry best practice. Action Oriented. Takes on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm. Takes timely action on important or difficult issues. Identifies and pursues new opportunities that benefit the organization. Collaboration. Builds partnerships with internal and external stakeholders & suppliers and works collaboratively with others, bringing them together to meet shared objectives. Data Knowledge. Be knowledgeable of different methodologies and best practices for data extraction, transformation, and load (e.g. ELT) between different applications and technologies.

Qualifications:

A Level/degree in Mathematics or STEM 2+ years' experience in a similar role

Working Hours:

Full time, including at least 2 days per week on-site


This role is offered on a 6 Month Fixed Term Contract (FTC)

Benefits:

Free onsite parking Access to discounted Private Medical Insurance for you and immediate family Medicash Cash plan On site Physiotherapist Discounted Gym Membership at many local facilities Staff discounts at most of retailers on site & some local restaurants & hotels Enrolment into company AE pension scheme Access to Salary sacrifice pension scheme Bereavement Counselling Cycle 2 Work salary sacrifice scheme Hastee Pay Advances 22 Days Annual leave LCY Central discount website Annual Season Ticket Loan Holiday Buy scheme (Ability to purchase up to 1 weeks A/L per year)


London City Airport is one of the largest private sector employment sites in the London Borough of Newham. We offer a wide range of interesting and challenging career opportunities for the local community.


With over 2,000 employees here, working either directly for London City Airport Limited or for one of our concession partners, airlines, or other business partners on site, the scope for career satisfaction and progression is huge.


London City Airport is an Inclusive Employer.

At London City Airport we respect and celebrate each other's individual differences. We embrace all backgrounds and abilities of all team members and we work closely with our Inclusion Group A Voice for all to ensure we are an inclusive workplace.


Please note that we only ask candidates to go through the necessary security checks (Criminal Record Checks or CRC) once a position has been offered. If you are approached by a third-party site offering to manage the process for you, please ignore it.

London City Airport Ltd is not currently delivering a Graduate Training Programme but we do run a Work Experience Programme. Please

click here

to find out more.