Business Intelligence Analyst
Role details
Job location
Tech stack
Job description
We have an exciting opportunity for a Business Intelligence Analyst (BIA) to work as part of the Technology, Data and Change team. You will play a key role in designing, developing and maintaining the organisation's business intelligence solutions., Establishing strong relationships with internal customers and gain a thorough understanding of business areas which enables you to offer alternative approaches and options. * Designing and delivering interactive dashboards, visualisations, and reports in Power BI to support operational and strategic decision-making using a business partnering approach to ensure you meet requirements. * Partnering with the Technology team on the development of the data warehouse, developing efficient ETL (extract, transform, load) processes to ensure data accuracy, consistency, and timeliness. * Work with stakeholders to embed best practice in data entry, validation, and reporting. * Present complex data, findings and recommendations in a clear, engaging, and accessible way. * Ensure data integrity, accuracy, and security in line with GDPR and regulatory requirements.
Requirements
Degree in Computer Science, Data Analytics, or related field, or equivalent experience (E) * Microsoft certifications in SQL, Power BI, Excel or Azure (D) * Vendor certifications in other BI tools (e.g. Tableau Desktop (D) Specialist, DAX, Qlik Sense Business Analyst, SSRS certification) (D)
Experience:
Proven experience working in a BI or data analysis role, ideally within housing, public sector, or another service-driven environment. (E) * Strong working knowledge of Power BI (DAX, Power Query, data modelling). (E) * Proven experience of using data warehouses (e.g. Views, SQL, Data modelling). (E) * Experience collaborating with stakeholders in requirements analysis/gathering role. (E) * Proven experience producing business insights and translating data into actionable recommendations. (E)
Skills, Knowledge and Abilities:
Strong SQL skills (queries, views, procedures, functions, optimisation). (E) * Understanding of data governance, data quality, and GDPR compliance. (E) * Experience of identifying, monitoring and improving data quality. (E) * Strong analytical and problem-solving skills, with a focus on tenant impact. (E)