Tokio Marine HCC
Senior Full Stack Data Quality Engineer (Outside IR35 contract)
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Senior Full Stack Data Quality Engineer
Assignment type: Outside IR35
About the Role
The supplier will be engaged to provide specialist hands-on data quality engineering services to the Finance & Data Reporting Product Team across TMHCC’s modern data platform testing, data quality engineering, and test automation. The engagement is focused on delivering agreed testing and automation outcomes across defined operational assurance priorities and initiative delivery outcomes.
Key Responsibilities
-
Full Stack Data Quality Engineering:
- Design and execute data quality testing across ingestion, transformation, warehouse, reporting/BI, APIs, metadata, lineage, and reconciliation layers.
- Validate Snowflake data lake and data warehouse outputs against source systems, business rules, transformation logic, and reporting requirements.
- Test ETL and ELT processes, dbt models, SQL transformations, data mappings, aggregations, reference data, and downstream Power BI outputs.
- Apply data quality checks covering accuracy, completeness, consistency, timeliness, validity, uniqueness, and reconciliation.
- Support root cause analysis of data defects and collaborate with engineering and business stakeholders to support timely resolution of agreed data quality findings.
- Provide clear test evidence, defect analysis, risk commentary, and release readiness input for product delivery decisions.
-
Automation Framework and Test Harness Maturity:
- Maintain and improve the existing dbt Core/dbt Cloud test harness for Snowflake-based data validation.
- Extend reusable automated test coverage for ingestion checks, transformation validation, regression testing, reconciliation, and reporting validation.
- Improve the test harness architecture so that it is easier to maintain, extend, and reuse across agreed assurance activities and defined initiative delivery outcomes.
- Build automated checks and supporting utilities using dbt, SQL, Python, GitHub, Azure DevOps, and relevant cloud data platform tooling.
- Integrate automated tests into CI/CD workflows to enable earlier detection of data quality issues.
- Create practical reusable assets such as test patterns, dbt macros, validation templates, regression packs, and framework documentation.
- Identify manual testing activities that can be automated to improve speed, repeatability, and confidence.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
-
Legacy and Modern Data Platform Assurance:
- Deliver testing across the FDR transitional estate, including legacy SQL Data Warehouse and Snowflake modern data platform components, where included within agreed scope.
- Provide reconciliation and regression testing where data flows, reports, or downstream products are impacted by ERS migration activity.
- Assess risks arising from coexistence of legacy and modern platforms, including source mapping, transformation differences, reporting impacts, and cutover-related validation.
- Collaborate with FDR stakeholders and wider programme teams to understand dependencies, testing scope, acceptance criteria, and data quality implications.
- Ensure test approaches reflect both current-state operational needs and future-state platform direction
-
Product Delivery Leadership & Stakeholder Engagement:
- Collaborate with the Engineering Delivery Lead, Product Owner, Business Analysts, Developers, offshore partners, and Quality Engineering Practice as required to agree scope, dependencies, risks, and acceptance criteria.
- Translate business rules and data requirements into testable validation logic and automated checks.
- Support agreed operational assurance priorities and initiative delivery outcomes by applying risk-based testing and prioritising effort based on business impact.
- Participate in relevant delivery ceremonies where required to agree scope, dependencies, data quality risks, defect triage, release readiness, and delivery governance input.
- Provide concise reporting on test progress, automation coverage, defects, data quality risks, and delivery blockers.
- Work pragmatically with the evolving FDR operating model, supporting improved efficiency through stronger engineering-led testing practices and reusable deliverables.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
- Quality Engineering Maturity:
- Share knowledge and practical guidance on dbt testing, Snowflake validation, reconciliation, and automated data quality checks.
- Help improve testing standards, reusable patterns, and quality metrics within the Finance & Data Reporting Product Team.
- Enable client teams to understand, use, and extend the test harness through reusable guidance, documentation, and knowledge transfer.
- Contribute to quality measures such as test coverage, automation coverage, defect leakage, regression effectiveness, and data quality trends.
- Leave behind maintainable documentation, reusable patterns, and clear handover material to support continuity beyond the contract period.
About Us
Your success is our priority. In a world that is rapidly changing, TMHCC enables you to take on opportunities with confidence. At Tokio Marine HCC, we pride ourselves on hiring the smartest, most conscientious people, who want to make a difference no matter their background. And then we give them the support and trust they need. We’re always looking for curious, creative transformative thinkers who want to change the status quo and have a passion for doing the right thing. If this is you, then we want you on our team.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location