SQL/BI Developer

Job description

Job responsibilities

Please do not apply on this site and head to Suffolk Jobs Direct to apply.

Main purpose of the job

The postholder will design, build and maintain a suite of high-quality SQL data extracts and Power BI dashboards to support the Childrens Community Health Service, within the Public Health & Communities & Public Safety directorate, bringing together data from local authority systems and health datasets to provide clear, reliable insight. The Childrens Community Health Service includes Health Visiting and School Nursing, and the role will support the service by creating reporting to support the understanding of performance, productivity, demand, outcomes and inequalities, turning complex information into clear, usable insight that informs decision-making and action.

This is a key role in enabling a more selfservice approach to performance and operational reporting, improving the accessibility, governance and interpretation of information for service leads and colleagues across the wider system.

Typical responsibilities of a role at this level

Deliver high-quality business intelligence products (SQL data assets and Power BI dashboards) that enable colleagues to understand and improve services and outcomes.

Work proactively with service leads to understand questions, translate needs into clear reporting requirements, and agree definitions/metrics.

Develop, improve and maintain SQL queries, views and tables that are accurate, efficient and fit for reporting/analytics use.

Build well-designed Power BI dashboards that are clear, accessible and that perform well for end users.

Apply strong quality assurance: validate figures, investigate anomalies, and identify data quality issues, escalating and feeding back to teams where action is needed.

Ensure work complies with GDPR, information governance and confidentiality requirements, using appropriate controls and safe working practices.

Manage competing priorities and deadlines, planning and organising work effectively with minimal supervision.

Maintain clear documentation for data models, measures, definitions and refresh processes so that products can be supported and maintained.

Contribute to continuous improvement of reporting standards, automation, performance optimisation and reusable data assets.

Build positive working relationships with internal and external partners (e.g., health and care colleagues) where shared data and reporting are required.

Work autonomously, taking ownership of problems, researching solutions and driving work forward as a self-starter.

Share learning and good practice, supporting the development of colleagues and promoting effective use of BI tools and reports.

About the team

The role sits within the Knowledge, Intelligence & Evidence (KI&E) team in the Public Health and Communities and Public Safety directorate. KI&E is an award-winning team that provides accessible, high-quality analysis and insight to support decision-making and reduce inequalities. The team uses modern analytical tools and creates interactive dashboards and reports that turn complex data into clear stories about trends, patterns and key messages.

In this post you will work closely with colleagues supporting the Childrens Community Health Service, helping to develop consistent reporting that supports day-to-day operational management, longer-term service improvement and supports improved outcomes for children living in Suffolk.

What you will be expected to deliver in the role

• Create and maintain SQL queries to extract data from data warehouse environments (and/or adapt existing queries) to keep reporting accurate and up to date.
• Design and develop clear, user-friendly Power BI dashboards so the service has access to the information it needs to manage performance and improve outcomes
• Create efficient SQL tables/views that support strong Power BI performance and a reliable reporting layer.
• Maintain, enhance and update existing dashboards and data models as definitions evolve and new information becomes available.
• Support managers and analysts with data extracts and reporting for both routine and ad-hoc/statutory requests.
• Review and analyse report outputs to identify data quality issues, system/process issues, and areas requiring follow-up with operational teams.
• Work with stakeholders to gather requirements, attend meetings where needed, and ensure reporting is fit for purpose and used well.
• Work with internal and external partners where data is shared to support joined-up reporting and insight.

Day to day tasks may include:

• Meeting service colleagues to clarify questions, agree measures/definitions, and prototype dashboard layouts.
• Writing and optimising SQL (including troubleshooting and performance tuning) and creating/revising views and tables.
• Building Power BI datasets/models (relationships, measures, calculations) and producing polished report pages with strong usability.
• Validating outputs against source systems/known totals and documenting definitions so reports are trusted and repeatable.
• Maintaining refresh schedules and resolving refresh/data issues to keep dashboards reliable.

Person Specification

Qualifications

• Qualification in a relevant subject at Level 6 (degree level) or equivalent knowledge and experience gained through employment/learning.

Employer details

Employer name

Suffolk County Council

Address

8 Russell Road

Ipswich

Suffolk

IP1 2BX

United Kingdom

Employer's website

https://careers.suffolk.gov.uk/