Job title: Principal Business Intelligence Officer
Salary: PO4 £44,711 to £47,754
Hours: 37
Contract: Permanent
Location: Leeds/Hybrid
As a Principal Business Intelligence Officer, you’ll thrive on delivering automated data pipelines, business intelligence solutions, including visualisation of data. A key requirement will be to work with business teams across the Council to design, develop, test and deliver data products and solutions. In doing so, you will need to ensure that data standards and data quality improvements are implemented. You will also be expected to maintain strong and productive working relationships with stakeholders.
Leeds City Council is one of the largest employers in the region with over 14,000 employees. We seek to recruit and develop talented individuals who embody our council values and ambitions - Best City Ambition
About you
As a Principal Business Intelligence Officer, you will bring to the role:
- Ability to interpret business requirements and develop automated data pipelines and reporting solutions.
- Ability to develop automated dataflows and transformations using recognised data management software, such as Azure and Microsoft Fabric.
- Ability to develop reports using recognised business software tools, such as Microsoft Power BI, and adapt to new tools as required.
- Ability to produce comprehensive high quality reports that are intuitive and respond to the needs of the business.
- Excellent analytical skills.
- A solutions-focussed attitude and way of working.
- Ability to fully participate within an effective team environment and win the confidence and trust of colleagues.
About the role
As our next Principal Business Intelligence Officer, you will;
- Provide advice on a range of issues relating to optimising the value from the data and information in council systems.
- Develop automated data solutions, therefore removing manual processing and driving up the efficiency of the Council.
- Promote activities to improve data quality and apply robust data governance standards to ensure the integrity of data across Council systems.
- Ensure the integrity of reporting is maintained through changes to Council systems.
- The role is integral to our service.
What we offer you
We take pride in offering the best employee experience, with benefits including:
- a competitive salary and annual leave entitlement plus statutory holidays
- membership of the West Yorkshire Pension Fund with generous employer contributions
- flexible and hybrid working arrangements subject to service requirements
- a clear career pathway and continuing professional development opportunities
- a range of staff benefits to help you boost your wellbeing and make your money go further
How to apply
Please complete the online application form.
Read our guidance for further advice. Please check your information carefully and ensure you complete all sections before submitting your application.
We welcome applications from everyone and actively seek a diverse range of applicants from all backgrounds and cultures. We particularly encourage applications from, but not limited to, women, carers, veterans as well as LGBT+, ethnically diverse, disabled and care experienced people.
This role is based in the UK. Home Office guidance states that candidates must evidence their right to work in the UK prior to commencing employment, either as a UK or Irish citizen, under the EU Settlement scheme or having secured any other relevant work visa.
If you do not have the right to work in the UK, you must consider your own eligibility for sponsorship for a particular role through the Skilled Worker visa route before applying. To be eligible for sponsorship you'll usually need to be paid the standard salary rate of at least £38,700 per year or meet one of the other eligibility criteria. Ensure you are eligible before applying.
Job Description
Job purpose
Working with business teams, ensure that end-to-end business intelligence solutions are identified, specified accurately, developed, tested and delivered. This may involve a range for data activities including automated ingestion, transformation and visualisation. Ensuring data standards and data quality improvements are implemented is key to this role. Ensure that strong and productive working relationships with stakeholders are maintained with stakeholders as appropriate.
Responsibilities
- Maintain up-to-date documentation and procedures relating to data and reporting processes.
- Working with the Business Partners to ensure that business requirements are captured and translated into detailed specifications.
- Develop effective solutions to business reporting and intelligence requirements, using the tools and data available.
- Ensure there is an appropriate testing routine for all new reports.
- Work collaboratively with colleagues within the team and more widely across the directorate and in ICT on specific programmes of work.
- Advise on the impact of technology and software changes in relations to reporting.
- Working closely with the Council Performance Service, ensure that reporting requirements are met in a timely manner to meet government and local reporting timeframes
- Design, develop and test reports and queries as required by the business.
- Line management of Assistant Business Intelligence Officer(s) including their supervision, appraisal and effective performance management of team
- Participate in training and development activities as necessary to ensure up to date knowledge, skills and continuous professional development.
- Undertake other duties appropriate to the post as required by the Business Intelligence Manager
- Exhibit the Council’s Values in the role and comply with the requirements of all Leeds City Council and Departmental policies, procedures and staff instructions including responsibilities under Health and Safety Policy and Procedures.
- Promote and support the Council’s Policies on Equality and Diversity
- The duties outlined are not meant as an exhaustive list and will also comprise any other duties within the spirit of the post commensurate with the job evaluation outcome for this post.
Qualifications
Essential requirements Candidates will only be shortlisted if they can demonstrate that they meet all the following essential requirements.
Skills required
- Ability to interpret business requirements and develop and test reports.
- Ability to interpret national and local policy and apply within statutory and business reporting.
- Ability to develop reports using recognised business software tools and adapt to new tools.
- Ability to produce comprehensive high quality reports.
- Excellent analytical skills.
- Ability to fully participate within an effective team environment and win the confidence and trust of colleagues.
- Ability to provide visible and supportive management which empowers staff to achieve individual and collective outcomes.
- Ability to manage competing priorities.
- Strong communication skills and the ability to communicate complex or politically sensitive issues to a range of partners.
- Skilled in quickly developing productive, working relationships with internal and external partners that command respect, trust and confidence and achieve positive outcomes.
Knowledge required
- Significant knowledge and understanding of national policy implications in relation to the relevant service area and how this impacts on statutory and business reporting.
- Of data quality improvement activities and data governance issues.
- Of the use and application of business intelligence software.
- In depth knowledge and understanding of data structures and how these impact on business intelligence.
- An appreciation of all of the processes involved in systems development and how system changes can impact on reporting.
- Comprehensive understanding of the Data Protection Principles and the Data Protection Act.
Experience required
- Extensive experience of working in a business intelligence environment.
- In-depth experience of using Information Technology in support of Business Intelligence.
- Experience of working with large, complex and sensitive data sets.
- Of interpreting business requirements from colleagues with little or no technical IT expertise.
- Of liaising with stakeholders.
- Of working effectively within a team.
- Excellent Microsoft Office user
Behavioural & Other Related Characteristics required
- A demonstrable knowledge, understanding and commitment to the council’s core values
- Committed to continuous improvement.
- Demonstrable understanding of an equal opportunities approach in both employment and in service delivery.
- To carry out all duties having regard to an employee’s responsibility under the Council’s Health & Safety Policies.
Essential Behavioural & other Characteristics
- Understand and embrace Leeds City Council Values and Behaviours and codes of conduct
- Committed to continuous improvement in all areas and work towards delivering the Best City Ambition of Health & Wellbeing, Inclusive Growth and Zero Carbon
- Able to understand and observe Leeds City Council policies and procedures.
- Carry out all duties having regard to an employee’s responsibility under Health, Safety and Wellbeing
- Willingness to actively participate in appraisal, training and development activities to ensure up, to date knowledge and skills.
- Flexible and adaptable to change to assist other services as required commensurate to grade.
- Be aware of and support difference and ensure equality for all working in an anti-discriminatory manner, upholding, equality & diversity of Leeds City Council.
- Recognise and appropriately challenge any incidents of racism, bullying, harassment, victimisation, and any form of abuse, reporting any concerns to the appropriate person
- The Council has adopted a flexibility protocol and the role will be expected to work within these parameters.
