Data Test Analyst IND

1. 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.
• 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;

2. 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.

3. 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

4. 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

5. 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.