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 new Data Warehouse for London Market Insurance.
- Company: Polo Managing Agency is a leading player in the London Market insurance sector.
- 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, collaborating with industry experts in a dynamic environment.
- Qualifications: Strong knowledge of London Market insurance and experience in data warehouse projects are essential.
- Other info: This is a contract role based in Cheltenham, perfect for those looking to make a significant impact.
Business Analyst – Data Warehouse Delivery (London Market Insurance)
Department: Project Management
Employment Type: Contract
Location: Cheltenham
Reporting To: Hugh Griffiths
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.
#J-18808-Ljbffr
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, Snowflake, and Azure. Having hands-on experience or even a basic understanding of these tools can set you apart during discussions with our team.
✨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 and gain insights into current trends and challenges in data integration and business analysis.
✨Tip Number 3
Prepare to discuss your previous experiences with data mapping and ETL processes. Be ready to share specific examples of how you've successfully gathered requirements and collaborated with stakeholders to deliver data solutions in past projects.
✨Tip Number 4
Brush up on your documentation skills, particularly in creating process maps and data lineage diagrams. Being able to demonstrate your ability to produce clear and concise documentation will be crucial in showcasing your fit 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 outlined in the job description. Explain how your background aligns with the requirements, particularly your experience with PAS and data integration projects.
Showcase Relevant Skills: In your application, emphasise your analytical skills and problem-solving abilities. Mention any experience you have with BI tools or Agile methodologies, as these are desirable for the role.
Proofread Your Application: Before submitting, carefully proofread your application to ensure there are no spelling or grammatical errors. A polished application reflects attention to detail, which is crucial for a Business Analyst role.
How to prepare for a job interview at Polo
✨Know Your Data Warehouse Fundamentals
Make sure you brush up on your knowledge of data warehousing concepts, especially in relation to the London Market insurance sector. Be prepared to discuss your experience with data integration and how you've mapped source systems to target models in previous projects.
✨Demonstrate Your Analytical Skills
During the interview, showcase your analytical abilities by discussing specific examples where you've solved complex problems related to data flows or ETL processes. Highlight your attention to detail and how it has positively impacted project outcomes.
✨Communicate Effectively with Stakeholders
Since this role involves liaising with various stakeholders, practice articulating your thoughts clearly. Prepare to explain technical concepts in a way that non-technical team members can understand, as well as how you've facilitated workshops or validation sessions in the past.
✨Familiarise Yourself with Relevant Tools
If you have experience with BI/MI tools like Power BI or Tableau, be ready to discuss how you've used them in your previous roles. Additionally, understanding Agile methodologies and tools like Jira or Azure DevOps will give you an edge, so make sure to mention any relevant experience.
