Financial Data Analyst

Mackie Myers Ltd; Cambridgeshire and Peterborough; Hybrid; GBP 40,000 - 45,000; Full time

Benefits offered by this job

Discretionary bonus

Hybrid working

Private medical

Critical illness

Income protection

Life assurance

Professional training

Career progression

Sabbaticals

Job summary

Mackie Myers Ltd is seeking a commercially minded Financial Data Analyst to join our Finance and Operations team in the United Kingdom. The role is business facing, acting as the data partner to Finance to transform complex information into insights that drive decision-making across the organisation.

You'll work across financial, operational and people data to develop scalable reporting solutions, improve forecasting and support senior leadership with data storytelling and KPI analytics.

Qualifications

• 2-3 years' experience in data analytics within a finance, commercial or FP&A environment
• Strong Power BI experience, including dashboard and report development
• Understanding of financial analysis, KPIs and performance measurement
• Experience with data cleansing, validation and quality assurance
• Knowledge of data governance, security and privacy best practices
• Excellent communication and stakeholder management skills
• Strong data storytelling capabilities, able to communicate with both finance and non-finance audiences
• Experience documenting data sources, methodologies and reporting processes
• Excellent organisational and prioritisation skills

Responsibilities

• Analyse financial and operational performance to identify trends, risks and opportunities
• Define, track and continuously improve KPIs and financial metrics
• Translate business needs into meaningful analytics and reporting solutions
• Present insights through clear data storytelling and impactful visualisations
• Support forecasting, budgeting and scenario modelling with robust analysis
• Design, develop and maintain engaging Power BI dashboards and reports
• Create scalable reporting solutions that support business decisions
• Build and optimise data models to improve reporting accuracy and performance
• Automate reporting processes and improve data accessibility
• Consolidate data from multiple systems and ERP platforms, including API integrations
• Develop a single source of truth for consistent and scalable reporting
• Improve data governance, quality, security and reporting standards
• Streamline processes through automation and optimisation
• Utilise advanced Excel tools including Power Query, Power Pivot and VBA
• Apply programming skills such as Python to automate workflows and deepen analysis
• Explore emerging technologies, including AI-driven automation and intelligent workflows, to enhance efficiency and business insight

Skills

Data analytics

Data storytelling

Stakeholder management

Education

Degree in quantitative field

Tools

Power Query

Power Pivot

VBA

Python

APIs

Job description

• Utilise advanced Excel tools including Power Query, Power Pivot and VBA
• Programming skills such as Python to automate workflows and deepen analysis
• Including AI driven automation and intelligent workflows to enhance efficiency

We're looking for a commercially minded and technically strong Financial Data Analyst to join a growing Finance and Operations team.

This is a business facing role where you'll act as the trusted data partner to Finance, helping transform complex information into meaningful insights that drive decision-making across the organisation. You'll have the opportunity to influence strategy, improve performance, and develop scalable reporting solutions that support senior leadership.

Working across financial, operational and people data, you'll play a key role in creating a reliable, data-driven environment that enhances forecasting, planning and business performance.

Key Responsibilities Analytics & Insights

• Analyse financial and operational performance to identify trends, risks and opportunities
• Define, track and continuously improve KPIs and financial metrics
• Translate business needs into meaningful analytics and reporting solutions
• Present insights through clear data storytelling and impactful visualisations
• Support forecasting, budgeting and scenario modelling with robust analysis

Reporting & Business Intelligence

• Design, develop and maintain engaging Power BI dashboards and reports
• Create scalable reporting solutions that support business decisions
• Build and optimise data models to improve reporting accuracy and performance
• Automate reporting processes and improve data accessibility

Data Management & Process Improvement

• Consolidate data from multiple systems and ERP platforms, including API integrations
• Develop a single source of truth for consistent and scalable reporting
• Improve data governance, quality, security and reporting standards
• Streamline processes through automation and optimisation

Technology & Innovation

• Utilise advanced Excel tools including Power Query, Power Pivot and VBA
• Apply programming skills such as Python to automate workflows and deepen analysis
• Explore emerging technologies, including AI-driven automation and intelligent workflows, to enhance efficiency and business insight

About You Essential Requirements

• Degree (minimum 2:1 or equivalent) in a quantitative discipline such as Mathematics, Statistics, Finance, Data Science, Computer Science or a related field
• 2-3 years' experience in data analytics within a finance, commercial or FP&A environment
• Strong Power BI experience, including dashboard and report development
• Understanding of financial analysis, KPIs and performance measurement
• Experience with data cleansing, validation and quality assurance
• Knowledge of data governance, security and privacy best practices
• Excellent communication and stakeholder management skills
• Strong data storytelling capabilities, able to communicate with both finance and non-finance audiences
• Experience documenting data sources, methodologies and reporting processes
• Excellent organisational and prioritisation skills

Desirable Experience

• Python or similar programming language for advanced analytics and automation
• SQL for data extraction and transformation
• Advanced Excel capabilities including Power Query and Power Pivot
• FP&A experience covering budgeting, forecasting and scenario modelling
• Experience building scalable data models and analytical frameworks
• Report automation and dashboard optimisation experience
• Professional services or consulting background

What We Offer Alongside a collaborative and high-performing culture, we offer:

• Competitive salary of £40,000-£45,000 per annum
• Discretionary profit share bonus paid twice annually
• 25 days annual leave plus bank holidays
• Holiday buy and sell scheme
• Hybrid and flexible working arrangements
• Private Medical Insurance
• Critical Illness Cover
• Income Protection and Life Assurance
• Funded professional qualifications and external training
• Flexible benefits package
• Opportunities for career progression within a growing international business
• Sabbatical opportunities based on length of service

Working Arrangement Following successful completion of probation, employees can work from home for up to 50% of their working time, measured across a two week period. During probation, homeworking is typically available one day per week.