Data Quality Assurance Tester

Northgate Public Services; City Of London; On-site; GBP 40,000 - 60,000; Full time

Job summary

A public sector technology company is seeking a QA Tester for a large-scale data migration project. The role involves ensuring data quality through profiling, defining quality rules, and working closely with data engineers. Candidates should have experience in QA testing, strong SQL skills, and the ability to communicate technical concepts clearly. The position offers an excellent benefits package including medical cover and a generous pension plan.

Benefits

Private medical cover

25 days paid holiday

4x basic salary life assurance

Group pension plan with employer contributions

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.
• Clear communicator for technical issues.
• Understanding of data transformations and migration processes.
• Experience testing BI Dashboards.

Responsibilities

• Conduct data profiling to validate data for migration.
• Define and execute data quality rules.
• Ensure quality dimensions are met.
• Provide feedback to data engineers.
• Write SQL queries to validate datasets.
• Document findings and communicate with stakeholders.
• Promote data quality importance.

Skills

Data profiling

SQL

Attention to detail

Problem-solving

Communication

Data transformations

ETL workflows

Data quality tools

Tools

Great Expectations

Microsoft Purview

YData-Profiling

Job description

Overview

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.

Key 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.