Senior Data Analyst

Company: MacGregor Black
Apply for the Senior Data Analyst
Location: Northamptonshire
Job Description:

Are you passionate about turning complex data into actionable insight that drives better commercial and operational decisions?

Do you enjoy building scalable dashboards, automating reporting, and improving data visibility across a fast-paced business?

Ready to combine Power BI, SQL, and analytics expertise to make a measurable impact within a growing data function?

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

Salary £50,000 – £55,000 per annum.

For more information, please contact Scott McGowan.

Posted: June 15th, 2026