Senior Data Analyst

Insight & Reporting Analyst

Location: Birmingham (office-based 5 days per week for the first 3–6 months)

We’re supporting a long-established UK business that is enhancing its data and reporting capability.

They’re looking for a hands-on Insight & Reporting Analyst to take ownership of reporting tools, improve automation, and help the business make faster, data-driven decisions.

The role suits someone who enjoys variety, independence, and problem-solving a technically confident Excel user who can investigate data issues, refine reporting processes, and build simple, effective tools that make life easier for others.

The Role

You’ll work as part of a small data and insight function, responsible for:

• Building, maintaining, and improving Excel-based reporting tools with embedded VBA and macros.
• Connecting data sources into Excel via Power Query / Get Data to automate updates and reduce manual effort.
• Using Excel to structure, analyse, and present information creating pivot tables, charts, and summary dashboards that are both accurate and intuitive.
• Investigating anomalies and inconsistencies in datasets to improve data quality and reliability.
• Translating requests from non-technical stakeholders into clear, actionable reports or models.
• Continuously looking for ways to streamline, document, and improve existing reporting processes.

About You

• Confident using Excel to an intermediate or advanced level, including pivot tables, charts, formulas, and formatting.
• Practical experience writing or maintaining VBA scripts you can read, understand, and debug macros.
• Familiar with Power Query (Get Data) or similar tools for connecting and transforming data.
• Methodical, analytical, and naturally curious able to work with a loose brief and deliver tangible results.
• Strong communicator, comfortable explaining what the data means to colleagues at all levels.
• Experience with Power BI or SQL would be beneficial but not essential.

Why Apply?

• Join a stable, well-respected organisation where your analysis directly supports operational and performance improvement.
• Opportunity to modernise and automate legacy reporting processes.
• A genuinely autonomous role, ideal for someone who enjoys ownership and can make an immediate impact.