Data Test Lead (Technical)
Description
KEY ACCOUNTABILITIES
• Own the technical data test approach, covering data migration, transformation, reconciliation and downstream data flows.
• Lead data testing across Data Migration, Policy Migration, Pricing, DataHub/InfoCenter, Cloud Data Access and SDP.
• Coordinate SQL/database-level validation/reconciliation, ETLs, interface/file validation and automated data comparison where appropriate.
• Own technical data risks, defects and exceptions, ensuring material discrepancies are quantified, resolved or formally accepted.
• Identifying environments, test data, resources, business SMEs and cross-workstream dependencies and related risks and mitigations.
• Provide consolidated technical data assurance to support migration readiness and go-live decisions.
ESSENTIAL SKILLS & EXPERIENCE
Lead and own testing activities
• Data Test Leadership: Proven experience defining and implementing technical data test approaches for complex migration and transformation programmes.
• Data Test Planning: Experience of leading and coordinating data test cycles through programme milestones.
• Technical Data Testing: Extensive hands-on experience of complex data migration testing, ETL/ELT validation, SQL, source-to-target reconciliation and data-quality assurance.
Drive Testing Excellence
• Data Quality: Establish consistent validation across completeness, accuracy, integrity, consistency, uniqueness and referential integrity.
• Automation: Drive automated data comparison and reconciliation where this provides repeatability, scale and earlier feedback.
• Shift Left: Engage early with data mapping, transformation rules and migration design to identify defects before formal migration test cycles.
Assure test deliverables
• Test Deliverable Assurance: Assure data test plans, scenarios, reconciliation rules, scripts, expected results and evidence.
• Traceability: Ensure technical data requirements, mappings and key migration risks are traceable to appropriate validation.
• Reconciliation Assurance: Ensure appropriate record-level, aggregate and control-total reconciliation is performed and evidenced.
Support and Test Readiness
• Data Test Readiness: Ensure mappings, transformation rules, data requirements and acceptance criteria are sufficiently defined before execution.
• Environment & Tooling: Ensure source/target environments, database access, reconciliation tooling and required test utilities are available.
• Test Data Readiness: Ensure representative datasets, expected results and baseline/reference data are available and controlled.
Collaborate and Communicate
• Stakeholder Collaboration: Excellent collaboration skills to work effectively with stakeholders, including product owners, scrum masters, and other leads.
• Clear Communication: Strong communication skills to articulate testing concepts clearly to both technical and non-technical stakeholders.
• Team Coordination: Experience in coordinating with cross-functional teams to ensure cohesive and aligned testing efforts.
Manage and report test metrics
• Data Test Report: Own the consolidated Technical Data Test Report, summarising coverage across source systems, reconciliation outcomes, exceptions, defects and residual data risks.
• Reconciliation: Track migrated, reconciled, rejected, failed and exception records, including reconciliation percentages and agreed tolerances.
• Data Quality: Report trends across completeness, accuracy, integrity, consistency and other applicable data-quality dimensions.
• Defect & Risk Management: Lead management and escalation of data quality issues, migration defects, exceptions and residual risks.
DESIRABLE PROFESSIONAL QUALIFICATIONS
• ISTQB Advanced Test Manager or relevant specialist testing certification.
• Project Test Delivery Management Certifications e.g. PRINCE2 Practitioner / APM / APMG.
• Microsoft Azure Data Fundamentals or equivalent cloud-data qualification.
• Relevant SQL, database or data-engineering certification.
ORGANISATION LEVEL
• Workstream Leadership
• Client Confidential
Skills
Sign in to read and join the discussion.