Business Intelligence / Commercial Modelling Analyst

Michael Page; Lichfield; On-site; GBP 40,000 - 65,000; Full time

Job summary

Michael Page is seeking a commercially focused Business Performance / BI Analyst to deliver high-quality insight and performance reporting across a major UK infrastructure organisation. You will synthesize customer, revenue and commercial data into actionable recommendations for decision making.

You will interact with stakeholders across Finance, Operations, Marketing and Business Development, owning executive reporting, KPI analysis, forecasting and financial modelling while improving reporting

Qualifications

• Proven experience delivering executive-level reporting and KPIs.
• Experience turning large datasets into actionable insight.
• Strong Excel skills and attention to detail.
• Ability to explain complex analysis to senior stakeholders.
• Experience with SQL/Databricks and dashboarding tools.

Responsibilities

• Produce monthly, quarterly, and ad-hoc performance reporting with executive commentary.
• Maintain KPI reporting, identify trends and opportunities.
• Analyse customer segments, behaviour, frequency, retention and conversion.
• Lead traffic and revenue forecasting for budgets and reforecasts.
• Maintain financial models and perform scenario analysis.
• Partner with Finance, Operations, Marketing and Business Development.
• Develop Power BI dashboards and automate reporting processes.
• Perform data validation and investigate anomalies.

Skills

KPI analysis

Executive reporting

Power BI dashboards

SQL/Databricks

Advanced Excel

Stakeholder management

Financial modelling

Data validation

Forecasting

Data storytelling

Tools

SQL

Databricks

Power BI

Job description

This Major UK Infrastructure organisation is looking for a commercially focused and highly analytical Business Performance / Business Intelligence Analyst to deliver high-quality insight, business / commercial intelligence, analysis and performance reporting across the organisation. You will turn customer, revenue and commercial data into clear, actionable recommendations that support effective decision making.

Major UK Infrastructure organisation

Description

This Major UK Infrastructure organisation is looking for a commercially focused and highly analytical Business Performance / Business Intelligence Analyst to deliver high-quality insight, business / commercial intelligence, analysis and performance reporting across the organisation. You will turn customer, revenue and commercial data into clear, actionable recommendations that support effective decision making.

You will regularly interact with stakeholders across Finance, Operations, Marketing and Business Development. You will take ownership of executive reporting, KPI analysis, forecasting and financial modelling, while helping to improve reporting processes, data quality and analytical capability.

Key Responsibilities

• Produce monthly, quarterly and ad-hoc performance reporting, including clear executive-level commentary.
• Maintain and enhance KPI reporting, identifying trends, risks and opportunities affecting business performance.
• Analyse customer segments, behaviour, frequency, retention and conversion, as well as marketing and commercial initiatives.
• Lead the development of traffic and revenue forecasts for annual budgets and periodic reforecasts.
• Maintain financial models and produce scenario and sensitivity analysis to quantify potential impacts.
• Act as an analytical partner to colleagues across Finance, Operations, Marketing and Business Development.
• Develop Power BI dashboards, improve reporting processes and identify opportunities to automate routine activity.
• Complete data validation, reconciliation and quality assurance, investigating anomalies and root causes.

Key Skills & Experience

• Proven experience in analytical, business performance, commercial insight or strategy role.
• Experience producing executive-level reporting and performance commentary.
• Strong capability with large datasets and a track record of identifying actionable insights.
• Advanced Microsoft Excel skills, strong problem-solving ability and excellent attention to detail.
• The ability to explain complex analysis clearly and confidently to senior stakeholders.
• Strong stakeholder management, business partnering and prioritisation skills.
• Experience within transport, infrastructure, customer-facing or regulated industries.
• Knowledge of customer lifecycle, retention, customer value or marketing ROI methodologies.
• Experience using SQL, Databricks or a similar development platform.
• Experience developing dashboards in Power BI or a similar tool.
• Experience improving or automating reporting processes.

Profile

• Proven experience in analytical, business performance, commercial insight or strategy role.
• Experience producing executive-level reporting and performance commentary.
• Strong capability with large datasets and a track record of identifying actionable insights.
• Advanced Microsoft Excel skills, strong problem-solving ability and excellent attention to detail.
• The ability to explain complex analysis clearly and confidently to senior stakeholders.
• Strong stakeholder management, business partnering and prioritisation skills.
• Experience within transport, infrastructure, customer-facing or regulated industries.
• Knowledge of customer lifecycle, retention, customer value or marketing ROI methodologies.
• Experience using SQL, Databricks or a similar development platform.
• Experience developing dashboards in Power BI or a similar tool.
• Experience improving or automating reporting processes.

Job Offer

Opportunity to join a major UK infrastructure organisation

Opportunity to enhance Business Intelligence across multiple functions

Client Details

This Major UK Infrastructure organisation is looking for a commercially focused and highly analytical Business Performance / Business Intelligence Analyst to deliver high-quality insight, business / commercial intelligence, analysis and performance reporting across the organisation. You will turn customer, revenue and commercial data into clear, actionable recommendations that support effective decision making.

You will regularly interact with stakeholders across Finance, Operations, Marketing and Business Development. You will take ownership of executive reporting, KPI analysis, forecasting and financial modelling, while helping to improve reporting processes, data quality and analytical capability.

Key Responsibilities

• Produce monthly, quarterly and ad-hoc performance reporting, including clear executive-level commentary.
• Maintain and enhance KPI reporting, identifying trends, risks and opportunities affecting business performance.
• Analyse customer segments, behaviour, frequency, retention and conversion, as well as marketing and commercial initiatives.
• Lead the development of traffic and revenue forecasts for annual budgets and periodic reforecasts.
• Maintain financial models and produce scenario and sensitivity analysis to quantify potential impacts.
• Act as an analytical partner to colleagues across Finance, Operations, Marketing and Business Development.
• Develop Power BI dashboards, improve reporting processes and identify opportunities to automate routine activity.
• Complete data validation, reconciliation and quality assurance, investigating anomalies and root causes.

Key Skills & Experience

• Proven experience in analytical, business performance, commercial insight or strategy role.
• Experience producing executive-level reporting and performance commentary.
• Strong capability with large datasets and a track record of identifying actionable insights.
• Advanced Microsoft Excel skills, strong problem-solving ability and excellent attention to detail.
• The ability to explain complex analysis clearly and confidently to senior stakeholders.
• Strong stakeholder management, business partnering and prioritisation skills.
• Experience within transport, infrastructure, customer-facing or regulated industries.
• Knowledge of customer lifecycle, retention, customer value or marketing ROI methodologies.
• Experience using SQL, Databricks or a similar development platform.
• Experience developing dashboards in Power BI or a similar tool.
• Experience improving or automating reporting processes.

Profile

• Proven experience in analytical, business performance, commercial insight or strategy role.
• Experience producing executive-level reporting and performance commentary.
• Strong capability with large datasets and a track record of identifying actionable insights.
• Advanced Microsoft Excel skills, strong problem-solving ability and excellent attention to detail.
• The ability to explain complex analysis clearly and confidently to senior stakeholders.
• Strong stakeholder management, business partnering and prioritisation skills.
• Experience within transport, infrastructure, customer-facing or regulated industries.
• Knowledge of customer lifecycle, retention, customer value or marketing ROI methodologies.
• Experience using SQL, Databricks or a similar development platform.
• Experience developing dashboards in Power BI or a similar tool.
• Experience improving or automating reporting processes.

Job Offer

Opportunity to join a major UK infrastructure organisation

Opportunity to enhance Business Intelligence across multiple functions

Desired Skills and Experience

This Major UK Infrastructure organisation is looking for a commercially focused and highly analytical Business Performance / Business Intelligence Analyst to deliver high-quality insight, business / commercial intelligence, analysis and performance reporting across the organisation. You will turn customer, revenue and commercial data into clear, actionable recommendations that support effective decision making.

You will regularly interact with stakeholders across Finance, Operations, Marketing and Business Development. You will take ownership of executive reporting, KPI analysis, forecasting and financial modelling, while helping to improve reporting processes, data quality and analytical capability.

Key Responsibilities:

Produce monthly, quarterly and ad-hoc performance reporting, including clear executive-level commentary.

Maintain and enhance KPI reporting, identifying trends, risks and opportunities affecting business performance.

Analyse customer segments, behaviour, frequency, retention and conversion, as well as marketing and commercial initiatives.

Lead the development of traffic and revenue forecasts for annual budgets and periodic reforecasts.

Maintain financial models and produce scenario and sensitivity analysis to quantify potential impacts.

Act as an analytical partner to colleagues across Finance, Operations, Marketing and Business Development.

Develop Power BI dashboards, improve reporting processes and identify opportunities to automate routine activity.

Complete data validation, reconciliation and quality assurance, investigating anomalies and root causes.

Key Skills & Experience:

Proven experience in analytical, business performance, commercial insight or strategy role.

Experience producing executive-level reporting and performance commentary.

Strong capability with large datasets and a track record of identifying actionable insights.

Advanced Microsoft Excel skills, strong problem-solving ability and excellent attention to detail.

The ability to explain complex analysis clearly and confidently to senior stakeholders.

Strong stakeholder management, business partnering and prioritisation skills.

Experience within transport, infrastructure, customer-facing or regulated industries.

Knowledge of customer lifecycle, retention, customer value or marketing ROI methodologies.

Experience using SQL, Databricks or a similar development platform.

Experience developing dashboards in Power BI or a similar tool.

Experience improving or automating reporting processes.