Join to apply for the Data & Analytics Data Quality Engineer role at Motability Operations Ltd
Get AI-powered advice on this job and more exclusive features.
We use innovation to shape data, so it works for everyone. We’re planning to re-platform and improve existing data assets (commercial, operational, and customer), develop new ones, and transform our data usage across the business.
As part of a centralized data team, you will collaborate closely with Data Engineers in a multi-disciplinary environment. Your role involves understanding complex data flows, business, and technical requirements to develop ETL/ELT reconciliation scenarios, ensuring thorough testing.
Primarily focusing on data quality, you will support sourcing, compiling, and developing reliable reporting solutions for strategic decision-making. You will also explore opportunities to enhance SQL/ETL test automation processes.
You will ensure quality engineering principles are integrated from design to deployment, including reviewing acceptance criteria, executing tests, collaborating with stakeholders for sign-off, and maintaining SQL regression packs.
About You
We seek an experienced Data Warehouse Quality Engineer to support multiple analytics projects. You should have:
* Expertise in testing Oracle, Snowflake, and Postgres databases and data warehouses.
* Experience delivering reconciled Facts and Dimensions and accurate reports.
* Knowledge of Data Warehouse design, star schema, and dimensional modeling.
* Strong analytical skills and technical aptitude.
* Ability to challenge system architecture and design decisions.
* Good interpersonal skills for working with diverse teams.
* Excellent organization skills to manage multiple testing activities.
* Experience with agile/scrum methodologies.
* Ownership of testing disciplines and deliverables.
* Self-motivated with initiative and enthusiasm.
* Experience with ETL/MI data testing.
* Advanced SQL skills for data reconciliation and validation.
* Proficiency with querying tools like SQL Developer, PostgreSQL/DBeaver, and Snowflake.
* Experience with ETL tools such as ODI.
* Proficiency with reporting tools like Power BI and OAS.
* Understanding of data replication tools like Oracle GoldenGate and AWS DMS.
* Knowledge of AWS services (SageMaker, Lambda, S3, etc.) is advantageous.
* Hands-on understanding of complex Data Warehousing concepts.
* Desirable: Python scripting and CI/CD experience.
* Experience adding automation to Data Warehouse testing projects.
About The Company
Motability Operations is dedicated to providing mobility solutions to over 815,000 UK customers. We lease vehicles, including cars, wheelchairs, and scooters, with inclusive services. As the UK's largest car fleet operator, we collaborate with major manufacturers and dealers, delivering excellent customer service with a satisfaction rating of 9.8/10.
Our core values are at the heart of everything we do. We operate a hybrid work model, combining on-site and remote work to promote work/life balance.
Benefits include competitive rewards, generous leave, private medical insurance, electric/hybrid car schemes, life assurance, health screenings, voluntary benefits, employee discounts, and access to healthcare apps.
We are committed to diversity and inclusion, providing accessible workplaces and flexible working arrangements to support all employees.
Additional Details
* Seniority level: Mid-Senior level
* Employment type: Full-time
* Job function: Quality Assurance and IT
#J-18808-Ljbffr