Job Details
Data and Analytics Data Quality Engineer
Motability Operations
Expires in 9 days
Overview
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 eight hundred thousand customers and their families across the United Kingdom. We pride ourselves on delivering outstanding customer service, achieving an independently verified customer satisfaction rating of nine point eight out of ten.
Full time, Hybrid
(35 hours per week. Hybrid working with minimum three days per week in the office.)
Bristol or Edinburgh office
Key information
The Data & Analytics Team within Motability Operations 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, Artificial Intelligence (AI), and Machine Learning (ML) initiatives. Our Data and Analytics technology stack consists primarily of: Oracle tools, Snowflake, Postgres and various Amazon Web Services in the Amazon Web Services (AWS) Cloud.
The team consists of both product and project based groups, working on various reporting requirements across multiple strategic business units. We pride ourselves on the quality of our development, our user satisfaction and our team spirit.
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 multidisciplinary team. You will need to understand complex data flows and both business and technical requirements to develop Extract, Transform, Load (ETL) and or Extract, Load, Transform (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 and or Extract, Transform, Load (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.
For the full job description, including the keys areas of responsibilities and accountabilities, please click the 'apply now' button.
We pride ourselves on being an inclusive employer and as such, all our offices provide first rate disability access. We operate hybrid working across the organisation where we split our time between working onsite at our offices, and at home, remotely within the United Kingdom.
Requirements
- Experience of Extract, Transform, Load (ETL) or MI data testing Advanced to Expert level SQL skills to reconcile source and target data and to validate business rules and requirements.
- Proficient in using Snowflake for data lake testing.
- Skilled in using tools such as SQL Developer and PostgreSQL and DBeaver.
- Experience of working with and using tools such as ODI.
- Proficient with reporting tools such as: Power BI and OAS.
- Familiarity with Amazon Web Services such as: SageMaker, Lambda, Step Functions, S3 is highly desirable.
- Python scripting knowledge would be desirable.
- Experience of implementing Continuous Integration (CI) and Continuous Delivery (CD) process would be an advantage.
- Experience of adding automation to Datawarehouse testing projects.
For the full person specification, please click the 'apply now' button.
Disclaimer: We will be interviewing for this role as suitable applications are received and may close this role before the closing date upon a successful candidate being appointed.