Job Description
Please note, ideally we would seek a candidate who can be hyrbid from Glasgow or London.
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:
1. Carry out in-depth data profiling on source and target systems to validate data before, during, and after migration.
2. Define, document, and execute data quality rules to ensure data meets business and regulatory requirements.
3. Ensure all data quality dimensions (accuracy, completeness, consistency, timeliness, validity, uniqueness) are met.
4. Provide feedback to data engineers to remediate issues quickly.
5. Write and run SQL queries (MySQL) to test and validate large datasets.
6. Write database logic as stored procedures and functions.
7. Document findings and communicate results clearly to stakeholders.
8. Act as a data quality champion, promoting its importance across the project team.
Qualifications
9. Proven experience in QA testing on large-scale data migrations within the public sector.
10. Strong SQL skills.
11. Excellent attention to detail and problem-solving skills.
12. Clear communicator, able to translate technical issues for non-technical audiences.
13. Understanding of data transformations, ETL workflows, and migration processes.
14. Experience with data quality tools such as Great Expectations, Microsoft Purview and YData-Profiling.
15. Experience testing BI Dashboards
Desirable:
16. Familiarity with Oracle or other relational databases.
17. 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:
18. Private Medical Cover funded by NEC for Employees (with the option to add family members at an additional cost)
19. 25 days paid holiday with the option to buy/sell
20. 4 x basic salary life assurance cover funded by NEC (with the option to increase cover at an additional cost)
21. A Group Pension Plan with fantastic employer contributions up to a maximum of
22. A selection of flexible benefits to suit your individual needs
23. 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.