You'll be responsible for analysing business data, developing dashboards, automating reports, and identifying opportunities to improve operational performance. This position requires strong SQL skills, experience with Power BI, and advanced Excel capabilities, including VBA or a strong understanding of Excel automation.
The Role:
Gather, analyse, and interpret data from multiple business systems.
Write and optimise SQL queries to extract, manipulate, and validate data.
Develop and maintain interactive Power BI dashboards and reports.
Create automated reporting solutions using Excel, VBA, and Power Query where appropriate.
Identify trends, patterns, and opportunities that support business improvement.
Work closely with stakeholders to understand reporting requirements and translate them into actionable insights.
Ensure data accuracy, consistency, and integrity across reporting processes.
Support business projects by providing analytical insights and performance metrics.
Document reporting processes, data definitions, and business requirements.
Recommend improvements to existing reporting and analytical processes.
Essential Skills & Experience:
Proven experience in a Data Analyst, Business Analyst, Reporting Analyst, or similar role.
Strong SQL skills with the ability to write complex queries and manipulate large datasets.
Experience creating dashboards and reports using Microsoft Power BI.
Advanced Microsoft Excel skills, including Pivot Tables, Power Query, Lookups, and formulas.
Experience with VBA or a strong background in Excel automation and advanced spreadsheet development.
Strong analytical and problem-solving abilities.
Excellent attention to detail and data accuracy.
Ability to communicate technical information clearly to non-technical stakeholders.
Experience working with multiple data sources and relational databases.
If this sounds like your next role, click apply now
Salary description
£47000.00 - £52000.00 per year