Data and Analytics Officer

SNG (Sovereign Network Group) is one of the largest housing associations in England. We provide over 85,000 homes and invest in communities across the South, West and East of England, including London, as well as building thousands of new affordable homes every year.

We have a fantastic new opportunity as a Data and Analytics Officer in our Data, Analytics and AI department. In this new role you will work closely with stakeholders creating self-serve Power BI datasets to create high quality reports, published to the Power BI environment, ensuring accurate and timely delivery to meet the needs of the business.

You'll be based from our office in either Basingstoke or Wembley, you'll combine home and office working in line with our hybrid approach.

Responsibilities include

• Develop and maintain interactive dashboards, reports, and data visualisations using Power BI to support decision-makers across the organisation.
• Design and implement fact and dimension data models to ensure data accuracy, consistency, and efficiency in all SNG reporting and analysis.
• Work closely with cross-functional teams to understand the data needs and provide analytics solutions to address specific business challenges.
• Work with the Data & Analytics Manager to help champion and support the Centre of Excellence for Power BI.

What we need from you

• Excellent knowledge of reporting software tools such as Sequel Server Management Studio, Data Warehousing Concepts, DevOps, Power BI.
• Good understanding of star schema models and the use in Power BI.
• Excellent communication skills and ability to adapt to a wide audience.
• Ability to use SQL query to shape data requirements.