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 Katarina.brown@suffolk.gov.uk  

 

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 recruitment@suffolk.gov.uk 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 

As a modern and effective council, we offer a wide variety of careers to suit people with a range of skills, abilities and ambitions. We offer working options that flex to reflect the way people work today and take the time to understand and support your individual needs. We’re driven to make a positive difference to the world around us and encourage everyone with drive and focus to join us and build an influential and impactful career. Reimagine the possibilities.

In return, you’ll enjoy:

• up to 29 days annual leave entitlement (pro rata), plus UK bank holidays and two paid volunteering days
• membership of a competitive Local Government Pension Scheme (LGPS)
• travel, lifestyle, health and wellbeing benefits
• performance-related annual pay progression, in addition to an annual cost-of-living pay increase
• training and encouragement to expand your knowledge
• a variety of career development opportunities across our organisation
• diverse and active staff networks
• flexible working options, with the right to request flexible working from your first day

Plus lots more!

If you want to know more about our benefits, values and equality commitments please visit our Suffolk County Council careers website (careers.Suffolk.gov.uk).