Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join us as a Business Analyst to drive the delivery of a cutting-edge Data Warehouse.
- Company: Polo Managing Agency is a leader in London Market Insurance, focused on innovation and excellence.
- Benefits: Enjoy competitive pay of £600 - £800 per day and the chance to work on impactful projects.
- Why this job: Be at the forefront of data transformation in insurance, collaborating with diverse teams and enhancing your skills.
- Qualifications: Strong knowledge of London Market insurance and experience in data integration are essential.
- Other info: This is a contract role based in London, perfect for those looking to make a significant impact.
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.
- 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: Polo
Contact Detail:
Polo Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business Analyst - Data Warehouse Delivery (London Market Insurance)
✨Tip Number 1
Familiarise yourself with the specific data warehouse technologies mentioned in the job description, such as SQL and Snowflake. Having hands-on experience or even completing relevant online courses can give you a significant edge during discussions.
✨Tip Number 2
Network with professionals in the London Market insurance sector. Attend industry events or join relevant online forums to connect with potential colleagues or mentors who can provide insights into the role and company culture.
✨Tip Number 3
Prepare to discuss your experience with data mapping and ETL processes in detail. Be ready to share specific examples of how you've successfully gathered requirements and translated them into actionable specifications in previous roles.
✨Tip Number 4
Brush up on your communication skills, especially in terms of liaising with stakeholders at various levels. Practising how to clearly articulate complex data concepts to non-technical audiences will be crucial for this role.
We think you need these skills to ace Business Analyst - Data Warehouse Delivery (London Market Insurance)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience in London Market insurance operations and data warehousing. Use specific examples that demonstrate your skills in data mapping, ETL processes, and stakeholder communication.
Craft a Compelling Cover Letter: Write a cover letter that clearly outlines your understanding of the role and how your background aligns with the key responsibilities. Mention your experience with PAS systems and any relevant BI/MI tools you are familiar with.
Showcase Relevant Projects: In your application, include details about previous projects where you have successfully gathered business requirements or worked on data integration. Highlight your analytical skills and problem-solving abilities.
Prepare for Technical Questions: Be ready to discuss your technical knowledge during the interview process. Brush up on data modelling concepts, data governance practices, and your experience with Agile methodologies, as these may come up in discussions.
How to prepare for a job interview at Polo
✨Showcase Your Domain Knowledge
Make sure to demonstrate your understanding of London Market insurance operations during the interview. Be prepared to discuss specific data structures related to policy, claims, and financial data, as this will show your expertise in the field.
✨Prepare for Technical Questions
Expect questions about data warehousing and integration, particularly around mapping source systems like PAS to target models. Brush up on your knowledge of ETL processes and be ready to explain how you would document and optimise these workflows.
✨Communicate Clearly with Examples
Effective communication is key. Use examples from your past experiences to illustrate how you've successfully gathered requirements, facilitated workshops, or collaborated with stakeholders. This will help convey your ability to bridge the gap between business needs and technical solutions.
✨Demonstrate Analytical Skills
Be prepared to showcase your analytical thinking and problem-solving abilities. You might be asked to analyse a hypothetical data flow or identify potential issues in a given scenario, so practice articulating your thought process clearly.
