Data & Analytics Data Quality Engineer

Lagofire

Edinburgh

1 month ago

Applications closed

Related Jobs

View all jobs

Lead Data Engineer

Data Analytics Engineer

Head of Data Engineering

Mid level - Senior Data analytics Engineer - Perm - Hybrid

Principal Data Analytics Engineer

Data Analytics Engineer I

1 month ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

Description

We use innovation to shape data, so it works for everyone and we're planning to re-platform and improve the existing (commercial, operational and customer) 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 centralised data function, you will work 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 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.

Qualifications

We're a diverse business looking for an experienced Datawarehouse Quality Engineer to work across and support multiple analytics projects. To operate within these technically focused teams you will have the following: -

An expert in testing Oracle, Snowflake and Postgres databases and data warehouses.
Hands on experience of delivering fully reconciled Facts and Dimensions and accurate end user reports.
Knowledge of Data Warehouse design; Star schema and dimensional modelling
Strong 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 testing
Advanced / Expert level SQL skills to reconcile source/target data and to validate business rules / requirements.
Skilled in using querying tools such as SQL Developer and PostgreSQL/DBeaver
Proficient in using Snowflake for data lake testing
Experience of working with and using ETL tools such as ODI
Proficient with reporting tools such as Power BI and OAS
Understanding of data replication tools such as Oracle GoldenGate and AWS DMS
Knowledge of AWS Services such as SageMaker, Lambda, Step Functions, S3 etc would be an advantage
Hands on and technical understanding of complex Data Warehousing terminology.
Python scripting knowledge would be desirable.
Experience of implementing CI/CD process would be an advantage.
Experience of adding automation to Datawarehouse testing projects.

Benefits

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. 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
15% non-contributory pension (9% non-contributory pension during probation period)
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.Seniority level

Seniority levelMid-Senior level

Employment type

Employment typePart-time

Job function

Job functionQuality Assurance
IndustriesData Infrastructure and Analytics

Referrals increase your chances of interviewing at LAGOFIRE SRL by 2x