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.

Key Responsibilities

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

Required Skills & Experience

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