This job is with London City Airport, an inclusive employer and a member of myGwork – the largest global platform for the LGBTQ+ business community. Please do not contact the recruiter directly. 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)