Test Data Specialist

Test Data Specialist
Contract
Salesforce Data Models
Discovery (Inside IR35, 2 months) → Implementation SOW (Outside IR35)
£450.00 - £470.00p/d
6 Months+
Manchester - Compulsory 2 days per week on-site
ASAP Start

Role Purpose
The Test Data Specialist is responsible for the design, generation, and timely delivery of synthetic and anonymised test data sets to support SIT, UAT and NFT testing across Salesforce Gas, Salesforce Power, UMAX Gas & Power, Flui Marketflow (Gas & Power), and Flui Meterflow.
The role exists to ensure that test data availability does not become a critical path risk, providing ingestion-ready, linkable datasets that accurately reflect production structures while remaining fully GDPR and PII compliant. This will allow testing to proceed at pace without the necessary live data.

Key Responsibilities
Test Data Design & Creation
• Design and generate synthetic and anonymised datasets that:
o Are fully GDPR and PII compliant
o Reflect production-like structures, distributions, and edge cases
o Are suitable for functional, integration, and end-to-end testing

• Create data at sufficient volume and complexity to meet Salesforce, Flui, and UMAX ingestion profiles
Timely Data Provisioning
• Provision test data to agreed schedules to support SIT, UAT, NFT, and cutover rehearsals.
• Rapidly regenerate or adapt datasets in response to:
o Schema or interface changes
o Defect resolution
o Iterative test cycle requirements

Cross-System Data Linking & Integrity
• Define and maintain consistent synthetic identifiers and keys that:
o Enable records to remain linkable across Salesforce, UMAX, and Flui platforms
o Preserve referential integrity and unified record views

• Ensure relationships (e.g. customer, supply point, meter, contract, market flow) are coherent and test-valid across all systems
Format & Ingestion Readiness
• Deliver datasets in the required formats and structures for each target platform (e.g. APIs, files, staging tables)
• Validate data against ingestion rules, mandatory fields, and system constraints prior to release

Required Skills & Experience
Essential
• Proven experience delivering synthetic and anonymised test data for complex enterprise platforms
• Strong understanding of GDPR and PII constraints in test environments
• Hands-on experience with Salesforce data models and ingestion patterns
• Solid grasp of relational data modelling and referential integrity
• Ability to generate realistic, high-volume datasets under time pressure
• Strong communication and delivery focus

Desirable
• Experience in energy or utilities domains (gas, power, metering, market flows)
• Familiarity with UMAX and/or Flui Marketflow / Meterflow
• Experience supporting SIT, UAT, and non-functional testing
• Practical experience using scripting or tooling for automated data generation (e.g. SQL, Python)

Role Boundaries
• This role owns test data generation and provisioning
• It does not own migration logic, ETL development, or migration assurance
• It enables testing by ensuring data readiness, not by validating migration outcomes

Test Data Specialist