Data Quality Assurance Tester

NEC Software Solutions; Glasgow; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A technology solutions provider is seeking a detail-driven QA Tester to join their large-scale data migration project. The ideal candidate will ensure data integrity and quality while utilizing strong SQL skills. This role offers hybrid work options from Glasgow or London, with benefits including private medical cover and a generous pension scheme.

Benefits

Private Medical Cover

25 days paid holiday

Life assurance cover

Group Pension Plan

Flexible benefits

Free access to LinkedIn Learning

Qualifications

• Proven experience in QA testing on large-scale data migrations.
• Strong SQL skills required.
• Excellent attention to detail and problem-solving skills.
• Ability to communicate technical issues to non-technical audiences.
• Understanding of data transformations, ETL workflows, and migration processes.
• Experience with data quality tools such as Great Expectations.

Responsibilities

• Carry out data profiling to validate data migration.
• Define and execute data quality rules.
• Ensure data quality dimensions are met.
• Provide feedback to data engineers.
• Write and run SQL queries for validation.
• Document and communicate findings to stakeholders.

Skills

QA testing on large-scale data migrations

Strong SQL skills

Attention to detail

Problem-solving skills

Clear communication

Understanding of ETL workflows

Experience with data quality tools

Testing BI Dashboards

Tools

Great Expectations

Microsoft Purview

YData-Profiling

MySQL

Oracle

Job description

Overview

Company Description: Come join us and make a difference in the world! Discover more at www.necsws.com

Job Description

Please note, ideally we would seek a candidate who can be hybrid from Glasgow or London, but this role can be remote subject to location.

We are seeking a detail-driven QA Tester to join our team on a large-scale data migration project. You’ll play a critical role in ensuring that migrated data meets the highest quality standards, profiling data, writing and executing quality rules, and championing data integrity across all dimensions of the data quality framework.

Responsibilities

• Carry out in-depth data profiling on source and target systems to validate data before, during, and after migration.
• Define, document, and execute data quality rules to ensure data meets business and regulatory requirements.
• Ensure all data quality dimensions (accuracy, completeness, consistency, timeliness, validity, uniqueness) are met.
• Provide feedback to data engineers to remediate issues quickly.
• Write and run SQL queries (MySQL) to test and validate large datasets.
• Write database logic as stored procedures and functions.
• Document findings and communicate results clearly to stakeholders.
• Act as a data quality champion, promoting its importance across the project team.

Qualifications

• Proven experience in QA testing on large-scale data migrations within the public sector.
• Strong SQL skills.
• Excellent attention to detail and problem-solving skills.
• Clear communicator, able to translate technical issues for non-technical audiences.
• Understanding of data transformations, ETL workflows, and migration processes.
• Experience with data quality tools such as Great Expectations, Microsoft Purview and YData-Profiling.
• Experience testing BI Dashboards

Desirable

• Familiarity with Oracle or other relational databases.
• Experience in case management or enterprise systems.

Additional Information

• We pride ourselves in offering an excellent benefits package, including an above average pension scheme. When you join the team at NEC Software Solutions, you are provided with the following:
• Private Medical Cover funded by NEC for Employees (with the option to add family members at an additional cost)
• 25 days paid holiday with the option to buy/sell
• 4 x basic salary life assurance cover funded by NEC (with the option to increase cover at an additional cost)
• A Group Pension Plan with fantastic employer contributions up to a maximum of 8.5%
• A selection of flexible benefits to suit your individual needs
• All colleagues get free access to LinkedIn Learning. Over 15000 courses covering a huge breadth of subjects. Learn about what you like, when you like, how you like.

Other Information

• Candidates must be able to demonstrate a pre-existing right to work and travel within the UK. Documentary evidence will be required.
• All offers are subject to satisfactory vetting and reference checks. Depending on the nature of the role a Disclosure Barring Service (DBS) check may also be required.

NEC Software Solutions is an equal opportunities employer, welcoming applications from all communities. If you require any reasonable adjustments or have specific accessibility needs during the recruitment or interview process, please feel free to share these with us. We are committed to ensuring an inclusive and accommodating experience for all candidates.

Who We Are

We’re NEC Software Solutions (part of global tech giant NEC Corporation). While you read this ad, our software is helping to dispatch ambulances, support families, keep trains on the move, locate missing people and even test the hearing of newborn babies. Working with us, you’ll be helping our 3,000+ employees push the boundaries of what’s possible and support amazing public services. We work with governments, hospitals, police forces, housing providers, local authorities and more. We help them pay financial support faster, speed up treatments for patients and respond to emergencies in the right way. The more we do, the more our customers can do for others. And together, we make a world of difference. We’d love your help. And we’ll support you all the way.