Housing BI Engineer WCC623649

As a Housing BI Engineer, you can make your own powerful contribution to Westminster's success. Working within Housing Services, you'll design and maintain the data pipelines and systems that underpin how the service understands performance, meets regulatory requirements and improves outcomes for residents and colleagues.

You'll take ownership of building scalable data pipelines across key housing areas such as repairs, tenancy, homelessness, major works and compliance. Using platforms like Snowflake, Azure Data Factory and Power BI, you'll develop integrations that bring together data from multiple SaaS systems into a single, reliable source of truth. Alongside this, you'll design and maintain robust ETL processes, ensuring data is moved, transformed and stored efficiently, securely and accurately.

A big part of your role will be improving how data is used day to day. You'll identify and replace manual workarounds like spreadsheets and email trackers with automated, reliable solutions that reduce administrative burden and improve the quality of data. You'll also lead on data migration and transformation activities, making sure data is ready for new systems and modern reporting environments, with strong validation and quality control in place.

Building data models and reporting solutions that go beyond surface-level insight, you'll help uncover root causes behind issues such as repairs, ASB and complaints. Working closely with analysts and service leads, you'll develop dashboards and reporting that are actionable and aligned to key performance indicators, while ensuring everything meets statutory and regulatory reporting requirements.

Collaboration will be a big part of what you do. You'll work with housing service leads, analysts and digital colleagues to understand data needs and translate them into technical solutions. And through workshops and discovery sessions, you'll help shape data flows, define requirements and document architecture and processes in a way that works for both technical and non-technical audiences.

Everything you do will support delivery across housing data projects, working in an agile way to track progress, manage dependencies and address risks. Whether you're developing prototypes, creating data flow diagrams or contributing to iterative delivery cycles, you'll help ensure solutions are practical, user-focused and deliver real value.

Alongside your core role, you'll contribute to a wider culture of teamwork and continuous improvement. You'll play an active part in data communities of practice, share knowledge and support others - including mentoring junior colleagues where needed. If you're someone who wants to see the direct impact of your work on frontline services, this is a place where your contribution will be recognised and valued.

You'll have experience working in BI, data engineering or data platform development, ideally within a local authority, housing association or similar public sector setting. Building and maintaining data pipelines will feel familiar, along with integrating housing systems and supporting data migration and transformation. You'll also have an understanding of housing data standards, regulatory reporting requirements and the realities of working with legacy systems and siloed datasets.

You'll be comfortable collaborating with analysts, developers and service leads, contributing to data solutions that support both day-to-day operations and longer-term goals. Agile ways of working won't be new to you either - whether that's taking part in stand-ups, sprint planning or retrospectives - and you'll be used to working in an iterative, user-centred way. Tools like JIRA, GitHub and Confluence will be part of how you stay organised and keep delivery on track.

From a technical perspective, you'll bring strong SQL and DAX skills, along with experience using Snowflake and Power BI to build and maintain data pipelines and reporting solutions. You'll understand data modelling and ETL processes, and be comfortable working with cloud-based platforms to create reliable, scalable solutions.

You'll be someone who can explain technical ideas clearly, helping non-technical colleagues understand what's possible and why it matters. Building relationships across teams will come naturally, making it easier to bring people together and deliver joined-up solutions.

You'll also be proactive when it comes to delivery - spotting risks, blockers and dependencies early and working with others to resolve them. There's a focus on improving how things work, whether that's automating manual processes, simplifying workflows or using tools like Lucidchart or Miro to map and refine systems.

An understanding of the local government context will help you navigate the role, including the legal, financial and political factors that shape how services are delivered. Alongside this, you'll bring a digital mindset - always looking for ways data and technology can improve outcomes, while keeping services inclusive and accessible for everyone.

THE EXTRAORDINARY STORY OF THE IMPOSSIBLE DREAM Housing and Commercial Partnerships in Westminster City Council is a world of extraordinary stories. Where people use their vision and commitment to open doors for the next generations. Nothing beats the feeling of helping someone find their passion. At Westminster City Council, our City Lions team helps young local people engage with culture, creativity and dreams. When they came across a lonely, isolated 16-year-old who called himself a failure, they knew what to do. They worked 1-2-1 to find the thing this boy really loved. YouTube, it turned out. But it's impossible to turn that into a career, right? Wrong. A week later, he was enrolled on the British Film Institute film-making programme. It was the ultimate light-bulb moment. And it turned him into what he is today - a budding Spielberg with a world of opportunity at his feet., Westminster City Council is committed to supporting Care Leavers into the workplace. Care Leavers seeking their first job and who wish to be considered under our scheme, will automatically be invited to interview should they meet the essential criteria for the role. The Council is committed to achieving diverse shortlists to support our desire to increase the number of staff from underrepresented groups in our workforce. We especially encourage applications from a Global Majority (GM), people who are Black, Asian, Brown, dual-heritage, indigenous to the global south, and or have been racialised as 'ethnic minorities' (formally known as B.A.M.E , Black, Asian and multiple ethnic) background and, while the role is open to all applicants, we will utilise the positive action provisions of the Equality Act 2010 to appoint a candidate from a global majority background where there is a choice between two candidates of equal merit. If you are from a Global Majority background you can self-declare this to the hiring manager as part of our positive action commitments., Westminster is an amazing place. We are home to more than 200,000 residents from all backgrounds, over 50,000 vibrant and vital businesses and three-quarters-of-a-million people work in Westminster. Westminster City Council's strategy is to work towards a Fairer Westminster. A Fairer Westminster is one in which our communities are at the heart of our decision-making and help to determine the city's future. By working directly with our communities and other partners, we can build a more inclusive city that celebrates our diverse communities, and where residents, workers and visitors from all backgrounds will feel welcome and safe. At Westminster City Council, we pride ourselves on being an inclusive workplace and employer of choice. We encourage and welcome applications from people from all backgrounds and aim to have a workforce that, at all levels, represents the communities we serve. We champion equality, diversity, inclusion and wellbeing and aim to create a workplace where everyone feels valued, has a sense of belonging and is empowered to be their best, that is the Westminster Way. To find out more about how we do this visit https://www.westminster.gov.uk/health-and-social-care/public-health-strategy-policies-and-reports/equality-duties As a forward thinking Council we appreciate that people work in different ways, therefore our staff benefit from working a range of flexible working patterns as well as Agile working.