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:
Working with the Delegated Coverholder Operations, Delegated Assurance Business Management teams and Coverholder Data Analysts to deliver the business vision for the collection, analysis and MI as defined by Lloyds standards, and the Group Claims Committee and other Beazley Committees and teams.
- Working with the underwriting 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 relevant database in a clean, consistent manner. This involves:
- Analysing the data provided by coverholders and TPAs, mapping the data to the relevant system.
- Ensuring that bordereaux provided by coverholders and TPAs are consistent with Lloyd’s Coverholders and TPA Reporting Standards (v5.2) 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 – PIED and Being Beazley.
- Adopt the Beazley culture of Professionalism, Integrity, Effectiveness and Dynamic that contributes to an internal environment of teamwork and promote 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, the Talent Management development 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, the 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
Excellent excel skills are required for this role, with a willingness to learn
- Ability to think creatively to both anticipate and solve problems 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 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
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
Outcome focused, self-motivated, confident and enthusiastic
- Professional approach to successfully interact with internal as well as external contacts, in particular external audit firms and other managing agents
- Diplomatic, cooperative and collaborative in approach
- Assertive, persuasive, resilient
- Attention to detail - able to work methodically through large amounts of detail without losing focus
- Aptitude for problem solving,
- 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
Competencies
- Accuracy
- Analytical thinking
- Problem solving
- Concern for quality
- Customer focus