Description
We use innovation to shape data, so it works for everyone. We're planning to re-platform and improve existing (commercial, operational, and customer) data assets, develop new ones, and transform how we collaborate with the business to utilize our data more effectively.
As part of a centralised data function, you will work closely with Data Engineers within 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 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 includes 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 creating and maintaining SQL-based regression packs.
Qualifications
We're a diverse business looking for an experienced Data Warehouse Quality Engineer to support multiple analytics projects. To succeed in this technically focused role, you should have:
* Expertise in testing Oracle, Snowflake, and Postgres databases and data warehouses.
* Hands-on experience delivering fully reconciled Facts and Dimensions and accurate end-user reports.
* Knowledge of Data Warehouse design, including Star schema and dimensional modelling.
* Strong analytical skills and a technical aptitude.
* The ability to challenge and contribute to system architecture and design decisions.
* Good interpersonal skills for working with staff of varying abilities and technical proficiencies.
* Excellent organization skills with the ability to manage multiple test activities simultaneously and handle challenging development and testing tasks.
* Strong experience with agile/scrum methodologies and ceremonies.
* Capability to own all testing disciplines and deliverables within assigned projects.
* A self-starter attitude with initiative and enthusiasm.
Minimum criteria include:
* Experience in ETL / MI data testing.
* Advanced/Expert SQL skills for source/target data reconciliation and business rule validation.
* Proficiency with querying tools such as SQL Developer and PostgreSQL/DBeaver.
* Experience using Snowflake for data lake testing.
* Working knowledge of ETL tools like ODI.
* Proficiency with reporting tools such as Power BI and OAS.
* Understanding of data replication tools like Oracle GoldenGate and AWS DMS.
* Knowledge of AWS services such as SageMaker, Lambda, Step Functions, S3, etc., is advantageous.
* Hands-on understanding of complex Data Warehousing terminology.
* Desirable: Python scripting knowledge.
* Experience implementing CI/CD processes is a plus.
* Experience adding automation to Data Warehouse testing projects.
Benefits
Motability Operations is a unique organisation that combines a strong sense of purpose with a commercial edge to provide worry-free mobility solutions to over 815,000 customers across the UK. We lease a range of vehicles, including cars and wheelchairs, with insurance, maintenance, and breakdown assistance included. We are the UK's largest car fleet operator, working with around 5,000 dealers and major manufacturers, and pride ourselves on outstanding customer service.
Our values—finding solutions, driving change, caring—are central to our culture. We operate a hybrid working model, balancing onsite and remote work to promote work/life balance and collaboration.
Our employee benefits include:
* Competitive reward package with annual bonus
* 15% non-contributory pension (9% during probation)
* 28 days annual leave, with options to buy or sell days
* Free snacks and fruit in the office
* One day paid for volunteering
* Private Medical Insurance
* Car Salary Sacrifice and Cycle to Work schemes
* Life assurance at 4x salary
* Health screening for over 50s
* Additional voluntary benefits including charitable giving, critical illness, dental, and health insurance
* Employee discounts and access to healthcare apps
* Generous family leave policies
We are committed to diversity and inclusion, encouraging applications from all backgrounds, and providing accessible facilities and flexible working options.
#J-18808-Ljbffr