At a Glance
- Tasks: Join us as a Strategic Planning Data Analyst, transforming data into actionable insights.
- Company: London City Airport is a vibrant workplace with over 2,000 employees and diverse career opportunities.
- Benefits: Enjoy perks like discounted gym memberships, private medical insurance, and flexible working options.
- Why this job: Be part of a dynamic team driving data-driven decisions that shape the future of air travel.
- Qualifications: A Level/degree in Mathematics or STEM and 2+ years' experience in a similar role required.
- Other info: This is a 6-month fixed-term contract with opportunities for growth in an inclusive environment.
The predicted salary is between 28800 - 43200 £ per year.
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.
- 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 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.
Strategic Planning Data Analyst (FTC) employer: London City Airport
Contact Detail:
London City Airport Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Strategic Planning Data Analyst (FTC)
✨Tip Number 1
Familiarise yourself with Microsoft Fabric and Power BI, as these tools are crucial for the role. Consider taking online courses or tutorials to enhance your skills in creating dashboards and reports, which will demonstrate your proactive approach to learning.
✨Tip Number 2
Network with professionals in the data analytics field, especially those who work with Azure technologies. Attend industry meetups or webinars to connect with potential colleagues and gain insights into best practices that can set you apart from other candidates.
✨Tip Number 3
Showcase your problem-solving skills by preparing examples of how you've tackled complex data challenges in the past. Be ready to discuss these experiences during interviews, highlighting your analytical approach and the impact of your solutions.
✨Tip Number 4
Demonstrate your collaboration skills by engaging with stakeholders in your current or previous roles. Prepare to share specific instances where you successfully worked with diverse teams to achieve common goals, as this is a key competency for the position.
We think you need these skills to ace Strategic Planning Data Analyst (FTC)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in data analytics, particularly with tools like SQL, Power BI, and Python. Emphasise any previous roles where you managed complex datasets or collaborated with stakeholders.
Craft a Compelling Cover Letter: In your cover letter, express your passion for business analysis and problem-solving. Mention specific examples of how you've used data to drive decision-making in past roles, and explain why you're excited about the opportunity at London City Airport.
Showcase Your Technical Skills: Clearly outline your technical skills related to data extraction, transformation, and loading (ETL) processes. Include any experience with Microsoft Fabric, Azure technologies, and dashboard creation, as these are crucial for the role.
Highlight Collaboration Experience: Since the role involves working with various stakeholders, include examples of successful collaborations in your application. Describe how you’ve built partnerships and delivered insights that benefited your team or organisation.
How to prepare for a job interview at London City Airport
✨Showcase Your Data Skills
Be prepared to discuss your experience with data analytics tools like Power BI, SQL, and Python. Bring examples of dashboards or reports you've created, and be ready to explain how they supported decision-making.
✨Understand the Role's Requirements
Familiarise yourself with the key responsibilities outlined in the job description. Be ready to discuss how your previous experiences align with tasks such as designing data pipelines and ensuring data quality.
✨Demonstrate Problem-Solving Abilities
Prepare to share specific examples of how you've tackled complex data challenges in the past. Highlight your logical and analytical approach to problem-solving, as this is a key competency for the role.
✨Emphasise Collaboration Skills
Since the role involves working with various stakeholders, be ready to discuss your experience in collaborating with different teams. Share examples of how you’ve built partnerships and communicated effectively to achieve shared objectives.