Analytics Developer

Portsmouth City Council; United Kingdom; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A local government authority in the UK is seeking an Analytics Developer to support Children’s Services by enhancing reporting capabilities and managing data analytics. The ideal candidate will have advanced SQL and Power BI skills, along with experience in analytics and information management. This role involves developing data products for predictive analytics and collaborating with stakeholders to improve service delivery. The position offers hybrid working, requiring in-office attendance two days a week.

Qualifications

• Relevant qualification or substantial experience in data, statistics, or information management.
• Advanced skills in SQL, Excel, and Power BI (including DAX, Power Query).
• Experience working with large, complex datasets and relational databases.

Responsibilities

• Lead on improving reporting functionality through reports and dashboards.
• Bring together information across Children's Services for better planning.
• Develop technical capabilities for predictive analytics to better target services.

Skills

Advanced skills in SQL

Advanced skills in Excel

Advanced skills in Power BI

Strong communication skills

Experience with large datasets

Knowledge of data protection (UK GDPR)

Education

Relevant qualification in data, statistics, or information management

Job description

The role

The Analytics Developer will report to the Business Intelligence and Reports Development Lead and will support the aims of Children's Services to help improve outcomes for our children, young people, and families.

The Analytics Developer will have responsibility for supporting the development, management and oversight of Portsmouth City Council's information, data and performance about children's services.

Responsibilities

Responsibilities will include:

• Leading on improving reporting functionality through the development of reports, dashboards and self‑service capabilities for Directorate managers and staff.
• Bringing together information, performance and data across Children's Services and beyond, including the Insight Hub master management system (based on Sentinel), in order to support oversight, planning, and the delivery of more effective services by the Council.
• Supporting the strengthening of our analytical capacity such that our commissioning of integrated health, care and education services and placements is better informed by strategic, integrated, evidence‑based analysis.
• Developing technical capabilities and data products that enable predictive analytics, in order to better target our services to meet children's needs at an earlier point.

The ideal candidate

You will need:

• A relevant qualification or substantial experience in data, statistics, or information management.
• Advanced skills in SQL, Excel, and Power BI (including DAX, Power Query, and report publishing).
• Experience working with large, complex datasets and relational databases.
• Knowledge of information governance and data protection (UK GDPR).
• Strong communication skills and the ability to present complex data in accessible ways.
• Organised, adaptable, and able to manage competing priorities.
• Experience in children's social care, education, or special educational needs is desirable.

Important

Please ensure that you read the full job profile attached to the advert for the details and expectations of this role, paying particular attention to the section 'Who is the person' as you will need to refer to the sections relating to Knowledge, qualifications and experience & Abilities / technical skills when completing your Personal statement.

Working Arrangements

We offer hybrid working with the expectation to attend the office a minimum of 2 days a week.

Interview details

Interviews & Assessment will be held in person at the Civic Offices, Portsmouth and will last approximately 2 hours, these will take place between 19th - 30th January 2026.

Contact details for an informal discussion

Please email Joanne Scott ([e-mail]) or Chris Hyde ([e-mail]).

Application process

We anonymise applications during application & shortlisting to ensure only relevant information is considered. As part of your application, you must complete a personal statement, which is crucial for demonstrating how you meet the requirements of the job against each of the points described in the 'Who is the Person' section of the Job Profile using examples from your experience or transferable skills.

Other Information

We are a disability confident employer and a Gold Standard Armed Forces Covenant employer. Please demonstrate that you have the Right to Work in the UK; no post will be offered without it.

About Portsmouth City Council

Portsmouth City Council is a unique organisation, committed to making a difference, and is guided by core values that set who we are as people, what we stand for, and how we act.