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

Motability Operations Limited; West of England; Hybrid; GBP 60,000 - 85,000; Full time

Benefits offered by this job

Annual discretionary bonus

Pension 15% non-contributory

Hybrid working

Private medical insurance

Job summary

Motability Operations Limited is seeking a data & analytics professional to join the team on a fixed-term contract through September 2027. The role focuses on designing and building data feeds and apps, ETL development in Oracle ODI and Snowflake, and enabling self-serve BI environments for business users across the data lake and warehouse.

You’ll deliver BI reports, support data quality and governance, and collaborate in an Agile setting.

Qualifications

• Experience designing and building data warehouses/lakehouses using ETL/ELT tools, preferably Oracle ODI.
• Strong database development experience with Snowflake, Oracle and/or PostgreSQL.
• Understanding of dimensional modelling and star schema design.
• Excellent SQL development and data manipulation skills.
• Experience with JSON, XML and CSV data formats.
• Proven ability translating business requirements into robust BI/data solutions.
• Experience delivering within an Agile development environment.
• Practical experience developing and supporting cloud-based data solutions.

Responsibilities

• Design and build data feeds and related applications in an agile scrum team.
• Write, test and peer review ETL code in Oracle ODI and Snowflake.
• Collaborate with business users to configure self-serve data environments in Snowflake data lake.
• Analyse, develop, deliver and manage BI reports.
• Assist in data processes design including data quality, reconciliation, testing and governance.
• Release and support software through production environments and UAT sign-offs.
• Assist in prioritisation and estimation.

Skills

Agile working

Stakeholder engagement

Analytical thinking

Problem solving

Organisation

Independent working

Adaptability

Tools

Oracle ODI

Snowflake

PostgreSQL

DBT

AWS

Job description

About The Role

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.

• 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

About You

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.

About The Company

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, 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.