Business Intelligence Report Developer/ Analyst

Stockport Homes Group
Stockport, United Kingdom
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Stockport, United Kingdom

Tech stack

Microsoft Excel
Business Systems
Databases
Python
Pivot Tables
Power BI
SQL Stored Procedures
SQL Databases
SQL Server Reporting Services
Powerquery
Tools for Reporting
SQL Server Management Studio (SSMS)

Job description

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., The SHG "Be You" approach sums up our belief that everyone has the right to be who they are, and to be that person at work, in line with SHG's Values. We're always looking to improve diversity within our teams to enhance this culture and to be truly representative of the communities we work in.

Requirements

Do you have experience in SSRS?, * 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.

Please note: this role requires hybrid working, with an expectation to attend our Stockport office (SK1 3NQ) on a regular basis.

About the company

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., Welcome to Stockport Homes Group (SHG), an umbrella organisation for four, socially responsible interdependent companies within the housing sector. What makes us unique is our vision: one where entrepreneurship and commercialisation go hand in hand with social impact. We are Stockport's largest landlord, managing over 12,000 properties on behalf of Stockport Council and Private Landlords, as well as our own growing portfolio of new build homes. As builders, landlords, architects and developers we believe in collective responsibility for more affordable housing. Equally, through a commitment to a range of wrap around services we look for ways to improve people's lives: from advice and support on health and wellbeing, to employment, educational opportunities and help in the home. All our profit is reinvested within the group to maximise opportunities for those who most need our help. Companies within SHG: Stockport Homes - Stockport Homes was formed in 2005, to manage housing stock across Stockport on behalf of Stockport Council. As a limited company, we operate as an ALMO which is an 'Arm's length management organisation', so whilst the company is owned by the Council, we operate independently on day-to-day matters and in delivering services to our customers. We are committed to providing quality homes across Stockport and listening to the voice of our customers to continually improve our services. Three Sixty - Three Sixty delivers innovative, high-quality construction, maintenance and facilities management services across Stockport, Greater Manchester and Cheshire. We are trades people who operate with a friendly, community-led approach. We get the balance right between excellent customer service and service delivery. We take pride in giving back to our local communities and each year we Gift Aid our profits to SKylight to support the work they do to help Stockport and the borough thrive. Skylight - SKylight is a Charitable Community Benefit Society, established in 2018, dedicated to transforming lives in Stockport. We work closely with local communities to support people into employment, alleviate poverty and enhance digital skills. Our services help individuals live independently while fostering strong community networks, particularly for those facing disadvantages. We are proud to contribute to making Stockport a great place to live and work. Viaduct Housing Partnership - Formed in 2017, Viaduct is a development partnership between Stockport Homes Group and Stockport Council, focusing on building more affordable homes in Stockport. SHG is proud to be an award-winning organisation dedicated to transforming the lives and communities of our customers and as a public-private sector fusion, SHG is focused on future growth and excellence - looking for the best people to join the Group to be on this exciting journey.   You must create an Indeed account before continuing to the company website to apply

Apply for this position