Data Test Analyst - SC Cleared

CBSbutler Holdings Limited trading as CBSbutler; Telford; Hybrid; GBP 62,000 - 70,000; Full time

Job summary

CBSbutler is seeking a Data Test Analyst with active SC clearance to support a major HMRC data migration project in Telford. The role involves validating data integrity, accuracy, and functionality as SAS estate moves from SAS 9.4 to Viya 4 on DPS AWS, working with data, testing and migration teams.

You will develop test plans, perform data reconciliation, and create automated validation scripts, ensuring governance and security compliance throughout the project lifecycle.

Qualifications

• Experience in data testing and validation within large-scale migration programmes.
• Strong SQL skills including data comparison, reconciliation and profiling.
• Experience testing ETL processes and data integration.
• Experience with SAS 9.4 and/or SAS Viya.

Responsibilities

• Test planning, design, scenarios and test cases for data migration and validation.
• Data reconciliation between SAS environments and validation of ETL processes and reporting outputs.
• Develop automated data validation scripts using SQL, Python and/or SAS; support CI/CD integration.
• Log, investigate and manage defects, coordinating with Data Engineers and migration teams.
• Ensure governance: HMRC security, GDPR and data governance requirements; support UAT and sign-off evidence.

Skills

Data testing

SQL proficiency

ETL testing

SAS 9.4/Viya

Agile

CI/CD automation

Defect management

Jira/Confluence

Tools

Jira

Confluence

Job description

Data Test Analyst - SC Cleared

Location: Telford - Hybrid (2 days per week onsite)

Contract: 6 months

Rate: £45-£51 per hour, Inside IR35

Clearance: Active SC Clearance

Engagement: PAYE via Umbrella

The Opportunity

We are looking for a Data Test Analyst to support a major data migration programme within HMRC.

You will play a key role in validating data integrity, accuracy and functionality as HMRC's SAS estate, including SAS 9.4 and Viya 3.5, is migrated to SAS Viya 4 on DPS AWS.

This is an excellent opportunity to join a high-profile government transformation programme and work alongside experienced data, testing and migration teams.

Key Responsibilities

• Test Planning & Design
  • Develop detailed test plans, scenarios and test cases for data migration, transformation and validation.
  • Define acceptance criteria for migrated datasets and analytical workflows.
  • Ensure test coverage aligns with business and technical requirements.
• Data Validation & Reconciliation
  • Perform data reconciliation between SAS 9.4 and SAS Viya 4 environments.
  • Validate ETL processes, data pipelines and reporting outputs.
  • Identify data discrepancies and ensure migrated data is accurate, complete and fit for purpose.
• Test Automation & Scripting
  • Develop automated data validation scripts using SQL, Python and/or SAS.
  • Support the integration of automated testing into CI/CD pipelines.
  • Identify opportunities to improve testing efficiency and coverage through automation.
• Defect Management
  • Log, investigate, track and manage defects relating to data migration and inconsistencies.
  • Work closely with Data Engineers, Developers and migration teams to resolve issues.
  • Provide clear test evidence and status reporting.
• Governance & Collaboration
  • Ensure testing activities comply with HMRC security, GDPR and data governance requirements.
  • Work closely with Business Analysts, Test Managers and migration teams.
  • Support UAT and provide evidence required for formal sign-off.

Essential Skills & Experience

• Strong experience in data testing and validation, particularly within large-scale data migration programmes.
• Excellent SQL skills, including data comparison, reconciliation and profiling.
• Experience testing ETL processes and data integration.
• Experience working with SAS 9.4 and/or SAS Viya.
• Experience with data migration, transformation and validation.
• Familiarity with test automation and scripting using Python, SAS and/or SQL.
• Experience working in Agile delivery environments.
• Experience with defect management tools such as Jira and Confluence.
• Active SC Clearance - HMRC clearance preferred, or active SC clearance held through another recognised government body.

Desirable

• ISTQB Foundation or Advanced Test Analyst certification.
• Previous experience working within HM Government or other regulated environments.
• Understanding of AWS/cloud platforms.
• Experience with containerised deployments.
• Experience supporting large-scale technology or data transformation programmes.

Contract Details

• 6-month contract
• £45-£51 per hour
• Inside IR35
• PAYE via Umbrella
• Telford
• Hybrid - 2 days onsite per week
• 2 positions available
• Active SC Clearance mandatoryIf you're an SC-cleared Data Test Analyst with strong SQL and data migration experience, we'd love to hear from you