BI Developer

Job description: Summary

• Permanent Role • Based at Manchester Airport• Office or Flexible/Hybrid or Remote working for a better work/life balance• We are proud to be a diverse employer, and we welcome candidates from all backgrounds

Why MAG?

At MAG we provide the airport facilities and travel services that people need to connect with the world. As the largest UK owned airport operator, we serve over 60 million passengers a year from Manchester, London Stansted, and East Midlands Airports. With over 270 destinations across the globe, our businesses not only bring people together but also support the prosperity of the regions in which we operate. Sustainability is one of our core values, and it shapes everything we do. We're committed to protecting the environment and supporting our local communities. Our programmes include airport and airline decarbonisation, comprehensive education, skills and employment support and community engagement initiatives including volunteering opportunities. At MAG, we recognise creating a first-class journey for our customers starts by creating a first-class career journey for our colleagues and we are committed to building inclusive environments in which our people can thrive. You’ll also have access to some great benefits including:• Flexible and generous company pension plan with various company contribution options (up to 10%) that you can change to suit your personal needs• 24 days holiday plus bank holidays• Free parking• Subsidised public transport• Huge range of company discounts• 2 volunteering days per year• Free Virtual GP service, available 24 hours a day, 7 days a week• Care Concierge service

The role

As a BI developer in our MAG Tech team, you’ll have the power of data at your fingertips. One of our key priorities is to digitise our business through better use of data and insights. You’ll be at the forefront of this mission, sourcing data from many disparate systems and transforming into a common data model to support dashboards and reports delivered by our data analysts & insights team, as well as business partners. Whether it’s integrating data on the performance of our security checkpoints; mining our data lake for insights on car parking and retail; or working across our IT and Operations teams to integrate new data sources to find better ways of visualizing real-time data to help manage our operation.

What will make you successful in the role?

You’ll be an experienced BI developer within ETL and data warehousing, with use of Oracle Data Integrator (ODI) in an AWS S3/Redshift cloud environment, or similar ETL tools (Informatica, SSIS) will be considered. You’ll have practical database development and performance tuning experience using SQL (required) and materialised views. You’ll also have demonstrable experience of ingesting and transforming complex disparate datasets within a warehouse solution; usage of web APIs desirable, as is Python experience. You’ll also have an understanding of dimensional data modelling (Kimball) and key principles. You’ll have experience creating Power BI reports / dashboards / apps in a collaborative environment with internal and external users as well as a demonstrable track record making improvements to existing solutions and identifying better ways of working.