Business Intelligence Analyst

Full Time – 37 hours per week – Ideally located within 1 hour of Peterborough

Are you a data-driven individual with a passion for business intelligence and PowerBI? Here at Cross Keys Homes we are seeking a talented Business Intelligence Analyst to join our Business Insights team on its mission to centralise and expand performance reporting. The goal of this role is to further develop, update, and maintain the organization's suite of PowerBI reports and dashboards, offering a comprehensive view of performance across various disciplines, including finance reporting and tenancy management.

The ideal candidate will have prior experience in data visualization and ETL processes using PowerBI, as well as strong project management and business partnering skills. They should have the ability to see the story behind the numbers and effectively communicate technical information to a non-technical audience. A solid understanding of SQL would be an added bonus.

This role is home based with the requirement to attend our Peterborough Head Office as required for meetings. There also is an occasional requirement to work outside of office hours.

We are looking for someone

• To develop a suite of business intelligence reporting for CKH.
• To assist in the development of data integration across systems and the creation of ‘single version of the truth’ data sources.
• To provide primary PowerBI administration, managing user access, privacy settings, version updates and tenant settings.
• To review existing corporate ‘intelligence’ needs and prioritise the development of future outputs with reference to key corporate objectives and identify opportunities to improve and evolve methods of reporting and analysis to ensure continuous improvement. To develop analysis to an agreed standard.
• Provide analytical outputs which support the focus of the business on understanding its performance across a wide range of areas and how business intelligence can support customer and business insight.
• To provide an analytical review of outputs which draw upon insight data sources and supports with Managers and Directors in developing service planning, assessment, business transformation and assurance information.
• To review existing databases of performance information and develop processes to deliver required information from source for future reporting, aligned to agreed standards
• To assist with the development and maintenance of quality data within application databases by applying analytical challenge to data integrity and by liaising with operational teams to develop and advise on business processes as appropriate to ensure accuracy and quality of data.
• To support the development and implementation of an integrated approach to dashboard performance reporting throughout CKH which combines existing and future KPIs with predictive analytical techniques and migrates production of management information towards a central hub.

Knowledge and Experience

Essential:

• Knowledge and experience of implementing performance management and business insight applications into complex operating environments.
• Experience of developing business intelligence solutions is essential, as is experience of developing data visualisations in Power BI, or comparable Business Intelligence application.
• Knowledge and experience of using data visualisation tools.
• A demonstrable track record of improving corporate intelligence and delivering results.
• Knowledge of statistical techniques to measure results and show key trends.
• Expertise in SQL scripting to extract data from corporate systems.

Desirable:

• Experience in PowerBI administration.
• Experience in the Social Housing sector.
• Experience in finance reporting/budget monitoring.
• Experience of the QL Housing Management System

Skills and Abilities

Essential

• Knowledge of data modelling using SQL and/or PowerQuery (M) queries using a variety of data sources.
• DAX knowledge and data visualisation skills to build Power BI reports, dashboards and Apps.
• Ability to interpret relevant information, analyse complex data, and come to well-informed conclusions.
• Ability to manipulate, analyse and synthesise data using different sources to create customer-led, data driven reports and high impact presentations.
• Ability to communicate clearly and concisely, verbally and in written form with colleagues at all levels, both internally and externally.
• Ability to work with, influence and negotiate with senior employees and managers in order to affect change and where appropriate challenge constructively.
• Ability to analyse user and business needs.
• Ability to advise managers and directors, as well as manage projects, from inception to post-implementation review.
• Ability to work under pressure to challenging timelines whilst demonstrating the ability to prioritise and communicate those priorities appropriately.
• Ability to create and support a learning culture for the organisation.
• A full UK driving licence is required.