Data Engineer - Credit, Financial & Portfolio Analytics - Reinsurance

Company:Guy Carpenter

Description:

The Data Engineer plays a crucial role in supporting our brokers by developing and maintaining robust data pipelines and systems that facilitate the evaluation of client portfolios, structuring of reinsurance programs, and conducting comprehensive portfolio-wide analytics.

What can you expect?

• As a Data Engineer, you will collaborate with our model vendor to enhance our analytics tools and infrastructure.

• You will be responsible for designing, implementing, and maintaining data models and databases that support reinsurance analytics and reporting.

• You will be Identifying opportunities for process automation and optimisation to improve efficiency and scalability will be a key part of your role.

• Staying up to date with industry trends and emerging technologies in reinsurance and data engineering.

• You will work closely with clients to ensure the integrity and accuracy of data throughout the data lifecycle.

• Occasional travel may be required, and we value your ability and willingness to do so.

We will count on you to:

• Design and implement data collection and processing systems.

• Cleanse, transform, and manipulate data to prepare it for analytical tools, incorporating suitable assumptions for the given portfolio.

• Populate and maintain our analytics tools, ensuring they are tested for errors and inconsistencies.

• Develop and maintain model documentation, parameterization, and default probabilities.

• Collaborate with external providers to enhance and update our modelling framework, including developing automation where applicable.

• Create new data solutions to enhance our peer review capabilities.

• Liaise with analytics specialists across the division and GC Global Specialties to ensure data alignment and integrity.

• Enhance and develop reporting capabilities, including the use of Power BI and other visualisation tools.

• Embrace and utilise big data by leveraging internal and external data sources and systems.

• Contribute to enhancing the division's skills and knowledge in the usage of analytics to empower our advice.

What you need to have:

• A solid understanding of insurance or reinsurance is essential.

• Bachelor’s degree in Data Science, Statistics, Mathematics, Computer Science, Business Administration, Economics, or a related field

• Familiarity with SQL for database querying and manipulation.

• Proficiency in Python and other programming languages relevant to data engineering.

• Understanding of credit, surety, and political risk from underwriting or broking perspectives.

• An innovative and creative mindset.

• Strong problem-solving skills.

• A client-focused approach, both internally and externally.

• Effective communication skills.

What makes you stand out?

• Alteryx Designer Advanced certification.

• Experience in credit, financial, and portfolio analytics.

• Familiarity with reinsurance concepts, terminology, and industry-specific data requirements.

• Understanding the unique challenges and complexities of reinsurance data.

• Effective communication and collaboration skills to work with cross-functional teams, including data scientists and actuaries.

• The ability to translate technical concepts into understandable terms for non-technical stakeholders is highly valuable.

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.

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 reasonableaccommodations@mmc.com.

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.