Job Title: Senior MI & Reporting Consultant
Location: Alderley Park or Edinburgh
Working style: Hybrid 50% home/office based
Contract: 12-month fixed-term contract
Role overview
This role is focused on building and owning the marketing MI, reporting, analytics and insight capability across the Brand and Marketing function. You will design, create and manage Power BI dashboards and data reports, using SQL and Databricks / Microsoft Fabric to enable data‑led decision making, clear measurement of campaign and channel effectiveness, and strong governance over marketing reporting and data assets (KPIs, definitions and reporting standards).
About you
* Proven experience creating and owning Power BI dashboards and data reports, with the ability to turn complex data into clear insight for non‑technical stakeholders.
* Strong SQL capability and experience working with large datasets, ideally within Databricks / Microsoft Fabric or similar data platforms.
* Solid background in MI, reporting and analytics, including managing reporting standards and ensuring data quality and consistency.
* Experience applying marketing analytics to real business questions (e.g., channel performance, customer journey/funnel metrics, segmentation, and campaign measurement), with a pragmatic approach to defining and improving KPIs.
* Highly analytical, detail‑focused and comfortable integrating data from multiple sources to identify trends and opportunities.
* Confident communicator with experience working across marketing teams and regulated environments such as financial services.
About the role
* Design, create and manage Power BI dashboards and reports to support Brand and Marketing MI and performance reporting.
* Use SQL and Databricks / Microsoft Fabric to extract, transform and analyse data supporting marketing performance, campaign insight and marketing analytics.
* Own and manage reporting assets and governance, including creation, documentation, quality control and stakeholder sign‑off.
* Develop campaign and marketing effectiveness reporting that supports better decisions on activity, spend and optimisation.
* Develop and embed marketing analytics approaches (e.g., funnel and customer journey reporting, channel performance and ROI, segmentation, and test‑and‑learn measurement) to help teams optimise activity and spend.
* Ensure marketing data and reports are accurate, consistent and fit for purpose, promoting a strong data‑led culture.
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 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.
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.