* Suffolk County Council - Endeavour House, Ipswich IP1, 2BX - Hybrid
* £38,223 - £44,305 per annum (pro rata if part time)
* 37 hours per week - Flexible working options available
* Fixed term or Secondment for 12 months (project)
We're focused on making a meaningful difference to communities across Suffolk. Providing managers and practitioners with the right tools and information to do their job effectively leads to improved outcomes for children in Suffolk and their families. As a SQL / BI Developer in the Children and Young People (CYP) Intelligence team you'll be as keen to collaborate and build a bright future as we are. So, to make a positive impact, connect with us and join our team at this exciting time.
Your role and responsibilities
This is a key insight and intelligence role which enables often complex data to be transformed into real intelligence for use in improving the life outcomes of young people in Suffolk. You will have relevant skills and experience to:
* create SQL queries to extract data from our Data Warehouse environments, or modify existing queries to ensure reports are kept up to date
* design user-friendly Power BI dashboards as required to ensure the business has access to all relevant information required to function efficiently
* create efficient Tables and Views based on SQL queries to enable Power BI reports/dashboards to perform as efficiently as possible for the end user
* support Business Intelligence Managers with reports and data, required for statutory and non-statutory requests.
If your application is successful, you will be key in supporting the delivery of a self-service approach towards performance management.
You will need
* significant quantifiable knowledge of SQL with a focus on query building for reporting
* experience in working with large complex data warehouses
* data visualisation experience with Power BI or a similar package where skills may be transferrable
* experience in working with youth justice or other statistical and qualitative information in terms of both locally and nationally produced data
* advanced use of Excel
* knowledge of statistical and analytical methods
* significant problem-solving skills and will have the ability to research and resolve issues that you will face when building reports and writing queries
* experience with Crystal Reports is desirable.
The team
The CYP Intelligence hub team are a group of intelligence analysts, data specialists, and system trainers who work centrally within children services, across the areas of education, early help, 0-19 services, social care, and youth justice. The role of the team is twofold; to develop understanding of data and intelligence across the business through effective oversight of local reporting, and to create the tools and technologies that assist in developing an effective evidence-led approach to service delivery for the people of Suffolk.
How to apply
Step 1 - Read the Job and Person Profile (JPP) (docx).
Step 2 - Click 'Apply Now' to start your online application.
Step 3 - Upload a supporting statement answering the following questions below (no more than 400 words per question). You should use the Supporting Statement template.
1. Can you describe a complex SQL query you've written to extract data from a data warehouse? What challenges did you face, and how did you overcome them?
2. Tell us about a time when you designed a Power BI dashboard for non-technical users. How did you ensure it was user-friendly and met their needs?
3. Tell us about a project where you had to work with multiple data sources, including external partners. How did you approach data integration, and what challenges did you face?
Step 4 - Upload a CV (without name and personal details).
Please note: Without a supporting statement and CV, your interest will not be progressed. Any supporting documents must be in either PDF or MS Word format.
Closing date: 11.30pm, 29 September 2024.
Interview date: Week commencing 7 October 2024
This authority is committed to safeguarding and promoting the welfare of children, young people, and vulnerable adults and expects all staff and volunteers to share this commitment. DBS (Disclosure and Barring Service) checks or police vetting will be required for relevant posts.
#J-18808-Ljbffr