Data Engineer

We have a fantastic opportunity for you to develop your data career. At Edinburgh Airport, you have the chance to deliver meaningful and tangible change. You will walk around the terminal and campus and see the difference you have helped make.

The Data Engineering team play a pivotal role in the on-going operation of Edinburgh Airport. The team develop and maintain a centralised data warehouse enabling fast and accurate decision-making, reporting and analysis across the entire aerodrome. Data Engineering help coordinate and support the wider analyst community to ensure our datasets drives business efficiency and keep pace with evolving analytical trends. We bring knowledge and experience in the data space.

You can find out more about the team here.

If you are successful in applying for this role, the recruitment process will be two stages. The first interview will be over Teams with our Data Engineering Manager to discuss your background. There will then be a 2nd stage in person interview with our Head of IT and our Head of Business Applications, which will involved competency based and technical questions.

You can find out more about our interview structure and some example questions here.

• Develop new integrations into SQL Data Warehouse
• Bring new data and analytics technologies to life
• Collaborate with end-users and community groups to build feature rich datasets
• Maintain, manage and monitor the data environment
• Engage end-users and run community groups to drive business improvement
• Deliver assigned initiatives as agreed by IT engagement and management teams
• Pro-actively seek out and recommend improvements

To apply for this role, you'll need:

• This role requires the successful candidate to obtain a Counter Terrorist Check, so you must have been living in the UK for the last 3 consecutive years
• Python: 2+ years experience using Python for data manipulation
• Azure Cloud Data Orchestration: Extensive, hands-on knowledge of MS Azure data engineering toolsets, including:
• Azure Data Factory (ADF): Advanced configuration, monitoring, and orchestration.
• Azure Function Apps: For triggering and integrating external services.
• Azure Databricks: For large-scale data processing (PySpark).
• Azure Core Configuration & Management: Proven ability to configure and manage core Azure services necessary for a production data environment, specifically around networking, security, and access control (e.g., configuring VNet integration, Managed Identity, and Key Vault integration).
• SQL: Extensive knowledge of SQL for both Data Definition and Data Modelling. A strong understanding of data modelling, data structures, databases, and ELT/ETL methodologies and practices.
• Good analytical and critical thinking skills

The following knowledge would be nice to have, but is not essential for this role:

• A relevant technical certification
• An understanding of data modelling in Power BI or Tableau

• Exposure to Microsoft Fabric
• MS Powershell

If your experience looks slightly different to what we've listed here, we encourage you to still apply. You could add something we didn't know we needed.

• Pension scheme- employer contributions can be up to 7%
• 32 days holiday, based on full time roles, increasing with service
• Annual discretionary bonus
• Supporting your health and wellbeing- private healthcare after 1 years' service, access to our Employee Assistance Programme and occupational health services
• Free car parking on site and when you go on holiday
• We offer a range of other benefits, find out more here

We are Edinburgh Airport, where Scotland meets the world. The success of the airport comes down to our people, and you can help us deliver even more big days for our passengers and colleagues. The development of your career is important to us, and we'll support and encourage this every step of the way. As a business we're driven by our values - they're at the core of our culture and everything we do. We're looking for people who will demonstrate these values day-in, day-out. So if this sounds like you, apply now and get ready for your career to take off.

Building a diverse workforce that is inclusive and accessible to all is a priority for our business. As part of this journey, we are proud to be the first UK airport to be endorsed by WORK180. They only recognise great employers for all women. Find out about our POLICIES on our WORK180 employer page.

As a Disability Confident Leader, we are committed to ensuring applicants with a disability can participate fully in our recruitment process. Please let us know in your application form if you require any adjustments, such as parking arrangements or alternative methods of communication.