SC Data Test Analyst CGEMJP00358796

Role purpose / summary

To validate data integrity, accuracy, and functionality during the migration of the client's SAS estate (including SAS 9.4 and Viya 3.5 components) to SAS Viya 4 on DPS AWS. The Data Test Analyst ensures that migrated data and processes meet business requirements and comply with the client's standards.

Test Planning & Design:

• Develop detailed test plans and cases for data migration, transformation, and validation.
• Define acceptance criteria for migrated datasets and analytical workflows.

Data Validation:

• Perform data reconciliation between SAS 9.4 and SAS Viya 4 environments.
• Validate ETL processes, data pipelines, and reporting outputs for accuracy and completeness.

Automation & Tools:

• Implement automated data validation scripts using SQL, Python, or SAS.
• Support integration of automated tests into CI/CD pipelines.

Defect Management:

• Log, track, and manage defects related to data inconsistencies or migration issues.
• Collaborate with Data Engineers and developers to resolve issues promptly.

Compliance & Governance:

• Ensure all testing activities adhere to the client's security, GDPR, and data governance standards.

Collaboration:

• Work closely with Business Analysts, Test Manager, and migration teams to align testing with requirements.
• Support UAT and provide evidence for sign-off.

Strong experience in:

• Data testing and validation for large-scale migrations.
• Writing and executing SQL queries for data comparison and profiling.

Knowledge of:

• SAS technologies (SAS 9.4, SAS Viya 3.x/4).
• ETL processes and data integration frameworks.

Familiarity with:

• Test automation tools and scripting (Python, SAS).
• Agile delivery and defect management tools (Jira, Confluence).

Desirable Qualifications:

• ISTQB Foundation or Advanced Test Analyst certification.
• Experience in government or regulated environments.
• Understanding of cloud platforms (AWS) and containerized deployments.