Sql jobs in United Kingdom

Job Title:

Division:

Location:

London

The role of the Exposure management team is:

• Support of Underwriting teams with modelling analysis for business and risk decision making and business opportunities.
• Support of Underwriting teams with analysis to help them manage and optimise their portfolios to their underwriting risk limits.
• Recording and modelling of exposure information with sufficient levels of detail and integrity.
• Production of data to support portfolio rollup processes, LSM and Liberty Group reporting and external reporting (Regulatory return data includes RDS, Lloyd’s Catastrophe Model and other Supplementary information).
• Production of post event exposure and loss potential analysis.
• Production of required outward reinsurance placing information.
• Production of capital model catastrophe data feeds.
• Production of internal Management Information.

Recording and modelling of exposure information in order to monitor allocated portfolios.

Liaison with the class Underwriters for the allocated portfolios to lead the quoting/aggregation service. Support rollup processes ensuring consistency across multiple geographies. Support the training of junior analysts and the outsourcing team.

• Support the Integrated Business Unit team to lead the quoting/cleansing service for your allocated classes that in turn supports all rollups and reporting as well as bespoke Underwriter analytics to assist with assessing new business opportunities.
• Use third party modelling software (AIR) to model risks on behalf of Underwriters pre-bind.
• Maintaining an excellent relationship with offshore partner modelling team, answering queries and providing ongoing guidance.
• Peer reviewing third party output, providing guidance and improvement strategies where necessary.
• Supporting the senior team to ensure accurate and timely completion of BAU tasks focused on allocated classes.
• Support the senior team to deliver the r ecording and maintenance of policy and exposure information in accumulation systems monitoring, maintaining and improving data quality.
• Lead Integrated Business Unit and Outsourcing training and knowledge transfer.
• Support the team with tasks as part of the delivery of exposure management projects.
• Lead the response to the outsourcing business partners with queries around the cleansing assumptions for aggregation and modelling, taking ownership of complex accounts as required.
• Provide validated modelled output that can be used in all required internal and external regulatory submissions including but not limited to RDS, LCM, Aggregate Monitoring, Outwards RI submissions, ERM Reporting, GAREAT/LFB reporting.
• Learn about classes modelled in modelling platforms and how to best use catastrophe models

Adherence to all relevant regulatory requirements forms part of your role, and the demonstration of behaviours as set out in the Conduct Risk Policy, as they relate to your role, is core to LSM's commitment to placing customers at the centre of our business and behaving with integrity.LSM expects you to understand your responsibilities relating to all regulatory and internal requirements, and to proactively demonstrate compliance with these requirements and behaviours at all times. These requirements include Solvency II, fair treatment of customers, Financial Crime, Data Protection, Conflicts of Interest, and Whistleblowing.

• Undergraduate degree (or equivalent) in a relevant field (e.g. Natural Sciences, Finance, Economics, Mathematics, Geography).
• Working knowledge of third-party catastrophe models/aggregation tools essential.
• Advanced knowledge of using functions within Microsoft Excel.
• Familiarity of Technical coding including SQL essential (R, VBA, Python desirable).
• Experience of using and implementing Data Dashboards (e.g. PowerBI, Pyramid, Tableau) is desirable.
• Experience of working with offshore business partners is desirable.
• Highly analytical, with ability to process and understand data quickly and creatively.
• Efficient and organised individual with a mindset for continuous improvements.
• Ability to work independently whilst integrating into a time critical business environment.
• Excellent business communication skills including the ability to communicate technical concepts to range of audiences, and creative thinking to solve complex issues as they arise.

Liberty Specialty Markets(LSM) offers specialty and commercial insurance and reinsurance products across key UK, European, Middle East, US and other international locations. We provide brokers and insureds with a broad product range through both the Company and Lloyd’s markets and haveapproximately 1,900 employees in approximately 60 offices around the world .

As the international commercial business of the Liberty Mutual Insurance Group, we enjoy some strong benefits:

· An inclusive culture, long-term stability and financial strength that comes from being part of one of the largest P&C insurers in the world.

· Diverse business opportunities of a leading international re/insurer.

· An entrepreneurial spirit that puts a focus on our client and broker partners at the heart of what we do.

People enjoy working for Liberty for its sense of purpose, for being connected to a 45,000-strong enterprise that has social good at its heart. As an employer, we create an environment where careers can flourish – a place for people to learn, grow, develop, and celebrate success.

At Liberty Mutual, we believe progress happens when people feel secure. By providing protection for the unexpected and delivering it with care, we help people embrace today and confidently pursue tomorrow.

In business since 1912, and headquartered in Boston, today we are the sixth largest global property and casualty insurer based on 2020gross written premium.We also rank 77th on the Fortune 100 list of largest corporations in the U.S. based on 2019revenue.As of December 31, 2020, we had $43.8billion in annual consolidated revenue.

We employ over 45,000 people in 29 countries and economies around the world.We offer a wide range of insurance products and services, including personal automobile, homeowners, specialty lines, reinsurance, commercial multiple-peril, worker’s compensation, commercial automobile, general liability, surety, and commercial property.

We are determined that our Values will accurately describe how we behave; not just "how we say we behave". All colleagues are expected to demonstrate our Values(below)and associated behavioursand line managers are empowered to manage their teams accordingly. Guidanceand training on thisis offered to all colleagues.