Job
Description
Core Responsibilities Provide Data Testing & Validation against an assigned workstream within the OSB Group, through activities including but not limited to: Designing and executing tests to validate the accuracy, completeness, and integrity of data across various systems and databases. Developing tailored test plans, cases, and scripts for data validation. Delivering Data Quality Assurance by implementing processes and methodologies to ensure adherence to data standards and best practices. Conducting data mapping and integration testing to ensure seamless data flow between systems. Validating data transformations, mappings, and business rules with data engineers and developers. Identifying, documenting and managing data-related defects using a defect tracking system. Collaborating with stakeholders and technical teams to resolve data issues. Conducting root cause analysis and recommending solutions for long-term data integrity. Documenting test plans, results, reports. Presenting data test findings, metrics[DEL: . :DEL] Working with cross-functional teams to understand data requirements and validate data accuracy. Communicating test progress, risks, and issues to senior team members Developing engagement skills through project work. Adhering to data governance policies and industry standards to ensure data security and privacy. Maintaining the company’s compliance standards and ensure timely completion of all mandatory on-line training modules and attestations. Ensuring that you fully understand and comply with the organisation’s Risk Management Policies as they relate to your area of responsibility and demonstrate in your day-to-day work that you put customers at the heart of everything you do; Ensuring that you fully understand and comply with the organisation’s Data Governance Policies as they relate to your area of responsibility and demonstrate in your day-to-day work that you treat data as an important corporate asset which must be protected and managed; Experience Requirements Proven experience as a Data Test Analyst/ Data Quality Analyst or in a related role, with a minimum 3 years (or equivalent) experience of data testing concepts and methodologies is essential. Proficiency in designing and executing data tests, profiling, quality assessment, and validation is essential. Strong analytical and reporting skills to identify and analyse data issues is essential. Proficiency in SQL query writing and data manipulation from relational databases is essential. Familiarity with data governance principles and regulatory requirements (e.g., GDPR, CCPA) is desirable. Understanding of data integration, ETL processes, and transformation validation is essential. Experience in managing and tracking data-related defects is desirable. Experience of Mortgage and Savings, products and domain services are desirable. Experience in Datawarehouse concepts is essential. Experience in Microsoft SQL Server Database language is essential. Experience in Test Management tools like JIRA, Zephyr, ADO is desirable. Knowledge Requirements In-depth knowledge of the software development lifecycle and defect resolution process is essential. Comprehensive understanding of testing methodologies and frameworks is essential. Experience in system integration, regression testing, and user acceptance testing is essential. Knowledge of manual and automated testing processes is essential. Experience with Azure Data Fundamentals is desirable. Familiarity with financial services, banking services domains is desirable. Detailed knowledge of Microsoft Word, PowerPoint, Excel is essential. Excellent analytical, mathematical and creative problem-solving skills is essential. Knowledge of savings and mortgage products is desirable. Knowledge on Stored Procedure, Views, Indexes, Triggers is essential. Knowledge on Data pipelines is desirable. Knowledge on Knowledge on ETL tools like SSIS is desirable. experience with Azure or any cloud technology is desirable Skill and Competency Requirements Proficiency with SQL tools, including Microsoft SQL Management Studio is essential. Intermediate skills in testing tools are essential. Attention to detail and ability to learn and adapt quickly is essential. Intermediate level skills in respect of verbal & written communication are essential. Intermediate level skills in respect of the ability to self-manage are essential. Ability to work within diverse, highly technical development teams Required Qualifications/Certifications Degree (or equivalent) qualifications are desirable. Bachelor’s degree in computer science, Data Science, Information Systems, or a related field is desirable. Relevant certifications in software testing (e.g., ISTQB) is desirable. Microsoft Azure Data Fundamental (DP 900) is desirable. Core Responsibilities Provide Data Testing & Validation against an assigned workstream within the OSB Group, through activities including but not limited to: Designing and executing tests to validate the accuracy, completeness, and integrity of data across various systems and databases. Developing tailored test plans, cases, and scripts for data validation. Delivering Data Quality Assurance by implementing processes and methodologies to ensure adherence to data standards and best practices. Conducting data mapping and integration testing to ensure seamless data flow between systems. Validating data transformations, mappings, and business rules with data engineers and developers. Identifying, documenting and managing data-related defects using a defect tracking system. Collaborating with stakeholders and technical teams to resolve data issues. Conducting root cause analysis and recommending solutions for long-term data integrity. Documenting t
