Senior Data Analyst

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

Job summary

MacGregor Black is partnering with a leading UK business to appoint an experienced Senior Data Analyst to join a growing Data Engineering and Analytics function. This hands-on role focuses on developing scalable data models, dashboards, reporting solutions, and automation to improve decision making and operational efficiency.

You will work across reporting, analytics, data engineering, and stakeholder engagement to deliver self‑service capabilities and data governance.

Qualifications

• Proven data analytics experience with BI dashboards.
• Experience with Power BI, Oracle Analytics Cloud, or Business Objects.
• Strong SQL skills across Microsoft SQL Server or Oracle.
• Automation and data modeling experience.
• Excellent stakeholder engagement and communication.

Responsibilities

• Design, develop, and maintain dashboards and reports to translate data into insights.
• Build scalable data models and reporting pipelines across systems.
• Automate recurring reports and workflows using SQL, Python, and automation tools.
• Collaborate with stakeholders to deliver self-service analytics.
• Ensure data quality, governance, and documentation across outputs.

Skills

Power BI

SQL

Python

Data modeling

Excel advanced

Stakeholder engagement

Education

Bachelor's degree in a related field

Tools

Oracle Analytics Cloud

Business Objects

ODI / Oracle Data Integrator

Oracle Integration Cloud

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

Key Responsibilities:

• 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
• Ensure accuracy, consistency, and integrity of reporting outputs
• Support data cleansing, reconciliation, and governance processes
• Maintain documentation across reporting structures, models, and analytical processes
• 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

What We're Looking For:

• 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
• 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
• 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
• 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.