Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead business analysis for a new Data Warehouse in London Market Insurance.
- Company: Join Polo Managing Agency, a key player in the insurance sector.
- Benefits: Competitive daily rate of £600 - £800 and opportunities for professional growth.
- Why this job: Be part of a transformative project that shapes data capabilities in insurance.
- Qualifications: Strong knowledge of London Market insurance and experience in data integration required.
- Other info: Work in a dynamic environment with a focus on collaboration and innovation.
Department: Project Management
Location: Cheltenham
Compensation: £600 - £800 / day
Description
To support the successful delivery of a new Data Warehouse (DWH) capability for Polo Managing Agency (PMA), this role will provide expert business analysis across the build and implementation lifecycle. The BA will be responsible for capturing business and data requirements, mapping data from source systems (primarily PAS), and ensuring alignment between business needs and the technical DWH solution. This role requires strong experience in London Market insurance operations, data modelling, and systems integration, particularly between PAS and reporting/analytics platforms.
Key Responsibilities
- Lead business and data requirement gathering from underwriting, finance, claims, and operations teams.
- Develop source-to-target mappings from PAS and other upstream systems into the DWH.
- Analyse end-to-end data flows across operational and reporting systems.
- Document and optimise processes relating to data extraction, transformation, and load (ETL).
- Translate business requirements into clear, testable functional and non-functional specifications.
- Produce and maintain data dictionaries, lineage documentation, and reporting logic.
- Act as the primary liaison between business SMEs and DWH technical delivery teams.
- Facilitate requirements workshops, data validation sessions, and UAT preparation.
- Support definition of data quality rules, reconciliation checks, and exception handling mechanisms.
- Assist in establishing data governance practices for ongoing DWH use.
- Assist with traceability of business requirements through development, testing, and delivery phases.
- Collaborate on system testing, UAT, and go-live planning, ensuring completeness and accuracy.
- Contribute to project planning, RAID logs, and issue escalation.
- Support vendor evaluation and engagement where third-party solutions are involved.
Skills, Knowledge and Expertise
Essential:
- Strong knowledge of London Market insurance operations and data, including policy, claims, and financial data structures.
- Demonstrable experience on a DWH project or large-scale data integration (preferably from PAS to DWH).
- Hands-on experience in mapping source system data to target models (e.g., source-to-target specifications).
- Ability to work with structured and semi-structured data formats, including a working understanding of data models.
- Proficient in producing clear documentation: process maps, data lineage diagrams, functional specs.
- Effective communicator with stakeholders at all levels including underwriters, actuaries, and IT delivery teams.
- Highly analytical with strong problem-solving skills and attention to detail.
Desirable:
- Experience with London Market PAS platforms (e.g., OpenTWINS, DXC Assure, Sequel, IRIS).
- Knowledge of BI/MI tooling (e.g., Power BI, Tableau, Qlik).
- Familiarity with data warehouse technologies (e.g., SQL, Snowflake, Azure, Informatica, etc.).
- Exposure to Agile delivery and use of tools such as Jira or Azure DevOps.
Business Analyst - Data Warehouse Delivery (London Market Insurance) employer: PoloWorks
Contact Detail:
PoloWorks Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business Analyst - Data Warehouse Delivery (London Market Insurance)
✨Tip Number 1
Network with professionals in the London Market insurance sector. Attend industry events, webinars, or local meetups to connect with potential colleagues and learn about the latest trends and challenges in data warehousing.
✨Tip Number 2
Familiarise yourself with the specific PAS platforms mentioned in the job description, such as OpenTWINS or DXC Assure. Having hands-on experience or even a basic understanding of these systems can set you apart from other candidates.
✨Tip Number 3
Brush up on your data modelling skills and be prepared to discuss your experience with source-to-target mappings. Being able to articulate your approach to data integration will demonstrate your expertise in this area.
✨Tip Number 4
Prepare for potential scenario-based questions during interviews. Think about past projects where you successfully gathered requirements or resolved data quality issues, and be ready to share those experiences in detail.
We think you need these skills to ace Business Analyst - Data Warehouse Delivery (London Market Insurance)
Some tips for your application 🫡
Understand the Role: Before applying, make sure you fully understand the responsibilities and requirements of the Business Analyst position. Familiarise yourself with key terms like Data Warehouse, ETL processes, and London Market insurance operations.
Tailor Your CV: Customise your CV to highlight relevant experience in data analysis, business requirements gathering, and any specific tools or technologies mentioned in the job description, such as PAS systems or BI/MI tooling.
Craft a Compelling Cover Letter: Write a cover letter that connects your skills and experiences directly to the job requirements. Emphasise your analytical abilities, communication skills, and any previous work with data warehouses or insurance operations.
Showcase Relevant Projects: If you have worked on similar projects, include specific examples in your application. Detail your role, the challenges faced, and how you contributed to successful outcomes, particularly in data mapping and integration.
How to prepare for a job interview at PoloWorks
✨Know Your Data Warehouse Fundamentals
Make sure you have a solid understanding of data warehousing concepts, especially in relation to the London Market insurance sector. Be prepared to discuss your experience with data mapping and ETL processes, as these will be crucial for the role.
✨Demonstrate Your Analytical Skills
During the interview, showcase your analytical abilities by discussing specific examples where you've successfully gathered business requirements or optimised data flows. Use metrics or outcomes to illustrate your impact on previous projects.
✨Familiarise Yourself with PAS Systems
Since the role involves working with PAS systems, it’s beneficial to brush up on your knowledge of platforms like OpenTWINS or DXC Assure. Being able to speak confidently about these systems will show your preparedness and relevance to the position.
✨Prepare for Stakeholder Communication Scenarios
Expect questions about how you would communicate with various stakeholders, from underwriters to IT teams. Prepare examples that highlight your effective communication skills and your ability to bridge the gap between technical and non-technical audiences.
