**Role & seniority: ** Data Test Analyst (contract; ongoing until 30/05/2027). Seniority not explicitly stated.

**Location & work type: ** Telford (hybrid).

**Rate / clearance: ** up to £414/day (Umbrella, inside IR35); Active SC Clearance essential.

**Stack/tools: **

SAS: SAS 9.4, SAS Viya 3.5, SAS Viya 4
Data/testing: SQL (data comparison/profiling), data reconciliation
Automation/scripting: Python, SAS scripting
Test/Agile tooling: Jira, Confluence; CI/CD integration (automation)
Cloud/comms: AWS (DPS AWS); containerized deployments (nice-to-have)
Top 3 responsibilities:
1. Create test plans/cases for data migration, transformation, and validation (define acceptance criteria).
2. Perform data validation & reconciliation between SAS 9.4 and SAS Viya 4; verify ETL/pipelines/report outputs (accuracy/completeness).
3. Automate tests (SQL/Python/SAS) and manage defects; support UAT evidence/sign-off.
Must-have skills:
- Large-scale data testing/validation for migrations
- Strong SQL for comparison/profiling
- Experience with SAS (9.4 and/or Viya 3.x/4)
- Understanding of ETL/data integration
- Test automation capability (Python/SAS scripting) and defect management (Jira)
- Compliance awareness (security/GDPR/data governance); Agile delivery
Nice-to-haves:
- ISTQB Foundation / Advanced Test Analyst
- Governmen

Full Description

Role Title: Data Test Analyst

Duration: contract to run until 30/05/2027

Location: Telford. Hybrid

Rate: up to £414 p/d Umbrella inside IR35

Clearance required: Active SC Clearance is essential

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.

All profiles will be reviewed against the required skills and experience. Due to the high number of applications we will only be able to respond to successful applicants in the first instance. We thank you for your interest and the time taken to apply!