Senior Data Analyst (SQL, Power BI) in Brighton

As 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. 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.
• 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.
• Ability to prioritise effectively across recurring reporting commitments, transformation activity and ad hoc requests.
• Aware 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.
• 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.
• Aware 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. 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. 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.