Performance and BI ANALYST

Job Description
Management Group:                 Finance and Corporate Services
Department:                                 Strategy, Performance and Complaints
Section:                                           Strategy and Performance
Job Title:                                Performance Business Intelligence Officer                  
Reports to:                                    Senior Data 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
Implementation
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 & 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 & diversity, health & safety, data protection, freedom of information, financial regulations, standing orders and other statutory and local policies and procedures.
Person Specification
Management Group:                 Finance and Corporate Services
Department:                                 Strategy, Performance and Complaints
Section:                                           Strategy and Performance
Job Title:                                Business Intelligence Engineer

Degree or equivalent experience
Evidence of continuing professional development

(b) Relevant technical experience, knowledge & 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 Childrens� system 
Understanding of versioning and software lifecycles 
Knowledge and understanding of the legislation that relates to the handling of date
 and reporting and recording data  (c)  Other Additional Requirements

Ability to create, test and validate reports and data.
Able to be a credible adviser to senior managers & 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 & 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
Only candidates based in UK and eligible to work in UK are allowed