Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join us as a Business Analyst to drive the Data Warehouse project in London Market Insurance.
- Company: Polo Managing Agency is a leading player in the London Market insurance sector.
- Benefits: Enjoy competitive pay of GBP 600 - GBP 800 per day and flexible working options.
- Why this job: Be part of a transformative project that enhances data capabilities and impacts the insurance industry.
- Qualifications: Strong knowledge of London Market insurance and experience in data integration projects are essential.
- Other info: This is a contract role with opportunities for professional growth and collaboration.
The predicted salary is between 43200 - 57600 £ per year.
Business Analyst – Data Warehouse Delivery (London Market Insurance)
Join to apply for the Business Analyst – Data Warehouse Delivery (London Market Insurance) role at PoloWorks
Business Analyst – Data Warehouse Delivery (London Market Insurance)
3 weeks ago Be among the first 25 applicants
Join to apply for the Business Analyst – Data Warehouse Delivery (London Market Insurance) role at PoloWorks
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.
Department: Project Management
Location: London
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.
Seniority level
-
Seniority level
Mid-Senior level
Employment type
-
Employment type
Contract
Job function
-
Job function
Research, Analyst, and Information Technology
-
Industries
Insurance
Referrals increase your chances of interviewing at PoloWorks by 2x
Get notified about new Business Analyst jobs in London, England, United Kingdom .
Business Operations | Analyst/Associate | London
London, England, United Kingdom 6 days ago
London, England, United Kingdom 2 weeks ago
London, England, United Kingdom 2 months ago
London, England, United Kingdom 2 weeks ago
London, England, United Kingdom 2 weeks ago
London, England, United Kingdom 1 month ago
London, England, United Kingdom 1 week ago
London, England, United Kingdom 4 weeks ago
City Of London, England, United Kingdom £80,000.00-£95,000.00 6 hours ago
Hemel Hempstead, England, United Kingdom 4 weeks ago
London, England, United Kingdom 4 weeks ago
London, England, United Kingdom 4 days ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
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
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 integration projects. Be ready to share specific examples of how you've successfully gathered requirements and translated them into functional 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 directly addresses the key responsibilities and skills mentioned in the job description. Explain how your background aligns with the requirements, particularly your experience with PAS and DWH projects.
Showcase Relevant Projects: In your application, include details of any relevant projects you've worked on, especially those involving data integration or DWH capabilities. Highlight your role and the impact of your contributions.
Prepare for Technical Questions: Anticipate technical questions related to data modelling, systems integration, and data governance practices. Be ready to discuss your problem-solving approach and provide examples from your past experiences.
How to prepare for a job interview at PoloWorks
✨Showcase Your Knowledge of London Market Insurance
Make sure to highlight your understanding of London Market insurance operations during the interview. Discuss specific experiences you've had with policy, claims, and financial data structures to demonstrate your expertise.
✨Prepare for Data Mapping Questions
Expect questions related to mapping source system data to target models. Be ready to explain your approach to developing source-to-target mappings, particularly from PAS to a Data Warehouse, as this is crucial for the role.
✨Communicate Clearly with Stakeholders
Effective communication is key in this role. Practice articulating complex concepts in a straightforward manner, as you'll need to liaise with various stakeholders, including underwriters and IT teams.
✨Demonstrate Analytical and Problem-Solving Skills
Be prepared to discuss how you've tackled analytical challenges in past projects. Share examples that showcase your attention to detail and problem-solving abilities, especially in relation to data flows and ETL processes.
