Knowsley Council is an award-winning Local Authority, named Local Authority of the Year in the Municipal Journal Awards 2024.

We are an Accredited employer under the Liverpool City Region Fair Employment Charter, demonstrating that we are committed to the principle of fair employment and we are dedicated to providing a healthy, fair, inclusive and just workplace.

Come join us and be part of our success.

Knowsley Council has a well-established, integrated Performance and Business Intelligence team supporting a range of services including Special Educational Needs (SEND), Education, and Children’s Social Care.

We are seeking a skilled and motivated Intelligence Officer to help us deliver high-quality data solutions that drive service improvement and better outcomes for children and families.

The successful candidate will play a key role in designing, developing and implementing Power BI dashboards and reports to support the ongoing rollout of our Children’s Services performance framework. You’ll work closely with colleagues across the service, translating complex data into clear, actionable insights.

Key Responsibilities:

• Write and optimise SQL queries to extract and transform data from multiple sources.
• Develop and maintain Power BI dashboards and SSRS reports that support performance monitoring and strategic planning.
• Collaborate with service managers, practitioners and senior leaders to understand reporting needs and deliver tailored data solutions.
• Communicate data insights clearly and effectively to a range of stakeholders.
• Support the development of data models and performance frameworks aligned to service priorities.

The role requires:

• Ability to produce and present accurate, clear and concise reports and management information in a variety of formats for different audiences.
• Excellent interpersonal skills and a proven ability to work across multiple services areas or agencies.
• Ability to work as part of a team engaged in multiple projects, managing competing demands, and delivering work to tight timescales.

To be considered for entry at grades J or K:

• Experience of using reporting and analysis tools such as Power BI, SSRS, SQL to extract and analyse information from databases.
• Experience of establishing and maintaining systems for the collection and interpretation of large, complex data sets.
• Excellent communication and presentation skills, including the ability to tailor the presentation of data/ intelligence for specific audiences to enable planning and decision-making.

At Knowsley Council we will consider requests for flexible working.  For most roles, the following types of flexibility are usually possible: flexible hours, working from home, compressed hours, part-time.

We welcome applications from residents and beyond, regardless of background, belief, or identity, recognising the value that diversity brings to our organisation. We particularly welcome applications from individuals from Black and Minority Ethnic backgrounds and candidates with disabilities as we acknowledge their underrepresentation in our workforce.

See the benefits of working for Knowsley MBC https://www.knowsley.gov.uk/yes.

We reserve the right to close this vacancy earlier than the specified date should we receive sufficient applicants.

At Knowsley we value our applicants and want them to feel well-informed and welcomed. If you have any questions about this specific job role or what it is like to work at Knowsley, please contact:  John Johnson – john.johnson@knowsley.gov.uk  or alternatively Liam Griffiths – liam.griffiths@knowsley.gov.uk

If you are interested in this vacancy, please upload your CV along with a supporting statement as one document in PDF or Word format. Your CV and supporting statement should be tailored to reflect the competencies within the person specification.

Please note if a CV and supporting statement does not reflect the person specification it is unlikely to be shortlisted.