Data & Insights Analyst — Modern BI & Automation

MetLife UK; Brighton; On-site; GBP 45,000 - 65,000; Full time

Benefits offered by this job

9% employer pension contributions

Private medical insurance

Income protection insurance

Life insurance

Benefits allowance (£20/month)

Job summary

MetLife UK is seeking a Data and Insights Analyst to join our Data, MI & Automation team. You will shape reporting and insight delivery, automate manual processes, and transition reporting to modern, scalable BI solutions using Power BI, Power Platform and AI-enabled capabilities.

You will collaborate across the business, produce critical MI, and help govern data quality while driving continuous improvement in reporting and automation initiatives.

Qualifications

• Experience in MI, reporting or Business Intelligence, with the ability to deliver reporting accurately and to deadline with appropriate guidance.
• Strong Excel skills, with experience supporting spreadsheet-based reporting; exposure to legacy or macro/VBA-based reporting processes is advantageous.
• Working Power BI capability, including building reports and data models, writing DAX measures, and publishing to workspaces; willingness to develop further.
• Working knowledge of SQL, including the ability to query, join and validate data from multiple sources.
• Understanding of data governance principles, including issue management, documentation standards and controlled change.
• Good stakeholder and communication skills, with the ability to understand business needs and explain technical concepts clearly to non-technical audiences.

Responsibilities

• Produce and deliver accurate, timely recurring MI and business-critical reporting to stakeholders, including running and maintaining established legacy Excel and VBA-based reporting processes.
• Support the continuity and reliability of existing reporting while contributing to its progressive improvement and modernisation.
• Help assess manual and spreadsheet-based reporting to identify opportunities for automation, simplification 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 with recurring BAU delivery.
• Work with stakeholders across the business to understand reporting requirements, ask constructive questions, and help recommend solutions that improve decision-making and user-experience.
• Take an active role in data governance and quality control by raising, logging and investigating data issues and reconciliation discrepancies, and working with Data Governance, IT and Operations teams to help drive closure of data 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 self-service reporting capability by helping to create reusable, governed BI assets and assisting users in making effective use of Power BI and related tools.
• Bring forward practical ideas for process improvement and better use of data, and share knowledge and good practice with colleagues.

Skills

MI reporting

BI reporting

Excel

Power BI

Power Query

Power Automate

SQL

DAX measures

Data governance

stakeholder communication

Education

Degree in quantitative or business discipline

Tools

Power BI

Power Query

Power Automate

SQL

Job description

MetLife UK is seeking a Data and Insights Analyst to join our Data, MI & Automation team. You will shape reporting and insight delivery, automate manual processes, and transition reporting to modern, scalable BI solutions using Power BI, Power Platform and AI-enabled capabilities.

You will collaborate across the business, produce critical MI, and help govern data quality while driving continuous improvement in reporting and automation initiatives.