Senior Business Intelligence Analyst

BCMGlobal; Ipswich; On-site; GBP 60,000 - 85,000; Full time

Benefits offered by this job

25 days holiday

Employer-matched pension (up to 5%)

Life assurance 4x salary

Private healthcare (role dependent)

Wellbeing day

Job summary

BCMGlobal is seeking a Senior Business Intelligence Analyst to join the Reporting function and deliver high-quality management information, dashboards and insights across Mortgage Services.

You'll combine strong BI skills with commercial thinking, stakeholder management, and Excel VBA automation to drive better decisions and outcomes.

Qualifications

• Experience in BI reporting or MI to deliver insights and dashboards.
• Ability to translate business needs into reporting specifications.
• Strong data quality and validation skills.

Responsibilities

• Own regular and ad-hoc reporting for daily, weekly, monthly and quarterly MI.
• Develop and enhance dashboards and automated reporting solutions.
• Analyse data to identify trends, variances, risks and opportunities.
• Monitor KPIs, SLAs and customer outcomes and report on them.
• Collaborate with stakeholders to gather requirements and translate into solutions.
• Validate data across systems and ensure accuracy and consistency.

Skills

Power BI

SQL Server

Excel

Excel VBA

Tools

Business Objects

SSRS

SSIS

Tableau

Qlik

Alteryx

VBA

Job description

BCMGlobal are looking for an experienced Business Intelligence professional who enjoys turning complex data into clear, meaningful insight.

We're looking for a Senior Business Intelligence Analyst to join our Reporting function and play a key role in delivering high-quality management information, dashboards and analytical insight across Mortgage Services.

This is an excellent opportunity for someone who combines strong technical BI skills with commercial thinking and stakeholder management. You'll work with colleagues across the business to understand what the data is telling us, identify trends and opportunities, and develop reporting solutions that support better, faster and more informed decisions. Candidates will need to be proficient in Excel VBA, with experience developing and maintaining macros to automate business processes and reporting.

What you'll be doing

You'll take ownership of regular and ad-hoc business reporting, producing accurate and timely daily, weekly, monthly and quarterly management information.

Using Power BI, SQL Server, Excel and other reporting tools, you'll develop and enhance dashboards, reports and automated reporting solutions that make complex information accessible and actionable.

You’ll also:

• Analyse operational and performance data to identify trends, variances, risks and opportunities
• Monitor and report on KPIs, SLAs and customer outcomes
• Work with stakeholders and clients to understand reporting requirements and translate them into effective solutions
• Validate and reconcile data across multiple systems, investigating data quality issues and ensuring reporting is accurate and consistent
• Identify opportunities to automate and improve reporting processes
• Support forecasting, capacity planning and operational performance modelling
• Provide analytical insight for projects, business change and process improvement initiatives
• Support regulatory, compliance and audit reporting
• Maintain robust reporting documentation, data definitions and controls
• Present complex information clearly to both technical and non-technical audiences
• Share your knowledge and provide guidance and support to junior colleagues

What we're looking for

You'll already have experience working within Business Intelligence, Data Analytics or Management Information, with a strong track record of producing reporting that helps businesses understand performance and make better decisions.

You’ll bring:

• Strong Power BI experience - building effective dashboards, reports and management information
• SQL / T-SQL knowledge - with confidence working with large and complex datasets
• Intermediate to advanced Excel skills - with the ability to manipulate, analyse and clearly present data
• Strong analytical thinking - able to move beyond reporting the numbers to explain what they mean and why they matter
• Excellent attention to detail - with a strong focus on data quality, accuracy and reporting controls
• Great stakeholder skills - comfortable gathering requirements, challenging constructively and explaining technical information in plain English
• A delivery-focused mindset - able to manage competing priorities and deadlines in a fast-paced, multi-client environment
• Even better if you have...
• Experience within mortgage servicing, banking, financial services or another regulated environment would be particularly valuable.
• Knowledge of the mortgage industry, FCA requirements and Consumer Duty principles would also be advantageous, as would experience with Business Objects, SSRS, SSIS, data warehouses, data governance, VBA, Tableau, Qlik or Alteryx.
• Experience in forecasting, capacity planning or operational performance improvement would be another plus.

Why this role?

This isn't simply a role producing reports.

You'll become a trusted analytical partner to teams across Mortgage Services, helping stakeholders understand performance, challenge assumptions and make evidence-based decisions.

You'll have the opportunity to improve how reporting is delivered, increase automation, strengthen data quality and controls, and create insight that has a genuine impact on operational and customer outcomes.

Why BCMGlobal?

At BCMGlobal, you'll have the opportunity to do more than report on performance - you'll help shape how we use data to make smarter decisions, improve our services and deliver better outcomes for our customers.

You'll join a collaborative environment where your ideas, expertise and insight are valued, with the opportunity to make a visible impact and help evolve our BI and reporting capability.

And we believe great work should come with great benefits:

• 25 days' holiday, with the option to buy more
• Employer-matched pension contributions of up to 5%
• Life assurance at 4x salary
• Private healthcare (role dependent)
• Dedicated wellbeing and volunteering day
• Sports & Social Club, including summer and Christmas events
• Employee recognition, referral and bonus schemes