Senior Data Analyst

MacGregor Black 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.

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

Highly Desirable

• Microsoft Power Platform exposure
• Azure Data & Integration Services experience
• 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

£50,000 - £55,000 per annum

For more information, please contact Scott McGowan.