BI Report Developer / Analyst
Location: Stockport
Salary: Up to £36,750 per annum
The Vacancy
Permanent
Full time (37 hours per week)
Closing date: 10th March 2024
Interview date: 14th March 2024
Stockport Homes Group is a great place to work! We pride ourselves on building strong collaborative relationships locally, regionally and nationally. We are passionate about not only providing housing and building new homes in Stockport but helping to transform the lives of our customers. We aim to provide comfortable and affordable homes and engage customers and communities.
Stockport Homes Group are looking for a BI Report Developer / Analyst to join their Data Team, to analyse and deliver business reporting requirements.
The Key purpose of this role is to ensure that Stockport Homes Group have access to appropriate operational and financial reporting that meets business needs. You will work alongside colleagues to design, develop, deploy and manage all forms of operational and strategic reporting, initially from data held in line of business systems, including Civica CX.
As the BI Report Developer / Analyst you will be responsible for:
Identifying the best product to deliver requirements and documents as per the Data team’s governance model.
Identifying location of data and determine accuracy, relevance and reliability, highlighting concerns to the business and data colleagues
Developing, maintaining and enhancing appropriate modelling, SQL scripts and transformations, using products such as but not limited to SSMS, Power BI and SSRS
Undertaking appropriate testing and validation of reported data against source
Collaborating with other team members to improve governance, develop reporting standards and more efficient processes.
Our ideal candidate will have:
A detailed understanding of SQL, indexes, views, functions and stored procedures
Proven experience as a Power BI Developer / Analyst.
Proficiency in modelling, writing SQL, Dax and Power Query (M).
Ability to analyse, think logically and work to tight deadlines.
Experience of SSRS reporting tools
Excellent communication, documentation and collaboration skills
Experience in use of Python would be beneficial.
Excel experience with Pivot Tables and Lookups would be beneficial.
Experience of the Civica CX database would be an advantage.
It is important to us that we have a diverse workforce, representative of the communities we work in. Equality, diversity and inclusion is important to us and we like to acknowledge that everyone is different. We’re always looking to improve diversity within our teams and across the group, so we would welcome any applications from any underrepresented groups.