At a Glance
- Tasks: Bridge the gap between business needs and data engineering for accurate claims reporting.
- Company: Join a leading firm in the London Market with a focus on innovation.
- Benefits: Enjoy a hybrid work model, competitive pay, and opportunities for professional growth.
- Other info: Collaborative environment with a strong emphasis on team knowledge sharing.
- Why this job: Make a real impact by transforming legacy data into valuable insights.
- Qualifications: Experience in data mapping and understanding of London Market claims is essential.
The predicted salary is between 60000 - 80000 £ per year.
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 Lloyds 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
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
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
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
Mandatory Skills:
- P&C Personal lines - Claims
- P&C Personal lines - Products
Contact Details:
TESTQ Technologies Limited Recruitment Team
We think you need these skills to ace Business Analyst Data London Market
SourcetoTarget Mapping (S2T)
Data Warehouse (Snowflake)
AS400 Systems
London Market Claims Data
Data Modelling
Data Transformation
Data Quality Rules Definition
