TESTQ Technologies
Business Analyst
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
IRIS Data Warehouse Snowflake Claims Reporting
Role
Business Analyst responsible for source to target mapping of IRIS claims data into a conformed data warehouse enabling accurate and reconciled reporting.
The role will act as a bridge between business stakeholders and data engineering teams while also supporting the team in understanding IRIS data structures and London Market claims data.
Primary Skills Must Have
- Strong hands-on experience in Source to Target Mapping (S2T) for legacy systems to Data Warehouse Snowflake.
- Experience working with traditional PAS AS400 systems extracting claims data.
- Proven experience in London Market Lloyd's claims data critical.
- Strong understanding of data modelling dimensions, facts, and data transformation business rules definition.
- Experience defining data quality rules, reconciliation logic, and validation frameworks.
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.
Soft Skills
- Strong stakeholder communication and collaboration.
- Ability to translate business requirements into data specifications.
- Problem-solving mindset with ownership and accountability.
- Ability to work with limited documentation and legacy systems.
- Capability to uplift team knowledge on data and domain.
What the Role Will Do
Key Responsibilities
- Analyze IRIS claims data to understand structure and relationships.
- Perform detailed source to target mapping from IRIS raw tables to conformed data models dimensions, facts.
- Define business rules, transformations, and filtering logic for claims and reinsurance reporting.
- Establish data quality checks and reconciliation back to IRIS source of record.
- Work closely with data engineers to support ingestion pipelines and transformation layers.
- Support UAT validation and reconciliation of reporting outputs.
- Act as a domain enabler helping the team understand IRIS data structures, London Market claims data, and reporting requirements.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Ideal Profile
- 8 - 12 years as a Data Business Analyst.
- Has delivered end to end mapping from legacy PAS or claims system to data warehouse.
- Prior experience working in London Market claims data environment.
- Comfortable working in data heavy integration led programmes.
Skills
Mandatory Skills: P&C Personal lines - Claims, P&C Personal lines - Products
“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