Data Test Analyst

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