Performance and BI ANALYST

Purpose of the job

To analyse customer needs to create, maintain and disseminate reports to managers and users in line with statutory and service specific requirements ensuring that reports are accurate and fit for purpose and meet users’ requirements. To implement and maintain data pipelines allowing data to be pulled from systems using a combination of SQL and APIs to a centralised warehouse using Extract Transformation and Load (ETL) processes enabling data analysis across the team. To create, maintain and produce reports that meet the needs of regulatory inspection and for monitoring performance, enabling effective service management, service improvement and the completion of surveys and statutory returns. Further development using Power BI to incorporate data across the entire corporate landscape and create insightful dashboards for partnership work.

Principal Accountabilities

• Establish and analyse reporting requirements.
• Design enhancements to existing reports to meet changes in regulatory requirements.
• Streamlining and automating performance reporting wherever possible.
• Designing and implementing Power BI models from various data sources to create a centralised dashboard.
• Designing and implementing ETL pipelines to support with self-service reporting (Power BI) and enabling larger data sets to be analysed by the performance team.
• Produce usable technical documentation and user guides for applications.
• Development of report design, layout and data definition for reports and logic for performance measures/statutory returns.
• Perform testing and problem resolution of new and enhanced reports.
• Manage implementation/deployment in accordance with change management and other approval procedures.
• Support service areas in using data to drive improvement, contributing proposals for remedial action where required.
• To ensure data contributes towards the Council meeting its statutory duties, particularly in relation to Equalities, regulators and statistical returns.
• Creating and writing reports to provide essential data and information required to support the preparation for external assessment and inspection.
• Provide technical guidance and advice on the suitability/feasibility of requests.
• To provide data and information required for needs assessments to build the Council’s understanding of local needs including the issues affecting minority groups and provide insight for the Council, supported by evidence.
• To ensure data, research, management information and performance reports are accurate and comprehensible for staff, managers and Councillors.
• To undertake specified duties and tasks linked to the Strategy and Performance Team across Directorates.

Organisational Control and Development

• To ensure that working practices and processes are developed that maximise the use of technology to ensure efficient and effective delivery of services to residents.
• To automate performance reporting to meet business needs and provide it via self-serve for clients.
• To develop internal and external service or functional networks to facilitate joint working, sharing of best practice and information.
• To review and develop the structures, procedures and working methods for which the post holder is responsible to ensure an integrated, effective and efficient approach to the delivery of services.

Staff Management and Development

• To demonstrate achievement, drive and ownership to enhance and develop as an individual.
• Develop the skills of colleagues to support the production of reports.
• To lead and support the work of Data Analysts, providing professional and technical guidance on major issues and directly supervising the work of immediate subordinates.
• To line manage staff/agency workers or consultant resources engaged to assist in performance or data work from time to time.

Personal Effectiveness

• To work collaboratively with colleagues to ensure a ‘One Council’ approach to work.
• To establish and develop effective working relationships and productive partnerships with relevant colleagues and partners.
• To deal promptly with all matters requiring the post holder’s personal attention.
• To be fully conversant with relevant statutory provisions and the Council’s constitution, processes and procedures and develop the full range of managerial and professional skills and knowledge to satisfy the requirements of the post.
• To keep up to date and comply with council policies on equality and diversity, health and safety, data protection, freedom of information, financial regulations, standing orders and other statutory and local policies and procedures.

Person Specification

• Degree or equivalent experience.
• Evidence of continuing professional development.
• Relevant technical experience, knowledge and skills/abilities.
• Experience of gap analysis and data quality issues.
• Experience and knowledge of developing and maintaining a reports catalogue and data relationships.
• Experience of data presentation types (Table, Crosstab, Chart).
• Experience of different query structures (Simple, Combined, Merged).
• Understanding of Data Warehouse principles.
• SQL Knowledge - TSQL, Stored Procedures, Common Table Expression (CTE).
• Python.
• Report writing SSRS.
• Power Platform such as PowerApps, Power Automate, Power BI and SharePoint.
• Knowledge of Liquid Logic either Adults’ or Children’s system.
• Understanding of versioning and software lifecycles.
• Knowledge and understanding of the legislation that relates to the handling of data and reporting and recording data.
• Ability to create, test and validate reports and data.
• Able to be a credible adviser to senior managers and Members and demonstrate an insight/appreciation of their perspective.
• Able to develop detailed project plans and monitor their implementation.
• Able to demonstrate a commitment to equal opportunities and customer care.
• Able to work successfully as part of a team, demonstrating a commitment to the team’s aims and objectives.
• High level of IT skills including knowledge of metadata elements (refresh date, owner etc.), experience of multiple source queries (understanding of metrics and aggregates, understanding of contexts and context-specific metrics, understanding of underlying schemas/universes).
• Ability to develop and test to a provided specification and interpret business requirements into a technical specification.
• Comply with our legal responsibilities under the Data Protection Act 2018 and thus General Data Protection Regulation (GDPR), Freedom of Information Act, Environmental Information Regulations and the Privacy and Electronic Regulations and Information Security Standards.