At a Glance
- Tasks: Design and develop impactful operational and financial reports using Power BI and SQL.
- Company: Join Stockport Homes Group, a socially responsible leader in affordable housing.
- Benefits: Enjoy hybrid working, competitive salary, and opportunities for personal growth.
- Other info: Be part of a diverse team committed to social impact and community transformation.
- Why this job: Make a real difference in your community while honing your tech skills.
- Qualifications: Experience with Power BI, SQL, and a passion for data analysis.
The predicted salary is between 40000 - 50000 £ per year.
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.
A detailed understanding of SQL, indexes, views, functions and stored procedures is required. Proven experience as a Power BI Developer / Analyst is essential. Proficiency in modelling, writing SQL, Dax and Power Query (M) is necessary. You should have the ability to analyse, think logically and work to tight deadlines. Experience of SSRS reporting tools is important. Excellent communication, documentation and collaboration skills are needed. 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.
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.
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.
This role will be on Three Sixty hybrid terms and conditions. We understand that if you don't meet every requirement, you may be hesitant to apply but we still want to hear from you and encourage you to submit an application detailing your experiences, achievements, and the value you can bring to our team. If you require any reasonable adjustments to complete your application, please contact the People & OD Team.
Please note that we do not accept applications through third-party websites. To ensure your application is reviewed, please apply directly through our careers page. We encourage you to apply early! We may close the vacancy sooner if we find the right candidate.
Closing date: Sunday 7th June 2026
1st stage interview over Teams: Wednesday 17th June 2026
In-person Interview date: Thursday 25th June 2026
Power BI & SQL Analytics Architect in Stockport employer: Stockport Homes Group
Stockport Homes Group is an exceptional employer that fosters a collaborative and inclusive work culture, prioritising the well-being and development of its employees. With a strong commitment to social impact, the company offers meaningful opportunities for professional growth while ensuring that all profits are reinvested to enhance community services. Located in Stockport, SHG provides a unique environment where employees can contribute to transforming lives and building affordable housing, making it a rewarding place to work.
StudySmarter Expert Advice🤫
We think this is how you could land Power BI & SQL Analytics Architect in Stockport
✨Tip Number 1
Network like a pro! Reach out to your connections on LinkedIn or even in person. Let them know you're on the hunt for a Power BI & SQL Analytics Architect role. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Prepare for those interviews! Brush up on your SQL and Power BI skills, and be ready to showcase your past projects. Practice common interview questions and think about how you can demonstrate your problem-solving abilities.
✨Tip Number 3
Don’t just apply anywhere—focus on companies that align with your values. Stockport Homes Group is all about social impact and community. Tailor your approach to show how you can contribute to their mission!
✨Tip Number 4
Apply directly through our website! It’s the best way to ensure your application gets seen. Plus, we love hearing from candidates who are genuinely interested in joining our team at Stockport Homes Group.
We think you need these skills to ace Power BI & SQL Analytics Architect in Stockport
Some tips for your application 🫡
Tailor Your Application:Make sure to customise your CV and cover letter for the Power BI & SQL Analytics Architect role. Highlight your experience with SQL, Power BI, and any relevant projects that showcase your skills. We want to see how you can bring value to our team!
Showcase Your Skills:Don’t just list your skills; demonstrate them! Include specific examples of how you've used SQL scripts, Power BI, or SSRS in past roles. This helps us understand your practical experience and how it aligns with what we need.
Be Authentic:We love a bit of personality! Don’t be afraid to let your true self shine through in your application. Share your passion for data analytics and how it connects to our mission at Stockport Homes Group. We’re all about being genuine!
Apply Directly Through Our Website:Remember, we only accept applications through our careers page. So, make sure to submit your application there to ensure it gets reviewed. We can’t wait to hear from you, so don’t delay!
How to prepare for a job interview at Stockport Homes Group
✨Know Your Tools Inside Out
Make sure you’re well-versed in Power BI, SQL, and any other tools mentioned in the job description. Brush up on your SQL scripts, DAX, and Power Query skills. Being able to discuss specific projects where you've used these tools will show your expertise.
✨Understand the Business Context
Familiarise yourself with Stockport Homes Group's mission and values. Think about how your role as a BI Report Developer/Analyst can contribute to their goals of providing affordable housing and improving community lives. This will help you align your answers with their vision during the interview.
✨Prepare for Technical Questions
Expect questions that test your technical knowledge, especially around data accuracy, modelling, and reporting standards. Be ready to explain your thought process when identifying data issues or developing reports. Practising common SQL queries and Power BI scenarios can give you an edge.
✨Showcase Your Collaboration Skills
Since this role involves working closely with colleagues, be prepared to discuss examples of successful teamwork. Highlight experiences where you’ve collaborated on projects, improved processes, or contributed to governance standards. This will demonstrate your ability to fit into their collaborative culture.
