Commercial Business Analyst

Marsh & McLennan Companies, Inc.; Greater London; Hybrid; GBP 45,000 - 65,000; Full time

Job summary

A global risk advisory firm in London is seeking a Commercial Business Analyst to join their Analytics team. This hybrid role involves preparing and structuring Excess of Loss property retro layers and presenting data insights to clients. The candidate should possess strong analytical skills, programming knowledge in Python and SQL, and the ability to communicate effectively with clients. Opportunities for professional development and a vibrant team culture are offered.

Benefits

Professional development opportunities

Inclusive company culture

Flexible work environment

Qualifications

• Strong analytical and programming skills (Python, SQL, Power BI).
• Ability to translate complex data into clear, actionable insights.
• Excellent communication skills for client‑facing presentations.
• Self‑starter with an entrepreneurial mindset; comfortable in an unstructured environment.
• Insurance/reinsurance experience is beneficial but not essential.

Responsibilities

• Support client advisory by preparing and structuring Excess of Loss property retro layers.
• Calculate pricing metrics and produce analytical outputs for renewals.
• Present data insights to brokers and clients in meetings.
• Manage renewal cycle for major client accounts.
• Participate in RFP presentations and strategy sessions.
• Collaborate with data engineering colleagues to deliver robust solutions.

Skills

Analytical skills

Python

SQL

Power BI

Communication skills

Education

Background in Mathematics, Computer Science, or similar quantitative discipline

Tools

Excel

Job description

Company:

Guy Carpenter

Job Title:

Commercial Business Analyst

Are you interested in working within a highly skilled team that specialises in delivering analytical insights and data‑driven solutions for major reinsurance clients? Do you have a technical acumen and excellent organisational skills? If so, we are currently looking to expand our team and are interested in speaking with top talent.

We are seeking a talented individual to join our Analytics team at Guy Carpenter. This role will be based in London office. This is a hybrid role that requires working at least three days a week in the office.

This role is responsible for supporting client advisory by preparing and structuring Excess of Loss property retro layers, calculating pricing metrics, and presenting data insights to brokers and clients. It involves managing the renewal cycle for major client accounts, including handling large retrocession accounts and participating in RFP presentations and strategy sessions. The role also focuses on developing data tools and analytical solutions using Excel, Python, SQL, and Power BI, collaborating with data engineering teams to enhance reporting capabilities.

We will rely on you for:

Client Advisory Support:

• Prepare and structure Excess of Loss property retro layers using in‑house systems.
• Calculate pricing metrics and produce analytical outputs for renewals.
• Present data insights to brokers and clients in meetings.

Renewal Cycle Management:

• Support 8–9 major client accounts during peak periods (e.g., 1/1 renewals).
• Work on large retrocession accounts valued between $1 million and $5 million.
• Participate in RFP presentations and client strategy sessions.

Data & Tool Development:

• Design and build self‑service analytical tools for benchmarking and insights.
• Utilise Excel, Python, SQL, and Power BI to create dashboards and reporting solutions.
• Collaborate with data engineering colleagues to deliver robust solutions.

Market Reporting:

• Coordinate production of bi‑annual market reports, ensuring data accuracy and validation.
• Manage input from junior team members and oversee quality control.

What you need to have:

• Strong analytical and programming skills (Python, SQL, Power BI).
• Ability to translate complex data into clear, actionable insights.
• Excellent communication skills for client‑facing presentations.
• Self‑starter with an entrepreneurial mindset; comfortable in an unstructured environment.
• Background in Mathematics, Computer Science, or similar quantitative discipline.
• Insurance/reinsurance experience is beneficial but not essential.

What makes you stand out:

• Previous Insurance/reinsurance experience

Why join our team:

• We help you be your best through professional development opportunities, interesting work and supportive leaders.
• We foster a vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have impact for colleagues, clients and communities.
• Our scale enables us to provide a range of career opportunities, as well as benefits and rewards to enhance your well‑being.

At Guy Carpenter, you can be your best. We work on challenges that matter with colleagues who help bring out our best. Our uniquely collaborative environment will empower you to focus on your personal and professional success, learning from top specialists in the (re)insurance industry and leading you towards a rewarding and impactful career.

Guy Carpenter, a business of Marsh McLennan (NYSE: MMC), is a leading global risk advisory and reinsurance specialist and broker. Marsh McLennan is a global leader in risk, strategy and people, advising clients in 130 countries across four businesses: Marsh, Guy Carpenter, Mercer and Oliver Wyman. With annual revenue of $24 billion and more than 90 000 colleagues, Marsh McLennan helps build the confidence to thrive through the power of perspective. For more information, visit guycarp.com, or follow on LinkedIn and X.

Marsh McLennan is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age background, civil partnership status, disability, ethnic origin, family duties, gender orientation or expression, gender reassignment, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law. We are an equal opportunities employer. We are committed to providing reasonable adjustments in accordance with applicable law to any candidate with a disability to allow them to fully participate in the recruitment process. If you have a disability that may require reasonable adjustments, please contact us at [e-mail].

Marsh McLennan is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh McLennan colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office‑based teams will identify at least one “anchor day” per week on which their full team will be together in person.