Data Tester Swindon, Wiltshire, South West England, England
Job description
The opportunity
Hybrid role based in Swindon - 2 days a week required in the office.
As an integral part of the multi-function Data Engineering Team, you will design and use Testing techniques for the development of Openwork data structures that support Warehouse and Reporting output.
The benefits
- Salary - £37,000 - £47,000
- Bonus scheme - on target bonus - 7.5%
- Pension scheme - contribute up to 5% of your salary and Openwork will match you and put in an extra 5%
- Critical illness cover
- Income protection - 1x salary
- Death in service - 4x salary
- 25 days holiday + bank holidays, with the opportunity to buy up to an additional 10 days.
- A range of other flexible benefits to include private medical insurance, dental insurance and much more.
Your responsibilities as Data Test Analyst
- Architect, manage, and maintain the testing principles that will govern and assure end to end quality for all data warehouse and reporting deliverables.
- Design the test approaches and test strategies necessary to deliver continuous data warehouse and reporting iterations.
- Develop specific test cases for data management / ETL / Report layer data consumption.
- Execute test cases for data management / ETL / Report layer data consumption.
- Identify, develop, and manage the regression test scripts.
- Operate iterative test cycles.
- Participate in defect triage meetings.
- Define the environments and test data required for the different test phases for data deliverables.
- Performance test ETL packages.
- Validate data against the transformation and business rules in technical specifications, from source system to end report.
- Work with the business Data Analysts challenging and seeking clarifications on the data mappings/ rules.
- Work with the Business Analysts who will feed into the data transformation/ business rules.
- Ensure quality is embedded and proven through testing at every stage of the delivery lifecycle.
- Provide test-driven design input for all technical deliverables.
- Participate in ensuring best practise is adhered to in the handling and management of data by the team.
- Support other test team(s) within the organisation, e.g. SIT, UAT.
What will you need to succeed?
- Experience working as a Data Tester for Data warehouse environments.
- Experience in Agile working.
- Financial Services industry experience (desirable).
- Professional Testing Accreditation (desirable).
- Strong Microsoft data expertise, SQL Server, Azure SQL, ADF, Synapse.
- Strong SQL / database querying skills.
- Understanding of data methodologies e.g Kimball.
- Understanding of defect management process.
- Understanding of risk-based testing.
- Openwork sales and recruitment structures (desirable).
- Knowledge of the product hierarchy (desirable).
Why us?
We're a dynamic, fast paced, and growing business with huge ambition. This is all made possible by the brilliant people who are part of The Openwork Partnership family. We're investing heavily in our colleagues, continuously striving to give them the platform to develop personally and professionally and reach their full potential.
We’re also very proud of our culture, as one of the Best 100 Large Companies to work for in 2022. The Openwork Partnership values, and respects individuality and we are committed to building an inclusive culture and environment which truly recognises and celebrates our colleague’s individual differences and identities – just like our financial advice, for us, it’s personal. We believe everyone can make a difference and your race, religion, disability, and gender will never be a barrier. At Openwork, we have a strong ethic of care for each other where you can balance a successful career with your commitments and interests outside of work. We believe that you will bring your best self to work if you are trusted to choose when, where and how you do it.
