Business Intelligence/Commercial Modelling Analyst

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

Job summary

Major UK Infrastructure organisation seeks a commercially focused Business Performance/BI Analyst to deliver high-quality insight, 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.

Qualifications

• 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 attention to detail.
• Ability to explain complex analysis clearly to senior stakeholders.
• Strong stakeholder management and cross-functional partnering.
• Experience in transport, infrastructure or regulated sectors is advantageous.
• Knowledge of customer lifecycle, retention or marketing ROI methodologies.
• Experience using SQL, Databricks or similar platforms and creating dashboards in Power BI.

Responsibilities

• Produce monthly, quarterly and ad-hoc performance reporting with executive commentary.
• Maintain and enhance KPI reporting, identify trends, risks and opportunities.
• Analyse customer segments, behavior, retention and marketing initiatives.
• Lead traffic and revenue forecast development for budgets and reforecasts.
• Maintain financial models and run scenario and sensitivity analyses.
• Partner with Finance, Operations, Marketing and Business Development to drive insights.
• Develop Power BI dashboards; improve reporting processes and automate routines.
• Perform data validation, reconciliation and quality assurance; investigate anomalies.

Skills

Analytical experience

Executive reporting

Large datasets

Excel skills

Stakeholder communication

Stakeholder management

Infrastructure experience

Customer lifecycle

Marketing ROI

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.

Client Details

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 life cycle, 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 life cycle, 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