Finance Data Analyst

Royal London; Over Alderley; Hybrid; GBP 40,000 - 60,000; Full time

Job summary

A leading mutual life and pensions company in the UK seeks a Finance Data Analyst to join their Finance Systems and Development team. In this hybrid role, you will manage finance data models and reporting, enhance Power BI outputs, and streamline end-to-end finance system processes. The ideal candidate will possess strong skills in data modelling, Microsoft Power Platform, and SQL, with a clear aptitude for problem-solving and communication. Exceptional workplace benefits including annual leave and a pension scheme are offered.

Benefits

28 days annual leave

Up to 14% employer matching pension scheme

Private medical insurance

Qualifications

• Able to translate technical concepts for senior and non‑technical audiences.
• Proficient with SQL, Azure, and DAX.
• Experience improving controls and processes across finance systems.

Responsibilities

• Understand end‑to‑end Finance system processes.
• Manage and deliver changes to Power BI reports.
• Develop business-critical Finance reporting across Snowflake.

Skills

Communication

Problem-solving

Proficient with Microsoft Power Platform

Data modelling and engineering

SQL knowledge

Collaboration

Tools

Power BI

Power App

Snowflake

Job description

Job Title: Finance Data Analyst

Contract Type: Permanent

Location: Alderley Park

Working style: Hybrid - 50% home/office

Closing date: 27th January

Job summary

Join Group Finance within our Finance Systems and Development team, where we look after the accounting, transactional and banking systems, provide first‑line support to users, drive automation to remove manual processes, and ensure the smooth flow of data through our end‑to‑end architecture frigence we will help own and manage Group Finance Power BI requirements, finance data models and visualisation across Finance, delivered via our Snowflake data platform and Power BI/Power App tools.

About the role

• Understand end‑to‑end Finance system processes and data sources; identify opportunities to improve key processes and controls for effectiveness and efficiency.
• Manage and deliver small changes and defect fixes to Power BI reports and Power App workflows.
• Maintain, develop and govern business‑critical Group Finance reporting across Snowflake and other SQL‑based databases, Power BI and Power App.
• Translate future business and regulatory change requirements into system designs and specifications.
• Design and build robust finance data models within the strategic Snowflake platform to enable efficient querying and analysis.
• Build, test and iterate interactive dashboards and reports that visualise data and present actionable insights.
• Develop and maintain data integration and ETL pipelines, data warehousing and transformations within Snowflake and other SQL databases.

About you

• Able to translate technical concepts for senior and non‑technical audiences, with clear written and verbal communication.
• A clear‑thinking problem solver who can unravel complex issues, evaluate options and shape business hubo.
• Experience improving controls and processes across finance systems and data.
• Proficient with Microsoft Power Platform (Power BI Desktop, Power App), with strong data visualisation skills.
• Solid data modelling and engineering skills, particularly in SQL and Snowflake; comfortable with ETL and data warehousing.
• Working knowledge of SQL, Azure and DAX; familiarity with SDLC and modern change control processes (Waterfall, Agile).
• Collaborative, proactive and organised‑able to manage workload effectively and work well with business and technical teams.

About Royal London

We're the UK's largest mutual life, pensions and investment company, offering protection, long‑term savings and asset management products and services.

Our People Promise to our colleagues is that we will all work somewhere inclusive, responsible, enjoyable and filling. This is underpinned by our Spirit of Royal London values; Empowered, Trustworthy, Collaborate, Achieve. We've always been proud to reward employees by offering great workplace benefits such as 28 days annual leave in addition to bank holidays, up to 14% employer matching pension scheme and private medical insurance. You can see all our benefits here - Our Benefits

Inclusion, diversity and belonging

We're an inclusive employer. We celebrate and value different backgrounds and cultures across Royal London. Our diverse people and perspectives give us a range of skills which are recognised and respected - whatever their background.