Data Analyst

Munich Re; City Of London; On-site; GBP 30,000 - 50,000; Full time

Job summary

A global reinsurer is looking for a Data Management Analyst in London. This role involves working with data analysis and reporting for valuation portfolio data, requiring strong SQL and analytical skills. A commitment to diversity and an inclusive work environment is emphasized. The position offers a competitive package including annual leave and medical benefits.

Benefits

25 days annual leave

Private medical insurance

Employers' contributory pension of 10%

Fully paid 6 months family leave

Qualifications

• Strong organisational skills with ability to manage multiple responsibilities.
• Communicates effectively and approaches challenges with solution-focused mindset.

Responsibilities

• Ensure data updates and delivery of LH1 Valuation Data.
• Data cleansing and profiling of Valuation portfolio data.
• Support internal clients with ad-hoc reporting.
• Gather and document detailed requirements for data.

Skills

Data Processing / Handling

Data Analysis

SQL Scripting

R

Python

Power BI

Advanced MS Excel

Numerical and Analytical Skills

Education

A Level in Computer Science

Degree in Computer Science or Data Analytics

Tools

Oracle

SQL

Job description

About UK Life Branch

With the office in London, 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

• Data cleansing, profiling, mapping and mining of Valuation portfolio data.
• Support and deliver multiple 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 processes and/or tools used in the team about the Valuation portfolio delivery.
• Determine, monitor and reporting the availability, quality and consistency of client data used in Valuation Portfolio deliveries.
• Liaison with internal clients to understand data content to maximise the benefits to the business, uncovering possible weaknesses and working for their correction.
• Gather, understand and document detailed requirements for data using appropriate tools and techniques, and ensure these are agreed at all levels throughout the business.
• Manage own work priorities; work in a organised way.
• Ensure data used in different work streams are of good quality and up to date.
• Working independently or together with colleagues.
• Produce quality written and numerical material appropriate to purpose.

Business Capabilities and Skills

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

• Data Processing / Handling and Data Analysis skills.
• SQL Scripting, R, Python, Power BI, Advanced MS Excel (can perform complex functions).
• High level of numerical and analytical skills.
• Can investigate data issues, apply cost benefit analysis and resolve.
• Remote working set-up.
• Understanding of Insurance / Reinsurance Business
• Experience working with relational databases (Oracle, SQL etc)

Personal Attributes

• Communicates clearly and effectively, and approaches challenges with a solution-focused mindset
• Can take responsibility for delivery of client requirements
• Demonstrates strong organisational skills, with the ability to manage multiple responsibilities and adapt priorities to meet evolving needs.
• A Level Computer Science / Computing / Mathematics / Business Studies (or related subject or relevant equivalent).
• Qualified or working towards a degree / apprenticeship in Computer Science / Data Analyst (or relevant equivalent).

You will be rewarded with a great compensation package, on target bonus, 25 days annual leave with the option to purchase more along with private medical insurance and employers\' contributory pension of 10%. We are one of the few employers to offer fully paid 6months family leave for times when you need it the most.

Diversity, Equity & Inclusion

At Munich Re, embracing the power of differences is at the core of who we are. We believe diversity fosters resilience and innovation and enables us to act on our purpose of helping humankind act braver and better. 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.

If you are excited about this role but your experience does not align perfectly with everything outlined, or you don’t meet every requirement, we encourage you to apply anyway. You might just be the candidate we are looking for!

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.

You will demonstrate and role model 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.