Senior Data and Reporting Analyst

Metropolitan Thames Valley; Henfield; On-site; GBP 55,000 - 75,000; Full time

Benefits offered by this job

Pension 9%

Private medical

Income protection

Life insurance

Critical illness

Annual leave buy/sell

Benefits allowance

Job summary

MetLife UK is seeking a Senior Data and Reporting Analyst to join the Data, MI & Automation team. You will own critical MI, modernise reporting using Power BI and Power Platform, and automate manual processes. You will collaborate with stakeholders across the business and contribute to the evolution of our data capability.

You will engage in governance, data lineage, and quality controls, while delivering timely, reliable insights and enabling self-service reporting through governed BI assets.

Qualifications

• Proven experience in MI, reporting and BI with independent ownership of reporting.
• Advanced Excel skills; experience with legacy VBA-based reporting is advantageous.
• Strong Power BI capability, including complex reports, data models and DAX measures.
• Knowledge of Power Query and automating reporting/data prep processes.
• Working knowledge of SQL for multi-source data validation.
• Experience moving reports from manual to automated, governed solutions.
• Good understanding of reporting governance and data lineage.
• Strong stakeholder communication translating business needs to clear solutions.

Responsibilities

• Own, produce and deliver accurate recurring MI and business-critical reporting.
• Improve and modernise the reporting estate and automate processes.
• Build and maintain Power BI reports, datasets, and data models to enterprise standards.
• Automate data prep, refresh and report distribution using Power Query/Power Automate.
• Handle ad hoc data requests while balancing BAU delivery.
• Partner with stakeholders to understand requirements and propose solutions.
• Maintain documentation of report definitions, data sources and lineage.

Skills

MI/BI reporting

Power BI

Stakeholder management

Advanced Excel

SQL

Automation mindset

Education

Degree in quantitative or business discipline

Tools

Power Query

Power Automate

SQL

Job description

The OpportunityAs Senior Data and Reporting Analyst, you will join our Data, MI & Automation team at an exciting point in our transformation journey. As the business continues to grow and our data capabilities evolve, you will have the opportunity to influence how reporting and insight are delivered across the organisation.You will take ownership of established, business-critical Management Information while playing a key role in shaping its future. This includes challenging existing ways of working, simplifying and automating manual processes, and helping transition our reporting estate towards modern, scalable solutions using Power BI, Power Platform, and emerging data, AI & automation capabilities.Working within a collaborative team of eight and reporting directly to the Head of Data, MI & Automation, you will gain broad exposure across the business, including participation in our monthly Data Forum. You will have the opportunity to influence change, work closely with a range of stakeholders and contribute to the continued development of our wider data capability.This role is a great opportunity for someone who enjoys making things better, wants to develop their experience with modern reporting and automation tools, and is excited by the opportunity to help shape the future of reporting and insight within a growing business.

Key Responsibilities

• Own, produce and deliver accurate, timely recurring MI and business-critical reporting to stakeholders, including maintaining and running established legacy Excel and VBA-based reporting processes.
• Ensure the continuity and reliability of existing reporting while progressively improving and modernising the reporting estate.
• Proactively assess manual and spreadsheet-based reporting to identify opportunities for automation, simplification, rationalisation and migration to governed BI solutions, reducing manual effort and operational risk.
• Build, enhance and maintain Power BI reports, datasets and data models aligned with enterprise standards, with a focus on clear, effective and user-friendly reporting.
• Use Power Query and Power Automate, alongside appropriate reporting tools, to automate data preparation, refresh and report distribution where this delivers business value.
• Handle ad hoc reporting and data requests, translating business questions into appropriate reporting solutions and balancing these demands with recurring BAU delivery.
• Partner with stakeholders across the business to understand reporting requirements, challenge them constructively where appropriate, and recommend solutions that improve decision‑making and user experience.
• Design and implement robust quality controls and reconciliations, investigating data discrepancies and working with Data Governance, IT and Operations teams to resolve issues.
• Maintain clear documentation of report definitions, data sources, calculations, refresh schedules and source‑to‑report lineage, applying relevant data governance and metadata standards.
• Contribute to report rationalisation by identifying duplicate, redundant or low‑value reports and supporting their controlled retirement or consolidation.
• Support greater self‑service reporting capability by creating reusable, governed BI assets and helping users make effective use of Power BI and related tools.
• Continuously improve reporting processes and ways of working, bringing forward practical ideas for automation, efficiency and better use of data.
• Share knowledge and good practice with colleagues, supporting capability development across MI, BI and reporting activities.

Required Qualifications

• Proven experience in MI, reporting and Business Intelligence, with the ability to independently own and deliver business‑critical reporting.
• Advanced Excel skills, with experience supporting and improving complex spreadsheet‑based reporting; experience with legacy or macro/VBA‑based reporting processes is advantageous.
• Strong Power BI capability, including development of complex reports, data models and DAX measures, publishing to workspaces and managing refresh and distribution.
• Advanced working knowledge of Power Query and practical experience automating reporting or data preparation processes.
• Working knowledge of SQL, including the ability to query, join and validate data from multiple sources.
• Experience identifying and delivering reporting improvements, including migration from manual or spreadsheet‑based processes to more automated, governed solutions.
• Good understanding of reporting governance, including documentation, source‑to‑report lineage, naming standards and controlled change.
• Strong stakeholder management and communication skills, with the ability to translate business needs into clear reporting solutions and explain technical concepts to non‑technical audiences.
• Ability to prioritise effectively across recurring reporting commitments, transformation activity and ad hoc requests.
• Awareness of emerging AI capabilities relevant to data and reporting, with a proactive approach to identifying appropriate opportunities to apply AI across reporting and automation activities.

Preferred Qualifications

• 3-5+ years of relevant experience in BI, MI, reporting and analytics, with demonstrated end‑to‑end delivery of reports and dashboards.
• Degree in a quantitative or business discipline, or equivalent practical experience.
• Working knowledge of data warehousing, data platforms and source‑to‑report data flows.
• Experience with insurance or financial services data, including claims, policy administration or customer data.
• Experience supporting self‑service BI and coaching users on effective report consumption.
• Awareness of version control and controlled deployment practices for BI solutions.
• Confidence using AI‑assisted productivity tools responsibly for reporting and BI development, with appropriate validation of outputs.
• Experience with agile methodology.
• Experience with Power Automate.

Benefits We Offer

MetLife UK offers a range of benefits to deliver value to our employees and their families, supporting their health, wellbeing and financial security. Our flexible benefits offering provides freedom, choice, and flexibility in the way that you receive your benefits to better suit your lifestyle, meet some of your practical needs, and provide advantages in terms of tax and National Insurance savings.

• 9% employer pension contributions with up to 4% matching available
• comprehensive private medical insurance
• income protection insurance
• life insurance
• critical illness/dental/travel/gadget insurance
• annual leave buy/sell
• partner life insurance
• 20 benefits allowance per month to spend on any additional benefits they select

Our core benefits include 9% employer pension contributions with up to 4% matching available, comprehensive private medical insurance, income protection insurance, and life insurance.

We offer a host of additional benefits that you can choose to buy including critical illness/dental/travel/gadget insurance, annual leave buy/sell, partner life insurance and more.

All employees receive a 20 benefits allowance per month to spend on any additional benefits they select.

About MetLife

Recognized on Fortune magazine's list of the "World's Most Admired Companies" and Fortune World's 25 Best Workplaces, MetLife, through its subsidiaries and affiliates, is one of the world's leading financial services companies; providing insurance, annuities, employee benefits and asset management to individual and institutional customers. With operations in more than 40 markets, we hold leading positions in the United States, Latin America, Asia, Europe, and the Middle East. As part of our New Frontier strategy, MetLife is building an AI-enabled, people-centered future. We're looking for people who bring curiosity, adaptability, and a growth mindset as we use AI to enhance how we serve customers, support communities, and evolve the way work gets done. At MetLife, AI is a responsible partner that supports human judgment, creativity, and continuous improvement while helping us build trust, inclusion, and long-term value.

Our purpose is simple - to help our colleagues, customers, communities, and the world at large create a more confident future. United by purpose and guided by our core values - Win Together, Do the Right Thing, Deliver Impact Over Activity, and Think Ahead - we're inspired to transform the next century in financial services. At MetLife, it's #AllTogetherPossible. Join us!