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 ..... full job details .....