Technical Support Analyst (Excel, Data Analysis & Reporting)

Company:Marsh

Description:

We are seeking a talented individual to join our Marsh Portfolio Solutions team at Marsh. This role will be based in Norwich. This is a hybrid role that has a requirement of working at least three days a week in the office.

Marsh Portfolio Solutions (MPS) is a dynamic client-centric practice within Marsh UK and Ireland that places and manages a range of innovative portfolio solutions across Marsh Practices.  MPS comprises of 120 dedicated professionals providing a range of intermediary services to insurer clients including management information, insights and analysis.

The successful candidate will be required to interpret slips and endorsements to process risk details & premium information onto our internal database. You will also be required to data check and format reports on a monthly, quarterly and half-yearly basis.

We will rely on you to:

• Be the primary owner for all the data and technical tasks for the Quota Share Facility.
• Produce analysis and reporting on slips and endorsements as well as investigating breaks and queries.
• Input risk data (original risks plus endorsements) into facility databases ensuring integrity of data and keeping within team Key Performance Indicators.
• Extract data from the system and provide it in a clear format for senior colleagues.

What you need to have: 

• Knowledge of all Microsoft office products with heavy reference to Excel / Word / PowerPoint
• Attention to detail
• Highly organised and methodical in approach
• Ability to work under pressure
• Happy to work with large volumes of data

What makes you stand out:

• Strong data management experience ideally within analysis and reporting
• Good Excel especially with Pivot tables, Look-ups and Formulas
• Knowledge of Class of Business (ideally Property)
• Data Analysis, Processing and Reporting experience
• Experience in the insurance market

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

Marsh, a business of Marsh McLennan (NYSE: MMC), is the world’s top insurance broker and risk advisor. 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 marsh.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 [email protected].

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.