This inclusive employer is a member of myGwork – the largest global platform for the LGBTQ business community. General Job Title: Delegated Bordereaux Analyst Division: Beazley Shared Services - Underwriting and Claims Operations Reports To: As per Beazley’s organisation chart – this role will be based in Birmingham Key Relationships: Underwriters, claims managers, underwriting and claims assistants, IT, BI team, data management, coverholder operations team, claims business management team Job Summary: To support and develop the analysis and management of bordereaux from Beazley’s delegated partners (coverholders and TPAs) in order to provide robust management information on binding authorities to the business teams. Key Responsibilities: To support the analysis and management of bordereaux from third party providers, using Beazley’s processing system - Knowledge Center. This is a system that has been built for the business to facilitate central storage and analysis of detailed information provided by coverholders and claims TPAs on bordereaux (excel spreadsheets). The role involves: Working with the Delegated Coverholder Operations, Delegated Assurance and Claims Business Management teams and Coverholder Data Analysts to deliver the business vision for the collection, analysis and MI as defined by the Delegated Underwriting Committee, the Group Claims Committee and other Beazley Committees and teams. Working with the underwriting and claims teams to understand their data requirements, and any action required to facilitate upload of their data on to the system Analysis of bordereaux to create and maintain bordereaux templates to upload into the Knowledge Center database in a clean, consistent manner. This involves: Analysing the data provided by coverholders and TPAs, mapping the data to KC, creating data templates within KnowledgeCenter; Ensuring that bordereaux provided by coverholders and TPAs are consistent with Lloyd’s Coverholders and TPA Reporting Standards (v5) as well as Beazley’s own data requirements for regulatory and internal reporting; Agreeing, communicating and documenting what data cleansing and business rules need to be applied to the data as it is entered to ensure that it results in a consistent format in the database and writing these rules into the templates; Developing and documenting bdx manipulation automation, e.g. developing excel macros; Documentation ownership and maintenance of fields mapped and rules applied to ensure consistency, common standards and version control; Testing of templates using real and test data to ensure rules operate as anticipated. Finding, and documenting, logical, practical solutions to issues encountered. Review of exception reports identifying contract breaches for the bordereaux uploaded and reporting on these to the relevant stakeholders and committees as required. Working with the Delegated Operations Team on strategic projects as required General At Beazley we are committed to doing the right thing because it is the right thing to do. It is important that within all your interactions both internally and externally you adhere to this principle through adoption of Beazley’s core values and behaviours. Adopt the Beazley culture of professionalism, integrity, effectiveness, and dynamic attitude that contributes to an internal environment of teamwork and promotes a positive brand image and experience to our external customers. Comply with Beazley procedures, policies and regulations including the code of conduct. Undertake training on Beazley policies and procedures as delivered by your line manager, Talent Management, or assurance teams (compliance, risk, internal audit) either directly, via e-learning or the learning management system. Display business ethics that uphold the interests of all our customers. Ensure all interactions with customers are focused on delivering a fair outcome, including having the right products for their needs. Comply with any specific responsibilities necessary for your role as outlined by your line manager, Talent Management, or assurance teams (compliance, risk, internal audit) and ensure you keep up to date with developments in these areas. This may include, amongst others, Beazley’s underwriting control standards, Beazley’s claims control standards, other Beazley standards and customer relationship management. Carry out additional responsibilities as individually notified, either through your objectives or through the learning management system. These may include membership of any Beazley committees or working groups. Personal Specification: Education and Qualifications Degree or equivalent in any discipline Skills and Abilities Able to harness technical knowledge of a system to respond effectively to business needs Able to work with a large amount of detailed information whilst retaining focus and achieving consistent quality and accuracy Ability to analyse and manipulate business data in order to create, map and maintain relevant templates Able to understand how systems operate at a high level whilst working within detailed areas; able to use logic and analytical thinking to foresee the impact of changes at a detailed level to the overall operation of a system and to identify issues associated with this Able to translate technical issues into simple language so these can be readily understood by the business, and to interact with the business to resolve these successfully Ability to think creatively to both anticipate and solve problems Ability to clearly document and communicate operating process and procedures Excellent excel skills are required for this role Knowledge and Experience Experience of cleansing/manipulating business data, preferably within an insurance environment for analysis purposes and/or using systems to do this Experience of supporting and maintaining IT systems Experience in a technical data/business analyst role Knowledge of binding authorities /bordereaux beneficial Experience of working in a Lloyd’s/general insurance environment advantageous Aptitude and Disposition High levels of consistent concentration Attention to detail - able to work methodically through large amounts of detail without losing focus Aptitude for problem solving, Logical, meticulous, analytical Enjoys organising data at a detailed level in a consistent, logical way Professional approach to successfully interact with underwriting and claims staff Good written and commination skills Persistent, able to handle frustration and see issues through to the end, flexible enough to change approach and find creative solutions when issues arise Technical but able to communicate successfully with non-technical staff Competencies Accuracy Analytical thinking Problem solving Concern for quality Customer focus