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

Motability Operations Ltd; Greater London; Hybrid; GBP 70,000 - 100,000; Full time

Benefits offered by this job

Annual discretionary bonus

28 days annual leave

Private Medical Insurance

Electric/Hybrid Car Salary Sacrifice

Life assurance at 4x salary

Hybrid working

Job summary

Motability Operations Ltd’s Data & Analytics team is expanding, delivering data feeds, storage and BI insights. You will design and build ETL pipelines in Snowflake, work with Oracle ODI, and create self-serve data environments for business users.

The role emphasizes collaboration, accuracy and continuous learning within an Agile, product-focused setting, and includes hybrid working across offices and home in the UK.

Qualifications

• Experience designing data warehouses and lakehouses.
• Strong SQL development and data manipulation skills.
• Experience with Agile development environment.
• Proficiency in Python and data science basics.
• Experience with AWS services such as Terraform, DMS, Lambda.
• Experience with Oracle OAS or Power BI.

Responsibilities

• Design and build ETL data feeds in Snowflake.
• Develop, test and peer review ETL/ELT code in ODI and Snowflake.
• Deliver and manage BI reports for business users.
• Support data governance, quality, reconciliation and testing.
• Assist production support and UAT sign-offs; prioritise and estimate tasks.

Skills

SQL development

Snowflake

Oracle ODI

Power BI

DBT

Python

ETL/ELT tools

AWS

Data modelling

Agile

Communication

Problem solving

Tools

Oracle ODI

Power BI

DBT

AWS

Job description

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

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.
• 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
• 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, And We Look For Our People To Live And Breathe Them Every Day

• We find solutions

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