Senior MI & Reporting Consultant

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 dataled 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 nontechnical 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 detailfocused 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 signoff.
• 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 testandlearn measurement) to help teams optimise activity and spend.
• Ensure marketing data and reports are accurate consistent and fit for purpose promoting a strong dataled culture.

About Royal London

Were the UKs largest mutual life pensions and investment company offering protection long-term savings and asset management products and services.

OurPeople 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.

Weve 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

Were anInclusiveemployer. 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.