Data & Analytics Data Engineer (Fixed Term Contract till September 2027)

Fixed Term Contract till September 2027

The Data & Analytics team enables the integration, transformation and visualisation of data across Motability Operations, providing trusted data and tools that support reporting, analytics and informed decision-making. The team also enables wider Data Science, AI and Machine Learning initiatives through our Data Warehouse and Data Lake platforms.

The successful candidate would be:

Working in an agile scrum team to design and build data feeds and related applications

Writing, testing and peer review of ETL code in Oracle ODI and Snowflake

Working with business users to design and configure self-serve data environments within our snowflake data lake

Analysing, developing, delivering, and managing BI reports

Assisting in the design of the data processes, including data quality, reconciliation, testing, and governance

Releasing and supporting software through environments including production support and working with stakeholders to sign-off business requirements in UAT

Assisting in prioritisation and estimation

In addition to a candidate who is technically very strong, we are also seeking:

Communication

Strong ability to engage professionally and effectively with business stakeholders.

Customer-focused mindset with a strong commitment to collaboration and building effective working relationships.

High Performer

Strong analytical, problem-solving and decision-making skills.

Highly organised, detail-focused and able to manage priorities and deadlines.

Collaborative and self-motivated, with the ability to work independently when required.

Adaptable, with a strong appetite for technical challenges and continuous learning.

Minimum criteria

Experience designing and building data warehouses/ lakehouses using ETL/ELT tools, preferably Oracle ODI

Strong database development experience with Snowflake, Oracle and/or PostgreSQL

Strong understanding of dimensional modelling and star schema design

Excellent SQL development and data manipulation skills

Experience working with common data formats, including JSON, XML and CSV

Proven experience translating business requirements into robust BI and data solutions

Experience delivering within an Agile development environment

Practical experience developing and supporting cloud-based data solutions

Desirable

Experience in AWS (terraform, DMS, lambda, step functions, S3)

Experience with DBT, including building, testing and maintaining data transformation models

Proficient in AI prompting to support data engineering, testing and optimisation

Understanding of machine learning or data science, including python

Proven experience of Oracle OAS or Power BI

Experience working with customer or vehicle data

Who you’ll be working with You’ll join the Data team within the Customer product area, working alongside Data Engineers, Quality Engineers and business colleagues to improve customer and partner experiences utilising our data and reporting solutions. Working in an Agile, product-led environment, your work will include ETL into the data warehouse or data lake, transferring data from third parties, providing insights and metrics, and improving data performance and processes.

Motability Operations is a unique organisation, virtually one of a kind. We combine a strong sense of purpose with a real commercial edge to ensure we provide the best possible worry-free mobility solutions to over 815,000 customers and their families across the UK. Customers exchange their higher rate mobility allowance to lease a range of affordable vehicles (cars, wheelchair accessible vehicles, scooters, and powered wheelchairs) with insurance, maintenance and breakdown assistance included. We are the largest car fleet operator in the UK (purchasing around 10% of all the new cars sold in the UK) and work with a network of around 5,000 car dealers and all the major manufacturers. We pride ourselves on delivering outstanding customer service, achieving an independently verified customer satisfaction rating of 9.8 out of 10.

Our values are at the heart of everything we do. They represent ambition, and we look for our people to live and breathe them every day:

We find solutions

We drive change

We care

We operate hybrid working across the organisation where we split our time between working on-site at our offices, and at home, remotely within the UK. We believe hybrid working achieves a good work/life balance for our colleagues, allowing us to connect with each other, collaborate on important work, and perform together to deliver for our customers. It allows us to have the flexibility to work remotely up to 2-days per week whilst also using the great office spaces we have available.

As a Motability Operations team member, the benefits you can expect are:

Competitive reward package including an annual discretionary bonus

15% non-contributory pension (9% non-contributory pension during probation period)

28 days annual leave with option to purchase and sell days

Free fresh fruit and snacks in the office

1 day for volunteering

Funded Private Medical Insurance cover

Electric/Hybrid Car Salary Sacrifice Scheme and Cycle to Work Scheme

Life assurance at 4 times your basic salary to give you a peace of mind that your loved ones will receive some financial help

Funded health screening for over 50s

Voluntary benefits: charitable giving, critical illness insurance, dental insurance, health and cancer screenings for you and your partner, discounted gym memberships and season ticket loans

Employee Discount Scheme with an app to save on the go

Free access to healthcare apps such as Peppy, Unmind, Aviva Digital GP and volunteering app on Hand for all employees

Generous family leave policies

At Motability Operations, we believe in building a diverse workforce, where our people are empowered to attend work as their true selves, and we encourage people from all backgrounds to apply. We want to sustain a culture that nurtures, where employees are free to flourish and where they’re rewarded equally, regardless of race, nationality or ethnic origin, sexual orientation, age, disability, or gender.

We pride ourselves on being an inclusive employer and as such, all our offices provide first rate disability access. With our hybrid working environment, we do our best to accommodate part-time and flexible working requests where possible, building on our culture of trust, empowerment, and flexibility.