About Us
North Somerset Council is dedicated to providing high-quality services to our community. We are committed to creating a fair, green, and more inclusive environment for all our residents. Join us and contribute to making a positive impact on our community.
The Role
We are seeking a dedicated and experienced Business Intelligence Analyst to join our Business Intelligence Team which is part of the wider Business Insight, Policy and Partnerships Service. The Business Intelligence Team are responsible for providing information, data and analysis across the whole council. This role will be specially around Adult Social Services and Housing.
In this role, you will; work alongside the other business intelligence analysts in the team to provide robust data and analysis about Adult Social Care and Housing. Contribute towards statutory government returns. Work to improve data quality and methods for ensuring accuracy. Extract data using SQL and visualise it using Power BI. Provide support to the statutory surveys for Adult Social Care undertaking both quantitative and qualitative analysis.
Collaborate with others to produce data and insights that are essential to CQC and directorate assurance programmes of work. Respond to Freedom of Information Requests and other adhoc reporting requests in order to inform Adult Social Care and Housing or other areas of the council as required. Information, data, feedback and analysis is the heart of what we do, to understand the needs of our population now and into the future.
Key Responsibilities:
Extract data using SQL
Visualise data using Power BI
Contribute towards statutory data collections and surveys for Adult Social Care and Housing
Contribute towards developing data analytics to project future demand
Develop ways to improve data accuracy and quality
Respond to Freedom of Information Requests and any other adhoc requests for information, data and analysis
Work Style
At North Somerset Council, we offer a hybrid working environment based on four distinct work styles. Depending on the role and personal circumstances, you will fall into one of these categories. However, please note that during the induction period, it may be necessary to spend more time in the office to support your learning and development. We are flexible and open to discussions about your preferred working style, and if you wish to be in the office more frequently, this can be negotiated.
This role falls into the category of Mobile Worker which means you can expect to work in the following way:
0-1 day in the office
Includes field workers who primarily work remotely.
Comes into the office for meetings or focused work. Virtual connections with the team are essential, with portable technology supporting work on the go.
About You
We are looking for an individual who is passionate about data, analysis and preferably Adult Social Care and who possesses the following skills and experience:
Essential Criteria:
Demonstrable experience of using SQL to extract data from a data warehouse
Demonstrable experience of using Power BI
Knowledge of Adult Social Care and Housing
Desirable Criteria:
Advanced knowledge of Adult Social Care and Housing
Recognised qualification in Power BI / SQL
What We Offer
At North Somerset Council, we value our employees and provide a supportive and inclusive work environment.
We offer:
Competitive salary and benefits
Flexible working arrangements
Opportunities for professional development
Staff groups
Opportunity to purchase up to an additional 10 days annual leave each year
Dedicated Wellbeing Team
Salary sacrifice cycle to work and Electric vehicle schemes
Further details of our excellent rewards package can be found in our Benefits booklet.
How to Apply
If you share our vision and values and are ready to make an impact to North Somerset, please select the apply button below. If you are interested in this exciting opportunity, please submit your application by 11.59pm on the application closing date. When completing our online application form, please detail how you meet the essential criteria for the role.
Contact Information
For further information about the role, please contact Abby Murphy, Principal Business Intelligence Lead, by email abby.murphy@n-somerset.gov.uk.
Important Information
Interview Date: Tuesday 17 December 2024.
We are currently only able to accept applications from candidates who have full permission to work in the UK.
Equal Opportunities
At North Somerset Council we want all our employees to feel valued and appreciated. We aim to ensure equality of opportunity and prevent discrimination irrespective of your sex, gender identity, sexual orientation, religion or belief, race, age, disability, including neurodiversity, if you are married or in a civil partnership or are pregnant or currently on maternity leave. We strive to create a workplace that reflects the communities we serve and where everyone feels empowered to bring their full, authentic selves to work.
We are committed to safeguarding and promoting the welfare of children and young people and expect all our staff and volunteers to share this commitment.
As a Disability Confident Leader, we guarantee to interview all disabled applicants who meet the essential criteria for the job role.
Proud member of the Disability Confident employer scheme
Disability Confident
About Disability Confident
A Disability Confident employer will generally offer an interview to any applicant that declares they have a disability and meets the minimum criteria for the job as defined by the employer. It is important to note that in certain recruitment situations such as high-volume, seasonal and high-peak times, the employer may wish to limit the overall numbers of interviews offered to both disabled people and non-disabled people. For more details please go to Disability Confident .