Strategic Planning Data Analyst (FTC)

London City Airport; London; On-site; GBP 40,000 - 60,000; Full time

Job summary

A leading airport in London seeks a Strategic Planning Data Analyst to enhance modeling and analysis capabilities. This role involves creating scalable data pipelines and providing insights across multiple departments. Candidates with a degree in Mathematics or STEM and 2+ years of relevant experience are encouraged to apply. You will collaborate with various stakeholders, improving data-driven decision-making to support the airport's growth goals.

Benefits

Free onsite parking

Discounted Private Medical Insurance

Medicash Cash plan

On site Physiotherapist

Discounted Gym Membership

Staff discounts

Pension schemes

22 Days Annual leave

Qualifications

• 2+ years' experience in a similar role.
• Proficiency in Python, SQL, and Power BI.
• A Level or degree in Mathematics or STEM.

Responsibilities

• Develop and maintain dashboards and reports in Power BI.
• Design, build, and optimise data pipelines using Azure technologies.
• Collaborate with stakeholders for actionable insights.

Skills

Data analysis

Problem Solving

Collaboration

Education

A Level/degree in Mathematics or STEM

Tools

Power BI

Microsoft Fabric

SQL

Python

Job description

2 days ago Be among the first 25 applicants

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 others 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.

Seniority level

• Seniority level

  Entry level

Employment type

• Employment type

  Contract

Job function

• Job function

  Business Development and Sales

• Industries

  Business Consulting and Services

Referrals increase your chances of interviewing at London City Airport by 2x

Get notified about new Strategic Planning Analyst jobs in London, England, United Kingdom.

Business Operations | Analyst/Associate | London

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 9 hours ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 5 days ago

City Of London, England, United Kingdom 1 week ago

Marketplace Operations and Strategy Analyst

London, England, United Kingdom 6 days ago

Business Analyst - Service Strategy and Optimisation

London, England, United Kingdom 3 weeks ago

London, England, United Kingdom 4 days ago

London, England, United Kingdom 2 weeks ago

Lead Strategy & Market Analyst (Fuels) - Relocate To Saudi Arabia

Greater London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 1 week ago

Business Analyst - 12mth Fixed Term Contract

London, England, United Kingdom 1 week ago

Portfolio Lead Business Analyst - Investment & Operations

London, England, United Kingdom 1 week ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 1 week ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.