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 flexible working options.
- 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.
Data Quality Assurance/Test Engineer in London 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 flexible working culture that supports work-life balance and a commitment to 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 team that values your contributions and invests in your future.
StudySmarter Expert Advice🤫
We think this is how you could land Data Quality Assurance/Test Engineer in London
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Lloyds Wealth!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Quality Assurance/Test Engineer at Lloyds Wealth.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Lloyds Wealth.
✨Apply Directly through Our Website
When you find a suitable opening like Data Quality Assurance/Test Engineer at Lloyds Wealth, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Quality Assurance/Test Engineer in London
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Lloyds Wealth, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Lloyds Wealth. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Lloyds Wealth
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Lloyds Wealth!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
