Senior QA Engineer

WPP is the trusted growth partner for the world's leading brands.

We unite cutting-edge media intelligence and data solutions, world-class creativity, next-generation production, transformative enterprise solutions and expert strategic counsel in a single company – powered by exceptional talent and our agentic marketing platform, WPP Open, to help our clients navigate change, capture opportunity and deliver transformational growth.

We have been building the world's most valuable brands for 50 years and have global reach across 100+ markets, with deep local expertise.

Our people are the key to our success. We're committed to fostering a culture of creativity, belonging and continuous learning, attracting and developing the brightest talent, and providing exciting career opportunities that help our people grow.

For more information, visit WPP.com.

Why we're hiring:

At WPP, technology is at the heart of everything we do, and it is WPP IT's mission to enable everyone to collaborate, create and thrive. WPP IT is undergoing a significant transformation to modernise ways of working, shift to cloud and micro-service-based architectures, drive automation, digitise colleague and client experiences and deliver insight from WPP's petabytes of data.

WPP Media is the world's leading media investment company responsible for more than $63B in annual media investment through agencies Mindshare, MediaCom, Wavemaker, Essence and m/SIX, as well as the outcomes-driven programmatic audience company, Xaxis and data and technology company Choreograph. WPP Media's portfolio includes Data & Technology, Investment and Services, all united in a vision to shape the next era of media where advertising works better for people. By leveraging all the benefits of scale, the company innovates, differentiates and generates sustained value for our clients wherever they do business.

The WPP Media IT team in WPP IT are the technology solutions partner for the WPP Media group of agencies and are accountable for co-ordinating and assuring end-to-end change delivery, managing the WPP Media IT technology life cycle and innovation pipeline.

This role will work as part of the Shared Services Team. It will be responsible for the implementation, support, and maintenance of various local applications. It will be responsible for releasing high-quality solutions to stakeholders. It will also play a crucial role, by working with the business, in gathering requirements and translating complex technical requirements into effective and succinct requirements.

What you'll be doing:

Responsible for planning, deployment and managing the quality assurance and testing for the shared services team

Develop and establish quality assurance deliverables and testing framework, including creating and maintaining test plans and test cases in accordance with changing requirements, throughout the development of the Application Software and data services.

Create and manage the automated test framework (where applicable) such as preparing the test environment and maintaining functional testing scripts in accordance with the changing

Checking data source locations and formats, performing a data count and verifying that the columns and data types meet requirements, reviewing keys and removing duplicate data.

Identifying key ETL mapping scenarios and creating SQL queries that simulate them. Each ETL test case should be able to replicate one or more ETL mappings and compare them against real output.

Confirming that all data was loaded, and that invalid data was rejected and loaded to the appropriate location (rejects table, etc).

Perform thorough testing of datasets, reports, and dashboards developed in Power BI to ensure data accuracy and completeness.

Validate data transformation processes and ETL pipelines that feed into Power BI.

Work with the deployment team on setting up continuous integration, build and release automation

Work with the development team (i.e. the business analysts and testers) for user stories elaboration, test automation, bug fixes, etc.

Ensure defects are tracked in the product backlog, and conduct impact analysis of defect fixes discovered during manual or automated tests, validate completed stories pass the acceptance criteria, raising defects as needed and work with the development team to improve the expected behaviour and test cases.

Ensure that only the tested stories are demonstrated during the Sprint review(s).

What you'll need:

4-5 years in the capacity of a QA Lead

Solid Backend experience by writing PL/SQL Queries

Experience in Data Modelling

Understanding of Data warehouse, Data Migration, ETL concepts

Aware of the concepts related to Data warehousing, OLTP and OLAP

Experience in Power Bi Dashboards and reports testing

Excellence analytical skills.

Experience automated testing tools is a plus.

In depth understanding of development methodologies (Agile, Waterfall, etc.).

Working with 1 or more agile development teams.

Familiar with Agile tools (e.g. JIRA/Azure Devops).

Continuous QA process improvement.

Who you are:

You're open: We are inclusive and collaborative; we encourage the free exchange of ideas; we respect and celebrate diverse views. We are open-minded: to new ideas, new partnerships, new ways of working.

You're optimistic: We believe in the power of creativity, technology and talent to create brighter futures or our people, our clients and our communities. We approach all that we do with conviction: to try the new and to seek the unexpected.

You're extraordinary: we are stronger together: through collaboration we achieve the amazing. We are creative leaders and pioneers of our industry; we provide extraordinary every day.

What we'll give you:

Passionate, inspired people – We aim to create a culture in which people can do extraordinary work.

Scale and opportunity – We offer the opportunity to create, influence and complete projects at a scale that is unparalleled in the industry.

Challenging and stimulating work – Unique work and the opportunity to join a group of creative problem solvers. Are you up for the challenge?

#LI-Hybrid

We believe the best work happens when we're together, fostering creativity, collaboration, and connection. That's why we've adopted a hybrid approach, with teams in the office around four days a week. If you require accommodations or flexibility, please discuss this with the hiring team during the interview process.

Please read our Privacy Notice (https://www.wpp.com/en/careers/wpp-privacy-policy-for-recruitment) for more information on how we process the information you provide.