At a Glance
- Tasks: Develop and enhance business reporting solutions using SQL and Power BI.
- Company: Join Stockport Homes Group, a leader in housing and community transformation.
- Benefits: Competitive salary, hybrid working, and a focus on diversity and inclusion.
- Other info: Collaborative team environment with opportunities for professional growth.
- Why this job: Make a real impact by transforming data into actionable insights for the community.
- Qualifications: Strong SQL skills and experience with Power BI required; Python knowledge is a plus.
The predicted salary is between 39152 - 39152 £ per year.
We pride ourselves on building strong collaborative relationships locally, regionally and nationally. We are passionate about providing housing and building new homes in Stockport while helping to transform the lives of our customers. We aim to provide comfortable and affordable homes and engage customers and communities.
Stockport Homes Group is seeking a BI Report Developer / Analyst to join the Data Team and develop business reporting solutions. The role ensures the organization has operational and financial reporting that meets business needs, working with data from line of business systems, including Civica CX.
Responsibilities- Identify the best products to deliver reporting requirements and documents in line with the Data team’s governance model.
- Locate data, assess accuracy, relevance and reliability, and highlight concerns to business and data colleagues.
- Develop, maintain and enhance data models, SQL scripts and transformations using tools such as SSMS, Power BI and SSRS.
- Test and validate reported data against source.
- Collaborate with team members to improve governance, develop reporting standards and more efficient processes.
- Detailed understanding of SQL, indexes, views, functions and stored procedures.
- Proven experience as a Power BI Developer / Analyst.
- Proficiency in modelling, writing SQL, DAX and Power Query (M).
- Strong analytical, logical thinking and ability to meet tight deadlines.
- Experience with SSRS reporting tools.
- Excellent communication, documentation and collaboration skills.
- Python experience beneficial.
- Excel experience with Pivot Tables and Lookups beneficial.
- Experience with the Civica CX database a plus.
This role will be on Three Sixty hybrid terms and conditions. The SHG “Be You” approach values diversity and inclusion.
Business Intelligence Report Developer/ Analyst in Stockport employer: Housing Diversity Network
Stockport Homes Group is an exceptional employer that fosters a collaborative and inclusive work culture, dedicated to transforming lives through housing solutions in the Stockport area. Employees benefit from a supportive environment that encourages professional growth, with opportunities to develop skills in business intelligence and data analysis while contributing to meaningful community projects. The hybrid working model and commitment to diversity make it an attractive workplace for those seeking a rewarding career in the public sector.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence Report Developer/ Analyst in Stockport
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend local meetups, or join online forums. The more connections we make, the better our chances of landing that BI Report Developer/Analyst role.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best Power BI reports and SQL scripts. This will give potential employers a taste of what we can do and set us apart from the competition.
✨Tip Number 3
Prepare for interviews by practising common questions related to BI reporting and data analysis. We should also be ready to discuss our experience with tools like SSMS and SSRS, as well as how we handle tight deadlines.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure our application gets noticed. Plus, we can keep an eye on new opportunities that pop up in the Stockport Homes Group.
We think you need these skills to ace Business Intelligence Report Developer/ Analyst in Stockport
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Business Intelligence Report Developer/Analyst role. Highlight your experience with SQL, Power BI, and any relevant projects that showcase your analytical skills. We want to see how you can contribute to our mission!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about data and how your skills align with our goals at Stockport Homes Group. Let us know what excites you about this role and our organisation.
Showcase Your Technical Skills:Don’t forget to mention your technical expertise in SQL, DAX, and Power Query. If you've worked with SSRS or Civica CX, make sure to highlight that too! We love seeing candidates who can hit the ground running.
Apply Through Our Website:We encourage you to apply through our website for a smoother application process. It’s the best way for us to receive your application and keep track of all the amazing talent out there. We can’t wait to hear from you!
How to prepare for a job interview at Housing Diversity Network
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss your experience with indexes, views, and stored procedures, as these are crucial for the role. Practising some common SQL queries can also help you feel more confident.
✨Show Off Your Power BI Skills
Since the job requires proficiency in Power BI, be ready to showcase any projects you've worked on. Bring examples of reports you've developed and be prepared to explain your thought process behind the data visualisations. This will demonstrate your hands-on experience.
✨Understand the Business Context
Familiarise yourself with Stockport Homes Group and their mission. Understanding how your role as a BI Report Developer/Analyst fits into their goals will show that you're genuinely interested in the position and can contribute to their objectives.
✨Prepare for Collaboration Questions
Since collaboration is key in this role, think of examples where you've worked effectively in a team. Be ready to discuss how you’ve improved processes or governance in past roles, as this will highlight your ability to work well with others and enhance reporting standards.
