Power BI Data Analyst in London

The Government Property Agency is the largest property holder in government, with more than £2.1 billion in property assets and over 55% of the government’s office estate. We are transforming the way the Civil Service works by creating great places to work, leading the largest commercial office programme in the UK, working towards halving carbon emissions from government offices, and achieving greater value for taxpayers. We are looking for innovative, solutions‑focused people to join our team.

Representing the best covenant in the UK – His Majesty’s Government – we are leading transformational programmes such as the Government Hubs Programme, Whitehall Campus Programme and Net Zero Programme, as well as delivering modern, cost‑effective real estate service solutions. Innovation and progress are at the heart of our behaviours. We foster a culture of lifelong learning, where curiosity and self‑improvement are encouraged. We’re dedicated to becoming a leading, inclusive employer both in the external market and throughout the Civil Service. Our strong emphasis on Equity, Diversity, and Inclusion (EDI) is not just about driving inclusion across our organisation, it is also about ensuring our services meet the needs of government departments and the civil servants who use our spaces.

Join our dynamic and diverse team that leads with purpose, improving sustainability, nurturing social value, driving inclusivity and flexibility, and kickstarting economic growth. We are driven by purpose, and you can be part of it too: where you make a meaningful impact; where you influence; where your voice really matters; where you help to shape our future direction. The GPA is committed to representing the communities we serve by making Diversity, Equality and Inclusion part of everything we do. To ensure that we are always recruiting and retaining a diverse mix of talent, we are particularly inviting applications from candidates who are disabled, ethnically or gender diverse, and people who identify as being part of the LGBTQ+ community.

Data analytics provides a transformational and powerful combination to support GPA’s current and forward planning in key areas such as across Operations, Portfolio Performance, Health and Safety, Risk Management and Sustainability. It provides essential actionable insights to support planning, decision making, scenario planning and predictive analytics. Data analytics across the GPA is already providing a transparent, interactive interface to the large amount of data we collect and process in GPA. A number of exemplar PowerBI dashboards are already supporting business plan objectives and crucial reporting in areas such as Occupancy, Property Portfolio, Customer Satisfaction, Client Satisfaction, CRM Reporting, Sustainability etc.

In this role you will be responsible for the full lifecycle development and maintenance of part of GPA’s dashboard portfolio. Working alongside Business Analysts and Data Architects you will have authority to build analytics solutions that are underpinning the key strategic and operational business decisions of GPA.

• Support the delivery of GPA’s Information & Data Strategy and wider reporting requirements;
• Support the delivery of reporting & dashboard business KPI’s, providing more focussed support to business critical dashboards and reporting;
• Delivering GPA’s BI products in accordance with our Information Management and Data Governance frameworks;
• Capturing and refining the requirements for BI across GPA and using this to design solutions in consultation with business stakeholders;
• Designing and deploying BI applications (e.g. dashboards) across GPA and more widely across government as required;
• Performing upgrades and improvements to the functionality and content of deployed dashboards;
• Support the team with business engagement, hosting working group sessions to provide updates to all levels of the business;
• Collaborate across GPA at all levels to gather requirements and produce new dashboards that will aid in their daily working duties for the GPA.

As a data driven organisation, a data analytics lead is essential to assure as an organisation we can devise approaches and systems to ‘make sense’ of the large volumes of data present in the organisation. The Senior Data Analyst ensures that the GPA:

• Engages and liaises across GPA to ensure BI requirements are captured and understood;
• Has fully documented methods and approaches to create BI products Updated;
• Has reliable and accurate BI applications deployed as required by the business.

Essential criteria

• Advanced Power BI design and development, Power Query, DAX, RLS;
• Azure, Redshift, Databases, Power Platform, Dev Ops, SQL, RLS, CICD;
• Design and development of Power BI artefacts and environments;
• Numerical analysis methods;
• Stakeholder management and consensus building;
• Working in an Agile development environment;
• Using Agile development tools such as JIRA.

Desirable criteria

• Work prioritisation and scheduling to time and budget;
• People training & development;
• Power BI CI/CD Pipelines.

Qualifications and Accreditations

Essential criteria: A computer/analytics University degree.

Desirable criteria: Microsoft Accreditation for Data Analytics (DA-100); Gold Standard: IT & Data Management – CITP / CsyP.