Business Intelligence Analyst

£45,000 per annum, 30 days annual leave, hybrid working & generous pension scheme

Hays Technology are working in partnership with a large public sector organisation in Walsall to recruit a BI Analyst on a permanent basis.

Your role will be to transform raw data into actionable insights and leverage those insights to drive informed business decisions and monitor performance.

You will conduct full data analysis lifecycle activities encompassing requirements analysis, data modelling, the creation of relevant and reusable metrics and front-end report development.

You will also support the overall technical approach for business intelligence reporting.

A crucial aspect of your role will be ensuring key metrics and findings are presented in an easy-to-use way to enable stakeholders to drive data-based business improvements.

Main tasks & responsibilities:

Support the technical approach to business insights reporting through the development of databases, reusable data assets to ensure data can be reused across multiple initiatives, data collection processes and strategies to optimise statistical efficiency and data integrity.
Oversee and develop existing business insight reports, including acting on opportunities to streamline existing reports and improve data integrity across the organisation. Demonstrating initiative and accountability in decision-making.
Develop novel analyses, reports, dashboards and insights using various reporting and analytical tools, exploring innovative techniques to inform and support key business decisions.
Design solutions that seek to use core system functionality for data recording and reporting wherever possible.
Perform data extractions for regulatory returns and deliver accurate data externally as required.
Perform quantitative data analysis using statistical techniques and interpret trends and patterns in complex data sets.
In order to apply for this role, you must have the following skills and experience:

Proficiency in SQL, Excel, Power BI and DAX is essential, as these tools are integral to the role.
Desirable to have knowledge and expertise in programming languages such as Python and R.
Experience working with cloud-based data platforms, such as Snowflake or DataBricks is preferred.
Expertise in using T-SQL to interrogate and extract data through complex queries and stored procedures.
A comprehensive understanding of databases, query optimisation, load monitoring, the Microsoft BI Stack and ETL frameworks.
Technical expertise in data mining, data auditing, and segmentation.
Experience building reusable data models, ideally with customer and/or asset data.
Experience in handling and cleaning raw data.
A comprehensive understanding of performance data, exceptional analytical skills using techniques such as linear regression and excellent data visualisation skills.
Proven ability to conduct user acceptance testing and ensure data integrity.
Ability to translate complex data into actionable insights for non-specialist audiences.
Data curious, awareness in effectively utilising data and an interest in emerging trends within data analytics and data science, for which training opportunities will be provided.
Skills in python and R would be highly desirable.
If you have the relevant experience and would like to apply, please submit your CV.

Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at (url removed)