BI Analyst

BI Analyst - Stoke £40,000 per year

- £35k - £40k + strong benefits

- Based in Stoke-on-Trent

- Hybrid once probation completed

- Strong progression plan

As a Business Intelligence Analyst, you will play a key role in driving data-informed decision-making by delivering insightful analyses and reports. You will contribute to gathering, analysing, and visualising data to uncover trends and actionable insights that enhance business operations, customer satisfaction, and overall performance. Working closely with cross-functional teams, you will leverage tools such as PostgreSQL, Excel, and Power BI to optimise operations and support strategic objectives.

Skills and Knowledge

Strong analytical and problem-solving abilities.

Proficiency in SQL (PostgreSQL) and data modelling.

Proficiency in Microsoft Excel (eg, PivotTables, VLOOKUP, data cleaning).

Advanced skills in Power BI, including building dashboards, reports, and DAX.

Understanding of statistical concepts and methodologies

Knowledge of database management systems.

Knowledge of ETL tools and processes to support data integration.

Familiarity with Jira and ticketing systems

Key Duties and Responsibilities

Data Analysis and Insights

Conduct detailed analyses to identify trends, opportunities, and performance gaps.

Produce actionable recommendations to improve operational efficiency and strategic outcomes.

Perform root-cause analysis to uncover hidden drivers behind performance metrics

Dashboards, Reporting and Data Modelling

Design, develop, and optimise Power BI dashboards and interactive reports tailored to various stakeholders and needs.

Automate and streamline recurring reports to improve efficiency and reduce manual effort.

Translate complex data into visually intuitive reports that cater to both technical and non-technical audiences.

Write and optimise advanced SQL queries to extract, transform, and analyse data.

Design and implement data models to support reporting and analysis needs.

Ensure data pipelines are efficient, reliable, and scalable.