Business Intelligence and Reports Development Lead

Portsmouth City Council; Portsmouth; Hybrid; GBP 45,000 - 60,000; Full time

Job summary

Portsmouth City Council seeks a Business Intelligence and Reports Development Lead to enhance outcomes for children and young people. This role involves managing a team, extracting and analyzing data, and ensuring timely reporting. Ideal candidates will possess strong leadership, analytical skills, and experience in Business Intelligence within social care.

Qualifications

• Proven experience in a leadership role within a Business Intelligence/reporting environment.
• Strong knowledge of the Mosaic case management system.

Responsibilities

• Manage a team of report developers within Children's Services.
• Deliver and maintain high-quality Business Intelligence outputs.

Skills

Leadership

Analytical Skills

Problem Solving

Communication

Education

Experience in Business Intelligence

Experience in Social Care

Tools

Power BI

SQL Server Reporting Services (SSRS)

SQL Server Integration Services (SSIS)

Azure Data Factory

Job description

This role will be part of the Commissioning and Performance service which sits within the Children, Families and Education directorate. The Strategic Intelligence will report to the Head of Planning and Partnerships and will support the aims of the Children's and Families services to help improve outcomes for our children and young people.

The Role

The Business Intelligence and Reports Development Lead supports Children and Families services through extraction of data and analysis from various case management systems to enable case holders to support their case work, for managers to track performance of their teams, and for senior management to make informed strategic decisions to help improve outcomes for children and young people.

The post holder will manage a team of report developers within the Children's Services department. The lead will leverage their experience in similar leadership positions to maximise the capabilities of the existing team, processes, and report/BI outputs. They will propose and implement programs of improvement and efficient development practices. Additionally, the lead will be responsible for delivering and maintaining a robust and successful reporting offering to Children's Services, ensuring that the department's data needs are met with high-quality, timely, and accurate Business Intelligence outputs. This role is crucial in supporting the department's strategic objectives and enhancing its ability to respond to service demands and requirements.

The ideal candidate

We are looking for someone that has a thirst for knowledge and wishes to use their problem solving skills to find innovative solutions to complex problems; to be able to suggest or explore key lines of enquiry and work intuitively within systems to develop data sets and analysis.

You will need to have/be

Qualifications

• Proven experience in a leadership role within a Business Intelligence/reporting environment.
• Strong knowledge of the Mosaic case management system.
• Experience working in a social care environment.
• Broad understanding of various reporting tools and infrastructures.
• Technical competence in Business Intelligence reporting.
• Experience in administering reporting tools and managing workspaces.

Skills

• Excellent leadership and team management skills.
• Strong analytical and problem-solving abilities.
• Effective communication and interpersonal skills.
• Ability to work under pressure and manage multiple priorities.

Technical Competencies

• Proficiency in Microsoft Business Intelligence and reporting tools, including:
• Power BI
• SQL Server Reporting Services (SSRS)
• SQL Server Integration Services (SSIS)
• Azure Data Factory
• Experience in the development of Power BI reports and dashboard development

Please ensure that you read the job profile for full details on the post.

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

If you would like to discuss this role in more detail with the hiring manager, please contact Hayley Webb email [e-mail]

Application process

We anonymise applications during application & shortlisting to ensure only relevant information is considered.

As part of your application we ask that you complete a personal statement, this statement is crucial and is where you must demonstrate how you meet the requirements of the job against each of the points described in the 'Who is the Person' points on the Job Profile using examples from your experience or transferable skills. This might be through qualifications or descriptive examples from your work / personal experience.

We are a disability confident employer and Armed Forces Covenant gold standard. More information can be found at Equality, diversity and inclusion - Careers portal

You will need to demonstrate that you have the Right to Work in the UK. No post will be offered without it.

Please note we reserve the right to close the advert early if we have a successful applicant.

We are committed to our values of respect, integrity, collaboration, inclusivity and being people-focussed. These values set out how we can contribute to the success of the council and our own success as individuals.Learn more about our values and behaviours.

About Portsmouth City Council

What we can offer you:

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.

Read more about working at Portsmouth City Council and our benefits on our careers portal homepage: Careers Portal - Find jobs with Portsmouth City Council

Should you require any support in completing the application form please contact [e-mail]. or call the recruitment team on 023 92 616800