Senior Business Intelligence Analyst

BCMGlobal; Ipswich; On-site; GBP 55,000 - 75,000; Full time

Benefits offered by this job

Holiday entitlement (25 days)

Pension contributions up to 5%

Life assurance 4x salary

Wellbeing day

Sports & Social Club

Job summary

BCMGlobal is seeking an experienced Senior Business Intelligence Analyst to drive high-quality management information, dashboards and analytical insight across Mortgage Services. You will own regular and ad-hoc reporting, develop dashboards with Power BI and SQL Server, and translate stakeholder needs into effective solutions.

The role emphasizes data quality, governance and automation to support better decisions.

Qualifications

• Experience in BI/Data Analytics or Management Information, with a track record of producing reporting that informs decisions.
• Strong Power BI experience – building dashboards, reports and MI.
• SQL/T-SQL proficiency with large and complex datasets.
• Intermediate to advanced Excel – data manipulation, analysis and presentation.
• Excellent attention to detail with data quality and reporting controls.
• Great stakeholder skills – gathering requirements and explaining technical info clearly.

Responsibilities

• Take ownership of regular and ad-hoc business reporting, providing accurate daily, weekly, monthly and quarterly MI.
• Develop and enhance dashboards, reports and automated reporting solutions using Power BI, SQL Server and Excel.
• Validate and reconcile data across multiple systems, investigate data quality issues and ensure reporting consistency.
• Identify opportunities to automate and improve reporting processes and support forecasting and capacity planning.
• Provide analytical insight for projects, business change and process improvement initiatives.
• Support regulatory, compliance and audit reporting and maintain clear reporting documentation.

Skills

Power BI

SQL/T-SQL

Excel

Analytical thinking

Data quality

Stakeholder management

Forecasting

Capacity planning

VBA

Tableau

Tools

Power BI

SQL Server

Excel

Tableau

Qlik

Alteryx

Business Objects

SSRS

SSIS

VBA

Data warehouses

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
• 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
• Dedicated wellbeing and volunteering day
• Sports & Social Club, including summer and Christmas events
• Employee recognition, referral and bonus schemes