Business Data Analyst (Migrations)

Royal London Group; Alderley Edge; Hybrid; GBP 45,000 - 65,000; Full time

Benefits offered by this job

28 days annual leave

Employer pension up to 14%

Private medical insurance

Job summary

Royal London is seeking a Business Data Analyst to join the Group Data and AI Office, a hybrid role based in Edinburgh, Glasgow, or Alderley Park. You will support data change initiatives by collecting, mapping and analysing data, collaborating with source system SMEs and business teams to understand data structures and deliver actionable insights.

You will translate findings into clear requirements, support data quality assessments, and work across business and technical colleagues to ensure

Qualifications

• Experience as a Business Data Analyst or similar in financial services or regulated environments.
• Ability to interrogate data, map requirements and provide pragmatic recommendations.
• Experience gathering and documenting requirements, data mappings or business processes.
• Awareness of Agile ways of working and software development lifecycle.
• Understanding of data governance, data quality and data lineage.

Responsibilities

• Provide analysis on data and business change topics to inform decisions.
• Support source-to-target data mapping, data dictionaries and data modelling.
• Collaborate with Data Engineering, SMEs and project teams to understand data structures and mappings.
• Evaluate processes and identify data-driven improvements and opportunities.
• Document requirements and mappings to support delivery teams and communicate findings clearly.

Skills

Microsoft Excel

SQL

Power BI

Tableau

Azure Synapse

Databricks

Tools

Microsoft Excel

SQL

Power BI

Tableau

Azure Synapse

Databricks

Job description

Job Title: Business Data Analyst (Migrations)

Contract Type: Permanent

Location: Edinburgh or Glasgow or Alderley Park (Wilmslow)

Working style: Hybrid 50% home/office based

We have a fantastic opportunity for a Business Data Analyst to join our Group Data and AI Office (GDAIO) Team at Royal London. This role is suited to candidates who have practical experience working with data, requirements and business stakeholders, and who are looking to develop their career within a supportive data change environment. You will bring strong analytical thinking, curiosity, attention to detail and a collaborative approach to helping teams understand and use data effectively.

The Business Data Analyst will support the delivery of high-quality analysis across data change initiatives. You will help collect, map, analyse and document information and requirements, working with source system SMEs, business teams and data colleagues to understand data structures, data dictionaries and source-to-target mappings. The role will involve supporting value-chain mapping of data, interpreting relevant performance and financial information, and helping create reusable documentation artefacts that support delivery by engineering and project teams.

Working closely with Data Engineering teams, Business SMEs and project colleagues, the Business Data Analyst will analyse data systems, translate findings into clear requirements and support project teams through discovery, impact assessment, data sourcing, migration and delivery activity. This is a hands-on analysis role where you will be encouraged to build your knowledge of Royal London’s data landscape, contribute to good analytical practice and develop confidence in working across both business and technical teams.

About the role:

• Provide analysis on a range of data and business change topics, helping teams make well-evidenced decisions
• Support source-to-target data mapping, data optimisation, sequencing and phasing of data sourcing to the Enterprise Data Model
• Work with business and technical colleagues to understand data structures, data dictionaries, requirements and mappings
• Evaluate business processes and help identify opportunities for improvement using data and insight
• Document requirements, source-to-target mappings, business data dictionaries and technical data dictionaries to support delivery teams
• Communicate analysis findings clearly to project teams, business SMEs and management, adapting your approach for technical and non-technical audiences
• Support data quality assessments, impact assessments, migrations and improvement initiatives, helping teams understand data impacts, risks and dependencies
• Perform user acceptance testing and support the monitoring of deliverables to help ensure timely completion of project activity
• Contribute to a culture of accountability, continuous improvement and effective governance across analysis activities
• Reflect Royal London values through positive behaviours, collaboration and taking ownership of your own development

About you:

• Experience as a Business Data Analyst, Data Analyst or similar role, ideally within financial services, a regulated environment or a complex organisation
• Practical understanding of what it means to be data-driven in decision making, with the ability to interrogate data and make pragmatic recommendations
• Experience working with stakeholders to gather, analyse and document requirements, data mappings or business process information
• Awareness of Agile ways of working and the software development lifecycle
• Understanding of data lifecycle management, data governance and the importance of data quality, accuracy and traceability
• Competence in at least two relevant tools or techniques, such as Microsoft Excel, SQL, Power BI, Tableau, Azure Synapse or Databricks
• Strong numerical, analytical reasoning and problem-solving skills, with good attention to detail
• Good written and verbal communication skills, with the ability to explain analysis clearly to both technical and non-technical colleagues
• Good organisational skills, including the ability to manage your own workload, focus on priorities and support delivery to agreed dates
• Collaborative stakeholder skills, with the ability to listen effectively, ask constructive questions and build positive working relationships across teams

We are particularly interested in hearing from analytical, curious and collaborative data professionals who want to develop their career in a business data analysis role. If you have experience working with data, requirements and stakeholders, and are excited by the opportunity to support meaningful data change at Royal London, we’d love to hear from you. Financial services, migration or platform experience would be helpful, but is not essential.

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 Promiseto our colleagues is that we will all work somewhere inclusive, responsible, enjoyable and fulfilling. 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, an 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, experiences and perspectives across Royal London. We’re committed to building a workplace where everyone feels respected, supported and able to contribute, whatever their background.