JOB DESCRIPTION
Job Title: Senior Business Intelligence Developer
Directorate & Section/Unit: Children’s Services Business Systems & Management Information
Reporting to: Business Systems and Management Information Lead
Supervisory responsibility for (Level 1 Supervisor): Supervisor Level 1
Salary Grade: PO2
WCF Management Level: Supervisor
Supervisory responsibility: Matrix management for SO2 and SO1 posts
Number of Direct Reports: 5
Our People Values
- Customer Focus – Ensure delivery of a high‑quality service which meets the needs of customers
- Can Do Culture – Be proactive to achieve excellence, finding solutions and creative ways of working
- Freedom within Boundaries – Make constructive change through cohesive decision making, ensuring services are responsive.
Purpose of Job
- You have expert knowledge and skills in the latest Business Intelligence technologies and will work closely with the business when designing, prototyping and delivering new creative and innovative BI solutions.
- You will work closely with customers across the company to enhance our organisation by designing and developing BI solutions that will form a central resource to give WCC and its partners effective and timely information to support service improvement and statutory reporting. You will be given plenty of opportunity to explore your creativity, utilise your skills and gain many more.
- The post‑holder will consult with Service Managers and staff to provide advice on BI solutions, including dashboards, reports and extracts of data for WCC and partner agencies.
Main Activities & Responsibilities
- Lead in the designing, prototyping and delivering of creative and innovative BI solutions for the customer based on the business requirements
- Matrix management of BI Developer and Management Information Analysts within the team
- Provide expert knowledge and guidance to teams and people on technical best practice
- Effectively communicate business requirements clearly to the team to ensure joint understanding. Facilitate requirements elaboration & user story backlog creation and management.
- Lead in the implementation of the agile methodology process within the team and be instrumental in educating other areas of the business
- Collaborate and partner with all parts and levels of the organisation as an expert technical advisor for creative and innovative BI solutions
- Lead in the application of agile techniques to ensure digital solutions meet the requirements of both the business and the user, providing simple, functional, flawless and quick delivery
- Lead on increasing customer satisfaction and engagement by delivering world class BI solutions
- Research and identify BI options for existing and new services to aid service improvement
- Design and Deliver digital solutions using your expert knowledge of SSRS and SQL
- Maintain and apply up to date, specialist knowledge of database concepts, object and data modelling techniques and design principles and assist BI developers in these areas
- Lead on the production & development of BI solutions for services that will be fully functional across all devices
- Provide secure information provision and be aware of developments in security requirements
- Maintain a working knowledge of relevant BI developments and technologies
Generic Accountabilities
- To maintain personal and professional development to meet the changing demands of the job, participate in appropriate training activities and encourage and support staff in their development and training
- To undertake other such duties, training and/or hours of work as may be reasonably required and which are consistent with the general level of responsibility of this job
- To undertake health and safety duties commensurate with the job and/or as detailed in the Directorate’s Health and Safety Policy
- The duties described in this job description must be carried out in a manner which promotes equality of opportunity, dignity and due respect for all employees and service users and is consistent with the Council’s Equality and Diversity Policy
- This post meets Regulated Activity (as defined by the Safeguarding Vulnerable Groups Act 2006 as amended by the Protection of Freedoms Act 2012) and is subject to an enhanced Criminal Records Check (Via the Disclosure Barring Service, DBS) and the relevant children and/ adults barred list(s) checks.
Contacts
In all contacts the post holder will be required to present a good image of the Directorate and the County Council as well as maintaining constructive relationships.
Internal Contacts
- Elected Members, Directors, Heads of Service, Senior Managers, Management Teams, Managers & Staff across all directorates, Project Staff, Governors, Head Teachers, Teachers, Support and other school based staff
External Contacts
- District & County Councils, Government Agencies & Departments, NHS, Clinical Commissioning Groups, Healthcare Professionals, Police, Fire, Probation Service, Educational Settings, Suppliers, Contractors, Service providers, Statutory and Voluntary Organisations, service users, clients, customers, parents & pupils, members of the public, volunteers
Additional Information
- Worcestershire Children First reserves the right to alter the content of this job description, after consultation to reflect changes to the job or services provided, without altering the general character or level of responsibility
- Reasonable adjustments will be considered as required by the Equality Act
PERSON SPECIFICATION
Experience
It is essential that the post holder is
- Expert in designing, prototyping, building and testing BI solutions to deliver world class customer experience
- Expert in system integration
- Expert in agile development and management methods
- Substantial experience in a variety of BI technologies
- Substantial experience of matrix management of staff and project members
- Substantial experience of collaborating and partnering with a wide range of staff
- Substantial experience of creating BI solutions that work across all devices
It is desirable that the post holder has:
- Experience of other public sector organisations
- Experience in using SQL databases
Knowledge, Skills and Abilities
Essential
- Expert ability in interpreting business requirements
- Expert ability to design and prototype BI solutions
- Advanced knowledge of a variety of BI applications and technologies e.g. SSRS, SQL
- Expert ability to self‑manage and matrix manage others
- Expert in agile development techniques
- Excellent written and oral communication skills
Desirable
- Demonstrable skills in extracting data from Microsoft SQL Server databases using SQL and SSRS
- Demonstrable skills in extracting, transferring, and loading data into a SQL Server database from a variety of sources
- Demonstrable skills in construction technical solutions to extract and present data in a variety of formats
Qualifications / Training & Development
Essential
- A relevant degree that contains technical/programming skills or equivalent experience
- Matrix management or evidence of equivalent experience
Desirable
- Training in agile development methods or evidence of equivalent experience
- Certification in Microsoft technologies, particularly SQL
- Certification on Agile development techniques
