Location: Birmingham (On-site for first 3 months, then hybrid)**

We’re supporting a well-established organisation in Birmingham who are strengthening their reporting and insight capability. They’re looking for a technically strong Data Analyst to take ownership of key reporting processes, improve automation, and help the business move towards more consistent, data-driven decision making.

This is a hands-on role for someone who enjoys improving spreadsheets, building automations, and solving data problems. You’ll be the type of analyst who spots issues early, enjoys understanding how data flows, and can translate complex information into useful insight.

Working pattern

• On-site in Birmingham 5 days per week for the first 3 months
• (This allows a proper onboarding period and full understanding of the business and reporting processes.)
• After 3 months: Move to a hybrid model.

What you’ll be doing

• Owning and maintaining a suite of performance and operational reports.
• Using Excel (including VBA/macros) to automate and enhance existing reporting tools.
• Connecting data sources into Excel using Power Query / Get & Transform and maintaining refreshable data pipelines.
• Building dashboards, KPI trackers and trend reports used by managers across the business.
• Identifying data quality issues, investigating root causes, and implementing fixes.
• Modernising legacy spreadsheets and replacing manual processes with structured, reliable solutions.
• Working closely with internal stakeholders to understand reporting needs and deliver clear, actionable outputs.

What you’ll bring

Essential:

• Strong Excel skills: formulas, pivot tables, charts, dashboards.
• VBA / Macros – able to read, edit and debug existing code (and write simple scripts).
• Power Query experience (connecting data, transformations, automation).
• A problem-solving, investigative mindset with good attention to detail.
• Ability to work autonomously once up to speed.

Nice to have:

• Power BI or other visualisation tools
• SQL basics
• Experience improving or automating reporting processes

Who this role suits

• Someone who enjoys working with data at a detailed, hands-on level.
• An analyst who gets satisfaction from making messy spreadsheets clean, reliable and automated.
• A proactive, curious problem-solver who likes working out how data flows and where issues originate.
• Someone looking for real ownership and visibility within a stable organisation.

Why join?

• High ownership and autonomy once embedded.
• A role where your work directly improves performance, accuracy and efficiency.
• Supportive environment with clear opportunity to modernise reporting.
• Stable organisation investing in stronger data capabilities.