Senior Data Analyst

MacGregor Black; Northampton; On-site; GBP 60,000 - 85,000; Full time

Job summary

MacGregor Black is seeking a Senior Data Analyst to join a growing Data Engineering and Analytics function in the UK. You will design and maintain dashboards, build scalable data models, and automate reporting to enhance decision-making and operational efficiency.

Ideal candidate has strong BI tooling experience (Power BI, Oracle Analytics Cloud, or Business Objects), solid SQL skills, and a business-focused mindset to drive data-led improvements across multiple stakeholders.

Qualifications

• Proven experience in a data analytics role.
• Strong ability to build dashboards, reports and data models using modern BI tools.
• Experience with Power BI, Oracle Analytics Cloud or Business Objects.
• Strong SQL capability across SQL Server or Oracle.
• Experience supporting operational and commercial reporting environments.
• Ability to manage multiple priorities in fast-paced environments.

Responsibilities

• Design, develop and maintain dashboards, reports and outputs; translate data into commercial and operational insight.
• Conduct in-depth analysis to identify trends, risks and opportunities.
• Design and maintain scalable data models and reporting pipelines; integrate data from multiple sources.
• Develop and automate recurring reports and workflows using SQL, Python and automation tools.
• Support continuous improvement across reporting, data quality and automation.

Skills

Power BI

SQL

Python

Data Modelling

Dashboards

Stakeholder Engagement

Tools

Oracle Analytics Cloud

Business Objects

Power Platform

Job description

We are partnering with a leading UK business to appoint an experienced Senior Data Analyst to join a growing Data Engineering and Analytics function.

This role will play a key part in enhancing business decision-making, operational efficiency, and reporting capability across the organisation through the development of scalable data models, dashboards, reporting solutions, and automation.

The successful individual will combine strong technical capability with a practical, business focused approach, helping the organisation improve visibility, streamline reporting processes, and drive more effective data-led decision making.

This is a hands-on role suited to someone comfortable working across reporting, analytics, data engineering, stakeholder engagement, and continuous improvement.

The Opportunity

• Join a business investing heavily in data, reporting, and analytics capability


• Play a visible role within a growing Data Engineering function


• Drive meaningful improvements across reporting, automation, and operational insight


• Work across multiple business areas influencing data-led decision making


• Opportunity to help shape and improve the organisation’s analytics capability

Role Responsibilities

Data Analytics & Business Insight

• Design, develop, and maintain dashboards, reports, and analytical outputs across the business Translate complex data into meaningful commercial and operational insight


• Conduct in-depth analysis to identify trends, risks, anomalies, and improvement opportunities


• Support stakeholders with self-service reporting and analytical capability Data Engineering & Automation


• Design and maintain scalable data models and reporting pipelines · Integrate and prepare data from multiple systems and sources


• Develop and automate recurring reports and workflows using SQL, Python, and automation tools


• Support continuous improvement across reporting, data quality, and automation capability

Data Governance & Quality

• Ensure accuracy, consistency, and integrity of reporting outputs


• Support data cleansing, reconciliation, and governance processes


• Maintain documentation across reporting structures, models, and analytical processes

Stakeholder Engagement

• Work closely with operational, commercial, and technical stakeholders across the business


• Translate business requirements into reporting and analytical solutions


• Support adoption of data-led decision making across the organisation

Candidate Profile Experience

Experience

• Proven experience within a Data Analyst or data-focused analytical role


• Strong experience building dashboards, reports, and data models using modern BI tools


• Experience working with Power BI, Oracle Analytics Cloud, or Business Objects


• Strong SQL capability across Microsoft SQL Server or Oracle environments


• Experience supporting operational and commercial reporting environments


• Ability to manage multiple priorities within fast-paced business environments

Skillset

• Advanced Power BI and Excel capability


• Strong SQL and data modelling expertise


• Experience with reporting automation and workflow tools


• Analytical mindset with strong problem-solving capability
  
• Ability to communicate technical information to non-technical stakeholders


• Strong organisational and documentation skills

Highly Desirable

• Microsoft Power Platform exposure


• Oracle Integration Cloud (OIC) or Oracle Data Integrator (ODI) exposure


• Experience with Python and reporting automation


• Data or BI certifications


• Experience within operational, manufacturing, supply chain, or FMCG environments

Mindset

• Commercially aware and insight-driven


• Hands-on and delivery-focused


• Curious and continuously improving


• Collaborative with strong stakeholder engagement skills


• Comfortable operating across both technical and business teams

Why Join?

This is an opportunity to join a business continuing to evolve its data and analytics capability where you can:

• Influence how data is used across the organisation


• Drive meaningful reporting and operational improvements


• Work across modern BI, reporting, and automation technologies


• Be part of a collaborative and growing analytics function


• Play a visible role in supporting business-wide decision making

For more information, please contact Scott McGowan.