At a Glance
- Tasks: Analyse data and create insightful performance reports to support decision-making.
- Company: Join a local authority committed to service improvement and community impact.
- Benefits: Competitive pay, hybrid working, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on continuous improvement and innovation.
- Why this job: Make a difference by using data to drive improvements in public services.
- Qualifications: Degree or equivalent experience in data analysis and strong SQL skills required.
The predicted salary is between 30000 - 40000 £ per year.
6 Month Contract With A Local Authority
Job Purpose
To analyse and interpret data in order to produce accurate, timely, and meaningful performance reports that support service delivery, statutory reporting, and organisational decision-making. The role involves developing and maintaining data pipelines and reporting systems using SQL, ETL processes, and Power BI to enable effective self-service reporting and insight across the Council. The postholder ensures data is reliable, compliant, and used to drive service improvement and meet regulatory and inspection requirements.
Key Responsibilities
- Analyse data requirements and design reporting solutions to meet statutory, regulatory, and operational needs.
- Develop, maintain, and optimise data pipelines using SQL and ETL processes to integrate data from multiple systems into a centralised data warehouse.
- Design and build Power BI models and interactive dashboards to provide actionable insight across services and directorates.
- Produce, maintain, and automate performance reports, reducing manual reporting and improving efficiency.
- Ensure accuracy, consistency, and quality of data used for performance monitoring, statutory returns, and external inspections.
- Create and maintain technical documentation, data definitions, and user guides.
- Test, validate, and troubleshoot reports and data outputs, resolving issues in a timely manner.
- Support service areas in interpreting data and using insight to drive service improvement.
- Provide technical advice on data feasibility, structure, and reporting approaches.
- Contribute to needs assessments, equality analysis, and insight into local population needs, including minority groups.
- Ensure compliance with data protection, GDPR, and other relevant legislation and Council policies.
- Support continuous improvement of reporting tools, systems, and data processes across the organisation.
- Work collaboratively with internal teams and external partners to deliver a 'One Council' approach.
- Provide guidance and support to colleagues and contribute to the development of reporting capability within the team.
Requirements
- Degree or equivalent experience in a relevant field.
- Experience in data analysis, reporting, or business intelligence within a complex organisation.
- Strong SQL skills (including T-SQL, stored procedures, and CTEs).
- Experience developing dashboards and reports using Power BI (or similar tools).
- Understanding of data warehouse principles and ETL processes.
- Experience working with large datasets and multiple data sources.
- Ability to translate business requirements into technical reporting solutions.
- Strong analytical, problem-solving, and data quality assessment skills.
- Excellent communication skills with the ability to present complex data clearly.
- Knowledge of data protection legislation (GDPR, Freedom of Information Act).
- Experience with SSRS, Power Platform, Python, or Liquidlogic systems (desirable).
- Ability to manage priorities, work collaboratively, and support service improvement through data insight.
Additional Information
- Location: London Borough of Bexley (Hybrid/Office-based as required)
- Hours per Week: 36 Hours
- Pay: Bi-Weekly Payments
Performance and BI Analyst in Bexley employer: Civic Recruitment Limited
Civic Recruitment Limited is an excellent employer, offering a dynamic work environment where strategic leadership in the Special Educational Needs service can truly make a difference in children's lives. With a strong focus on collaboration and professional development, employees are encouraged to grow their skills while contributing to meaningful outcomes in the Bromley community. The supportive culture and commitment to high-quality services make this an attractive opportunity for those looking to lead impactful change.
StudySmarter Expert Advice🤫
We think this is how you could land Performance and BI Analyst in Bexley
✨Join Business Intelligence Meetups
We can’t stress enough how beneficial it is to attend local Business Intelligence meetups and events. These gatherings often bring together industry professionals and can lead to short-term, temporary roles—perfect if you’re looking to land something quickly. Plus, you’ll get to learn some insider tips and tricks from those already in the game!
✨Leverage Online Freelancing Platforms
Since you’re searching for a temporary gig, check out freelancing platforms like Upwork or Freelancer where businesses often post short-term BI projects. This can be a great way to build your portfolio and gain experience while also showcasing your skills to potential future employers.
✨Show Off Your BI Projects
Whether you’re working on a personal project or a past endeavour, put your work out there! Create a public portfolio that highlights your best Business Intelligence analyses or visualisations. It’ll give you a leg up when you’re approaching companies like Civic Recruitment Limited, showing exactly what you can bring to the table.
✨Tap Into University or College Networks
If you're currently studying or recently graduated, make sure to use your university's career services. Many educational institutions have partnerships with companies looking for temporary talent in Business Intelligence, so keep an eye out for exclusive job postings or internship fairs that could lead to a quick placement.
We think you need these skills to ace Performance and BI Analyst in Bexley
Some tips for your application 🫡
Show Off Your Data Skills:In business intelligence, it's crucial to highlight your analytical skills and experience with data tools. Make sure your CV showcases any relevant software you’ve used, like SQL, Tableau, or Power BI. Add specific examples of how you've used data to drive insights or improvements in previous roles, even if they were in academic projects or internships.
Keep it Concise and Impactful:For a temporary role like this, hiring managers often have limited time to sift through applications. Get straight to the point in your CV and cover letter. Use bullet points for your achievements, showcasing the impact you've made, like percentage increases in efficiency or specific results from your analyses.
Flexibility is Key:Since this is a temporary position, make sure to emphasise your adaptability. Mention your quick learning abilities and experiences where you adapted to new tools or processes rapidly. This will show that you can jump in and start contributing effectively from day one at Civic Recruitment Limited.
Craft a Tailored Motivation Statement:In your cover letter, focus on why you’re excited about this temporary role at Civic Recruitment Limited. Talk about your interest in business intelligence and how this position aligns with your career goals. Remember, it’s not just about what you can offer, but why you’re passionate about becoming part of their team, even for a short time!
How to prepare for a job interview at Civic Recruitment Limited
✨Brush Up on Your Data Skills
For a business intelligence role, you'll want to showcase your analytical skills and familiarity with data visualisation tools like Tableau or Power BI. Be ready to tackle technical questions or case studies demonstrating your ability to interpret data and make insightful recommendations.
✨Plan Your Portfolio of Projects
Since this is a temporary position, we should highlight any past projects you've worked on in business intelligence. Prepare a portfolio that includes a couple of key pieces where you've effectively utilised data to drive decisions—this will show that you're not just a quick fix but someone who can deliver immediate value.
✨Demonstrate Your Adaptability
Temporary roles often require us to hit the ground running, so be ready to discuss how you quickly adapt to new tools, teams, and environments. Share specific examples from previous experiences where you thrived under pressure or had to learn a new system or process in a short time frame.
✨Have Your Metrics Ready
In business intelligence, quantifying your impact is key. Come prepared to share metrics from your past work: think percentages, growth figures, or efficiency improvements. This will really help us paint a picture of how your contributions directly benefited those previous roles.
