Data & Analytics Data Quality Engineer

Motability Operations Limited; Bristol; Hybrid; GBP 80,000 - 100,000; Full time

Job summary

A mobility solutions organization in Bristol is seeking an experienced Datawarehouse Quality Engineer to enhance data reporting processes. Ideal candidates will have expertise in Snowflake and Oracle, as well as advanced SQL skills, and will be responsible for user report accuracy and data reconciliation. The role supports a customer-focused product team and offers hybrid working options. Competitive benefits include a discretionary bonus, generous leave, and private medical insurance.

Benefits

Competitive reward package

Annual discretionary bonus

15% non-contributory pension

28 days annual leave

Funded private medical insurance

Cycle to work scheme

Life assurance

Qualifications

• Experience in ETL/MI data testing at advanced to expert level.
• Proficient in using Snowflake for data lake testing.
• Experience with automation in Datawarehouse testing.

Responsibilities

• Develop ETL/ELT reconciliation scenarios.
• Support the team in data reporting solutions.
• Create and maintain SQL based regression packs.

Skills

Expert in testing Snowflake and Oracle databases

Hands-on experience delivering reconciled data tables

Strong technical understanding of Data Warehousing concepts

Excellent analytical skills

Ability to challenge system architecture decisions

Good interpersonal skills

Highly organised and ability to manage multiple activities

Strong experience in agile techniques

Self-starter with initiative

Education

Advanced SQL skills

Experience with ETL tools like ODI

Familiarity with AWS services

Tools

SQL Developer

PostgreSQL/DBeaver

Power BI and OAS

Job description

About The Role

We use innovation to shape data, so it works for everyone and as part of this we collate, enhance and improve data assets and develop new ones, as well as transform how we work with the business to use our data better.

As part of a product team focusing on customer data, you will be working closely with Data Engineers in a multi‑disciplinary team. You will need to understand complex data flows and both business and technical requirements to develop ETL/ELT reconciliation scenarios and ensure all features are fully tested.

Primarily focusing on data quality, you will support the team in sourcing, compiling, and developing reliable and consistent data reporting solutions that enable strategic, insight‑driven decision‑making. Additionally, you will explore opportunities to streamline or further enhance the team’s existing SQL/ETL test automation processes where applicable.

You will ensure that quality engineering principles are highlighted, discussed, and implemented from early design stages through to final production release. This will include reviewing acceptance criteria to determine relevant test scenarios; executing tests and collaborating with business users to ensure sign‑off. You will also be responsible for the creation and maintenance of SQL based regression packs.

About You

We’re a diverse business looking for an experienced Datawarehouse Quality Engineer to work within a customer focused product team. To operate within this technically focused team you will have the following:

• An expert in testing Snowflake and Oracle databases and data warehouses/Lakehouse’s.
• Hands on experience of delivering fully reconciled data tables, Facts and Dimensions and accurate end user reports.
• Strong technical understanding of Data Warehousing concepts and terminology, including star schema and dimensional modelling.
• Excellent analytical skills and a technical aptitude.
• Ability to challenge and provide input in system architecture and design decisions.
• Good interpersonal skills in dealing with staff of varying abilities and technical proficiencies.
• You will be a highly organised individual with the ability to manage multiple test activities simultaneously and an aptitude to pick up challenging development and test items.
• Strong experience of agile/scrum techniques and ceremonies.
• Capable of owning all testing related disciplines and deliverables within allocated projects.
• Self‑starter with initiative and enthusiasm.

Minimum criteria

• Experience of ETL / MI data testingAdvanced to Expert level SQL skills to reconcile source/target data and to validate business rules / requirements.
• Proficient in using Snowflake for data lake testing.
• Skilled in using tools such as SQL Developer and PostgreSQL/DBeaver.
• Experience of working with and using ETL tools such as ODI.
• Proficient with reporting tools such as Power BI and OAS.
• Familiarity with AWS services such as SageMaker, Lambda, Step Functions, S3 is highly desirable.
• Python scripting knowledge would be desirable.
• Experience of implementing CI/CD process would be an advantage.
• Experience of adding automation to Datawarehouse testing projects.

Who you’ll be working with

The Data & Analytics Team within MO provides tools and methods for the wider business to garner insights and analysis from our Data Warehouse and Data Lake, playing a key role in providing support to the business in their Data Science, AI, and ML initiatives.

The team consists of both product and project‑based groups, working on various MI reporting requirements across multiple strategic business units.

Our Data & Analytics technology stack consists primarily of: Oracle tools, Snowflake, Postgres and various AWS Services in the AWS Cloud.

We pride ourselves on the quality of our development, our user satisfaction and our team spirit.

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

We allow flexibility to work remotely up to two 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% during probation period); 28 days annual leave with option to purchase and sell days; free fresh fruit and snacks in the office; one day for volunteering; funded private medical insurance cover; electric/hybrid car salary sacrifice scheme and cycle to work scheme; life assurance at four times your basic salary; funded health screening for over 50s; voluntary benefits; employee discount scheme; free access to healthcare apps; 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 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.