Financial Data Analyst

Mackie Myers Ltd; Little Cambridge; Hybrid; GBP 40,000 - 45,000; Full time

Benefits offered by this job

Private Medical Insurance

Profit sharing bonus

Hybrid working

25 days annual leave

Training & development

Job summary

Mackie Myers Ltd is seeking a commercially minded Financial Data Analyst to join our growing Finance and Operations team in the UK. You will partner with Finance to transform complex data into actionable insights, influence strategy, and develop scalable reporting solutions that support senior leadership.

The role covers analytics across financial, operational and people data, with responsibilities from KPI development to forecasting, budgeting and scenario modelling.

Qualifications

• Degree (2:1 or equivalent) in a quantitative discipline such as Mathematics, Statistics, Finance, Data Science or 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

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

Power BI

Python

Excel (Power Query/Power Pivot/VBA)

Data storytelling

Education

Degree in a quantitative field (2:1)

Tools

SQL

ERP integrations

Job description

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.