SQL/BI Developer
- 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.
Reimagine the possibilities
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.
You can view a full list of requirements in the Job and Person Profile (docx). If you believe you can succeed in this role, apply. Even if you don`t meet all requirements, still apply. We would appreciate the opportunity to consider your application.
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.
Empowering Everyone
We’re big believers in potential, possibility and the power of different ideas. We’re always searching for ways to encourage, respect and enable everyone to be the best they can be. We want to represent the diverse communities we serve. We welcome applications from all individuals, especially those from groups that are currently underrepresented in the organisation, as shown in our Workforce Equality Report.
For more information
Please contact Katarina Brown (she/her) for a casual conversation. You can reach her by calling (01473) 265173 or emailing [email protected]
If you want to apply for a secondment, read the secondment policy first. Make sure you get permission from your current manager before submitting your application.
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.
If you require any reasonable adjustments to the application process before the next selection stage, please contact our Recruitment Team by emailing [email protected] or calling 03456 014412. If you are invited to the next stage of selection, you will have another opportunity to request adjustments for the next stages of the process.
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. #LI-Hybrid
SQL/BI Developer job opportunities 2025, SQL/BI Developer Jobs 2025, SQL/BI Developer job opening 2025, SQL/BI Developer job vacancies 2025, SQL/BI Developer job descriptions 2025, SQL/BI Developer job listing 2025 Suffolk job opportunities 2025, Suffolk Jobs 2025, Suffolk job opening 2025, Suffolk job vacancies 2025, Suffolk job descriptions 2025, Suffolk job listing 2025 Ipswich, Suffolk, United Kingdom job opportunities 2025, Ipswich, Suffolk, United Kingdom Jobs 2025, Ipswich, Suffolk, United Kingdom job opening 2025, Ipswich, Suffolk, United Kingdom job vacancies 2025, Ipswich, Suffolk, United Kingdom job descriptions 2025, Ipswich, Suffolk, United Kingdom job listing 2025, New Zealand Postal Service Jobs 2025, New Zealand Postal Service job opportunities 2025, New Zealand Postal Service job opening 2025, New Zealand Postal Service job vacancies 2025, New Zealand Postal Service job descriptions 2025, New Zealand Postal Service job listing 2025
For more information please click the link below