Power Platform Analyst

Cross Keys Homes Limited; Cambridgeshire and Peterborough; Híbrido; GBP 42.000 - 62.000; Jornada completa

Descripción de la vacante

Cross Keys Homes Limited is seeking a skilled Power Platform Analyst to transform complex data into practical dashboards that monitor performance and compliance. You will build and maintain Power BI reports, leverage SQL data from our reporting database, and create Power Automate workflows to streamline processes across the business.

You’ll work with non-technical colleagues to capture requirements, define KPIs, and document evolving business processes.

Formación

• Experience in building Power BI reports and extracting/shaping data, ideally using SQL.
• Experience gathering requirements from non-technical users and translating them into technical solutions.
• Strong Excel skills with data modelling and ETL understanding.
• Knowledge of T-SQL, DAX and Power Query M.
• Keen to develop across the data lifecycle from extraction to presentation.
• Logical, organised thinker who stays calm when priorities shift.
• Excellent communication skills and ability to explain concepts at all data confidence levels.
• Ability to see the bigger picture and identify improvement opportunities.
• Self-motivated, independent yet collaborative and customer-focused with social housing interest.

Responsabilidades

• Developing and maintaining Power BI reports to support performance monitoring and decision making.
• Querying and transforming data from SQL Server reporting database into reliable reporting tables.
• Creating and improving Power Automate workflows to streamline processes.
• Helping define KPIs and document evolving business processes.
• Responding to ad hoc data requests and contributing to a wide range of analyses.
• Supporting data quality, testing, and documentation practices as Power Platform usage grows.
• Training colleagues and helping them gain confidence with data.

Conocimientos

Power BI reports

SQL data querying

Requirements gathering

Excel

Data modelling

ETL processes

T-SQL

DAX

Power Query M

Learning agility

communication

collaboration

problem solving

social housing interest

Educación

Degree in quantitative discipline

Microsoft Power Platform certification

Professional qualification in data analysis/reporting

CPD/continuous development

Herramientas

Power BI

Power Automate

Power Apps

SharePoint

Dataverse

SQL Server

Descripción del empleo

Full Time - 37 Hours per week

Remote with travel to our Peterborough office at least monthly

Are you an experienced Power BI professional who enjoys turning complex data and evolving business needs into practical solutions? Would you like to use your technical skills to improve services for residents and communities? If so, we'd love to hear from you.

Cross Keys Homes is a leading registered provider of social housing, committed to making a positive impact in our communities. As our Power Platform Analyst, you'll join our small but ambitious Business Insights team and play a key role in expanding and maintaining our Power Platform solutions. Power BI reporting will be at the heart of the role, alongside opportunities to use Power Automate and Power Apps to digitise services and automate processes across the business.

This is a role for a genuine all-rounder. As well as building data models and reports, you will find yourself helping a service manager pin down exactly how a KPI should be measured, you might have to map a process that has just changed, write a SQL query for an urgent request, or show a colleague that a dashboard can do everything their spreadsheet does, and more.

What you’ll do:

• Working with colleagues across the business to understand what they need (even when they're still working it out) and turning that into practical solutions
• Developing and maintaining Power BI reports that support performance monitoring, regulatory compliance and day-to-day decisions
• Finding, querying and transforming data, mostly from our SQL Server reporting database, into reliable reporting tables
• Creating and improving Power Automate workflows that streamline our processes
• Helping to define KPIs and document business processes as they evolve
• Responding to ad hoc data requests and contributing to a wide range of analysis and reporting
• Helping us build good habits around documentation, testing and data quality as our use of the Power Platform grows
• Training and supporting colleagues, helping them grow in confidence with data

What we are looking for:

Essential

• Experience of building Power BI reports and of extracting and shaping data, ideally using SQL
• Experience of gathering and documenting requirements from non-technical users and translating them into effective technical solutions.
• Strong Excel skills and a sound understanding of data modelling and ETL processes.
• Knowledge of T-SQL and database management, together with proficiency in DAX and Power Query M.
• A quick learner, keen to develop across the whole data lifecycle, from extraction to presentation.
• A logical, organised thinker who stays calm and good-humoured when priorities shift
• Excellent communication skills, with the patience to explain things to people at every level of data confidence
• The ability to see the bigger picture and spot opportunities for improvement
• Self-motivated and able to work independently, while enjoying collaborating and learning from others
• A collaborative and customer-focused approach, with a genuine interest in social housing and using technology to improve community services.

Desirable:

• Experience of developing solutions using Power Automate and Power Apps.
• Familiarity with SharePoint and Dataverse.
• Experience of product lifecycle management, Power Platform governance or working within a small organisation.
• Awareness of the social housing regulatory framework or experience of housing management systems.
• Willingness to travel into Peterborough at least monthly and work out of hours on occasion, as required by the role.

Qualifications:

• A degree in a quantitative discipline or relevant experience.
• Microsoft Power Platform certification.
• Professional qualification or training in data analysis and/or reporting.
• Evidence of continuing professional development.

If you're excited about using your analytical skills and curiosity to make a difference, we'd love to hear from you. We welcome applications from people who bring the essential experience and a willingness to keep learning and developing across the Power Platform.

Please see the attached job description for full details of the role.

No agencies please.