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. About PoloWorks PoloWorks is the leading provider of UK-based support services to the insurance market. We have built a strong reputation as dedicated and dependable experts in our field. We pride ourselves on our ability to be flexible, responsive, and knowledgeable. As a leading service support company and turnkey managing agency, our clients choose us because our staff not only have the expertise but also a profound affinity with their business challenges. Our mission is to support, inspire, and develop the insurers of today and tomorrow. Our clients, whether digital start-ups or well-established organisations, rely on the PoloWorks team to develop and strengthen their businesses. Our clients' goals are our goals. As such we design and deliver bespoke solutions to their specific business challenges. With offices located in both London and Cheltenham, PoloWorks is poised for ambitious growth, presenting thrilling opportunities for those who join us on the next phase of our journey. By becoming part of our team, successful candidates will be joining a business recognized as a Great Place to Work Certified organisation, and honored with awards for Best Workplaces for Women and Best Workplaces in Financial Services and Insurance. It's our mission to unleash the potential in every team, and we know that teams perform best when they are diverse and every team member feels that they belong. It is the unique contributions of all PoloWorks colleagues that drive our success, and we are committed to building an inclusive culture where everyone is empowered to do meaningful work and are recognised for their efforts. To that end, we are committed to providing an environment free of discrimination for everyone.