At a Glance
- Tasks: Ensure data accuracy and integrity while collaborating on exciting data migration projects.
- Company: Join Lloyds Wealth, a leader in making financial advice accessible and impactful.
- Benefits: Enjoy 30 days holiday, private medical insurance, and a flexible working environment.
- Other info: Diverse and inclusive workplace with excellent career growth opportunities.
- Why this job: Make a real difference in data quality and enhance customer experiences.
- Qualifications: Experience in data testing and strong SQL skills are essential.
The predicted salary is between 51907 - 57100 £ per year.
Lloyds Wealth aims to improve the way financial advice is offered by making it more affordable, accessible and impactful for more people. As a Data Quality Assurance Analyst, you’ll play a key role in ensuring the accuracy, reliability and integrity of the data that underpins our business. Working at the heart of the Data Migration project, you’ll help shape how information flows across our organisation - supporting better decision‐making, smoother processes and a stronger data foundation for the future.
You’ll work closely with colleagues across data, business analysis, engineering and project delivery, validating datasets, improving data standards and ensuring that what we deliver is accurate, complete and trusted. Whether you’re testing migrated data, analysing patterns, resolving issues or supporting downstream reporting, your work will directly enhance our data quality and overall employee and customer experience.
Key Responsibilities- Data Testing & Validation
- Conduct detailed validation of client, advice and product datasets, including structured records and unstructured content (e.g., documents, notes, attachments).
- Execute test cases for each stage of the migration lifecycle: extraction, staging, transformation, loading and post‐load validation.
- Perform reconciliation between source data and target data, ensuring completeness, accuracy and referential integrity.
- Validate iterative mock migration cycles and identify patterns, data gaps, mapping discrepancies and transformation issues.
- Support the triage, documentation and resolution of data defects in collaboration with data migration and engineering teams.
- Maintain detailed test evidence, defect logs, and validation reports.
- Downstream System Testing
- Validate data ingestion into downstream platforms including the data lakehouse, data warehouse and reporting systems.
- Ensure schema adherence, metadata accuracy, lineage integrity and transformation rule correctness in downstream datasets.
- Test dashboards, MI reports and regulatory outputs to ensure that reported values reflect migrated data accurately.
- Support regression testing where changes are made to pipelines, mappings or transformation rules.
- Data Quality Assurance
- Perform exploratory data profiling to identify abnormalities, missing values, duplicate records and data format issues.
- Support the execution of data cleansing, enrichment and transformation checks.
- Validate business rules, logic and mappings defined by the Data Migration Analysts and business SMEs.
- Monitor data quality throughout migration cycles and contribute to improving data standards and quality controls.
- Migration & Cutover Support
- Assist in validating data quality during cutover rehearsals, data freeze periods and post‐go‐live verification.
- Contribute to defining and applying entry and exit criteria for migration testing cycles.
- Support hypercare activities by validating live data defects, reconciling issues and confirming fixes.
- Relevant experience in data testing, QA, data validation or similar roles.
- Strong SQL skills and experience analysing data across databases, data lakes or data warehouses.
- Experience validating both structured and unstructured datasets.
- Understanding of data migration, ETL/ELT processes, data mapping and data lineage.
- Experience working with 3rd party vendors is advantageous.
- Experience working in financial services or financial advice environments is desirable.
- Knowledge of data quality principles, GDPR, and data governance practices.
- Strong analytical skills with excellent attention to detail.
- Experience with test and documentation management tools such as Jira, Xray and Confluence.
- Excellent communication skills and an ability to translate technical findings for business audiences.
We understand not everyone will meet 100% of the requirements, however we encourage you to apply if you think your skills are a good fit for this role. This job vacancy may close earlier than the advertised date if a suitable candidate is found. We encourage interested applicants to submit their applications as soon as possible.
Some fantastic benefits our colleagues enjoy:- Generous Holiday Entitlement: 30 days of annual leave plus bank holidays, with the option to buy or sell 5 days.
- Health & Wellbeing: Company-paid Private Medical Insurance, Life Insurance, and Health Screening.
- Company Pension Contribution: A matched pension contribution of up to 15% of your base pay.
- Cash Allowance: Flexible allowance to spend on additional benefits personal to you, including: dental cover, paid sabbatical leave, gym membership, menopause support.
- Bonus Opportunity: Dependent on individual/company performance (eligible after 3 months’ service).
- Financial Advice: Access to free financial advice to help secure your financial future.
We support flexible working: We know how important it is to be able to achieve a balance. We want to support your lifestyle as well as meeting our business needs, so will always aim to be flexible. As well as traditional working patterns, we have colleagues who work informal flexible hours, reduced working hours, and have job-sharing arrangements. Many colleagues work from home, or in a hybrid way.
Ready to restart your career? We warmly welcome applications from those returning to work after a period of leave, providing appropriate support and training where required.
You belong here: We embrace individuality and diversity of identity, experience, and thought. We actively strive for inclusive behaviours and actions, making appropriate adjustments for disabilities, health conditions and neurodiversities. We ensure equal opportunities for all and transparently report on gender pay to promote fairness.
We operate under the Senior Managers and Certification Regime as a solo-regulated firm and if this role is classed as a Certified Role under that regime you will be subject to enhanced vetting and will have a number of additional conduct and regulatory duties to adhere to, as well as certifying at least annually that you are fit and proper to perform this role.
Data Quality Assurance/Test Engineer employer: Lloyds Wealth
Lloyds Wealth is an exceptional employer that prioritises employee well-being and professional growth, offering a generous holiday entitlement, comprehensive health benefits, and a matched pension contribution of up to 15%. With a strong commitment to flexible working arrangements and a culture that embraces diversity and inclusion, employees are empowered to thrive in their roles while contributing to meaningful projects that enhance financial advice accessibility. Join us in Leeds or London to be part of a forward-thinking team dedicated to making a positive impact in the financial services sector.
StudySmarter Expert Advice🤫
We think this is how you could land Data Quality Assurance/Test Engineer
✨Tap into Online Data Science Communities
Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like Lloyds Wealth before they're even advertised!
✨Show Off Your Skills With Projects
Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.
✨Check Out Specialist Job Boards
For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like Lloyds Wealth.
✨Leverage University Resources
If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like Lloyds Wealth.
We think you need these skills to ace Data Quality Assurance/Test Engineer
Some tips for your application 🫡
Highlight Your Data Projects:When applying for a temporary data science role at Lloyds Wealth, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.
Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!
Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to Lloyds Wealth, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.
Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab Lloyds Wealth’s attention and show the tangible impact of your work.
How to prepare for a job interview at Lloyds Wealth
✨Showcase Your Analytical Skills
For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at Lloyds Wealth.
✨Brush Up on Technical Skills
You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.
✨Highlight Your Adaptability
Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at Lloyds Wealth.
✨Prepare a Portfolio of Your Work
Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at Lloyds Wealth.
