Data Analyst

Munich Re Group; Greater London; Sur place; GBP 45 000 - 75 000; Plein temps

Résumé du poste

Munich Re Group is seeking a Data Analyst to join the UK Life Data Management Team in London. You will translate and validate client data, produce CLR-ready Valuation Portfolio data, and deliver analytical reports for internal stakeholders.

You will develop data transformation scripts, cleanse and map portfolio data, and support ad-hoc reporting. You will gather requirements for data use and ensure data quality across deliveries.

Qualifications

• Demonstrable Data Processing / Handling and Data Analysis skills.
• Professional experience in a Data Analyst role.
• SQL Scripting, R, Python, Power BI, Advanced MS Excel.
• Cloud Based Data Platform (Azure, Databricks) Git and version control practices.
• High level of numerical and analytical skills.
• Strong root cause analysis and problem-solving skills, with the ability to investigate and resolve complex data issues effectively.

Responsabilités

• Develop, execute and manage data transformation scripts to produce Valuation portfolio data.
• Data cleansing, profiling, mapping and mining of Valuation portfolio data.
• Support and deliver various ad-hoc reporting needs for internal clients regarding the Valuation portfolio data
• Support business requirement gathering activities, especially on their data and reporting needs that relate to valuation portfolio data and how that will be utilised in wider process improvements/projects.
• Ensure client data used for Valuation portfolio delivery is stored in consistent format and in line with treaty arrangements.
• Support and improve where possible processes and/or tools used in the team in relation to the Valuation portfolio delivery.
• Determining, monitoring and reporting the availability, quality and consistency of client data used in Valuation Portfolio deliveries.
• Liaison with internal clients to fully understand data content to maximise the benefits to the business, uncovering possible weaknesses and working for their correction.
• Gather, understand and document detailed business requirements for data using appropriate tools and techniques, and ensure these are agreed at all levels throughout the business.
• Managing own work priorities; working in a highly organised way.
• Managing colleagues’ expectations.
• Ensuring data used in various work streams are of good quality and up to date.
• Working independently or together with colleagues as appropriate.
• Produce quality written and numerical material appropriate to purpose.

Connaissances

Data processing

Data analysis

SQL scripting

R

Python

Power BI

Excel

Azure

Databricks

Git

Numerical skills

Root cause analysis

Outils

Oracle

Databricks

Azure

Git

Description du poste

About UK Life Branch:

With the office in Munich, it forms the Life 1 division of Munich Re. The UK life market is one of the, if not the, most competitive life markets in the world. We understand that Life insurers work in a dynamic market where medical progress, demographic trends and changing lifestyles are constantly giving rise to new risk landscapes. This demanding situation is made even more challenging by changing laws and regulations and ever tougher competition. So, we need a smart strategy and structure in order to succeed.

At UK & Ireland Life we have three pillars to our business strategy, protection, longevity and reinsurance structuring. All three are key to the success of our business so it’s important to look at the big picture. In terms of clients, we trust them as experts of their business and provide them with the financial strength of the world’s largest reinsurer, global expertise, and sharp pricing so that they are both competitive and profitable.

About the role:

Working within the UK Data Management Team, responsible specifically for LH1 Valuation Data, you will work with our Lead Analysts to ensure data updates & delivery of LH1 Valuation Data.

This will include being responsible for and having oversight of translating and validating client data, production of CLR ready Valuation Portfolio data and producing data analysis and reports for internal clients (Valuation team) regarding valuation portfolio data.

Key Responsibilities:

• Develop, execute and manage data transformation scripts to produce Valuation portfolio data.
• Data cleansing, profiling, mapping and mining of Valuation portfolio data.
• Support and deliver various ad-hoc reporting needs for internal clients regarding the Valuation portfolio data
• Support business requirement gathering activities, especially on their data and reporting needs that relate to valuation portfolio data and how that will be utilised in wider process improvements/projects.
• Ensure client data used for Valuation portfolio delivery is stored in consistent format and in line with treaty arrangements.
• Support and improve where possible processes and/or tools used in the team in relation to the Valuation portfolio delivery.
• Determining, monitoring and reporting the availability, quality and consistency of client data used in Valuation Portfolio deliveries.
• Liaison with internal clients to fully understand data content to maximise the benefits to the business, uncovering possible weaknesses and working for their correction.
• Gather, understand and document detailed business requirements for data using appropriate tools and techniques, and ensure these are agreed at all levels throughout the business.
• Managing own work priorities; working in a highly organised way.
• Managing colleagues’ expectations.
• Ensuring data used in various work streams are of good quality and up to date.
• Working independently or together with colleagues as appropriate.
• Produce quality written and numerical material appropriate to purpose.

Competencies:

Business Acumen (we think big)

You understand the business’ ambition, your team’s commitments and how your role contributes to this.

Plans and aligns (we lead the ‘we’)

You plan and prioritise your work to fit with deadlines and longer-term commitments for you and your team and collaborate with others, encouraging diversity of thought.

Action oriented (we grow with our clients)

You take on new tasks, opportunities and challenges with a keen interest. You have an appetite to learn and embrace new ways of working in order to improve efficiencies and effectiveness.

Self-development (we care and dare)

You demonstrate enthusiasm by seeking new ways to grow and be challenged, through both formal and informal development opportunities.

Communicating Effectively (we are clear and authentic)

You openly listen to the ideas of others, seek regular feedback to develop, consider the best method for communicating and ask for support and advice when unsure.

Key Skills & Experience:

Essential

• Demonstrable Data Processing / Handling and Data Analysis skills.
• Professional experience in a Data Analyst role
• SQL Scripting, R, Python, Power BI, Advanced MS Excel.
• Cloud Based Data Platform (Azure, Databricks) Git and version control practices.
• High level of numerical and analytical skills.
• Strong root cause analysis and problem-solving skills, with the ability to investigate and resolve complex data issues effectively.

Desirable

• Understanding of Insurance / Reinsurance Business
• Demonstrable experience working with relational databases (Oracle, SQL etc)
• Knowledge of data science, including machine learning, statistical analysis, and AI tools.

Thought Leaders:

You will demonstrate inclusive behaviour and encourage your colleagues to play an active role in creating an inclusive culture as well.

You will treat your colleagues and sales and business partners fairly and with respect.

Regulatory & Conduct Requirements:

• Ensuring compliance with Munich Re’s Code of Conduct

At Munich Re, Diversity, Equity, and Inclusion foster innovation and resilience and enable us to act braver and better. Embracing the power of DEI is at the core of who we are. We recognise diversity can be multi-dimensional, intersectional, and complex, so we want to build a diverse workforce that includes a wide range of racial, ethnic, sexual, and gender identities; economic and geographic backgrounds; physical abilities; ages; life, school, and career experiences; and political, religious, and personal beliefs. Additionally, we are committed to building an equitable and inclusive work environment where this diversity is celebrated, valued, and has equitable opportunities to succeed.

All candidates in consideration for any role can request a reasonable adjustment at any point in our recruitment process. You can request an adjustment by speaking to your Talent Acquisition contact.