PowerBI Data Analyst

The advertised role will support a variety of services as well as working to deliver against corporate cross-cutting priorities. You will use data from a wide variety of internal and external sources, carrying out insightful analytics for audiences across various services and various professional roles. As a NLWA PowerBI Data Analyst, you will have a body of knowledge and experience in the skills, tools and techniques of Data Analytics and you will apply to this effectively to support us in delivering for NLWA. You will have significant expertise in the use of PowerBI, including using PowerQuery, combining multiple data sets, building semantic models, and use of DAX expressions. You will also be able to support a build that you did not yourself create. Analysis and synthesis of data: You will apply basic techniques for the analysis of data from a variety of internal and external sources and synthesise your findings. Your analysis will support both service improvement and wider strategy development, policy, and service design work across the organisation. You will effectively involve a variety of data professionals and domain experts in this analysis and synthesis and will present clear findings that colleagues can understand and use. Communication: You will communicate effectively with a number of stakeholders in a variety of roles. You will build strong collaborative relationships with colleagues and host discussions that help define needs and generate new insights. You will be an advocate for the team and can manage differing perspectives and potentially difficult dynamics. Data management: You will understand data governance and how it works in relation to other organisational governance structures and will be a proactive participant in and promoter of NLWA’s data governance practices. You will use your experience to manage data, ensuring adherence to standards and maintaining data dictionaries. You will effectively manage risk to privacy in adherence to national legislation and local practices. Data modelling, cleansing and enrichment: You will be able to produce data models / dashboards, maintain existing ones, and understand where to use different types of data models, developing NLWA’s business intelligence architecture in collaboration the rest of the digital, data and technology team. You will have understanding of different tools and industry-recognised data-modelling patterns and standards, comparing different data models, communicating data structures using documentation such as schema diagrams. Data quality assurance, validation and linkage: You will identify appropriate ways to collect, collate and prepare data as set by the digital, data and technology team. You will make judgments as to whether data are accurate and fit for purpose and will support services in maintaining good data quality through the development of data quality auditing systems. You will define and implement batch cleansing processes where appropriate with limited guidance. Data visualisation: Your work will take advantage of a wide variety of data visualisation tools and methodologies, mostly in PowerBI, presenting complex information in a way that is engaging, useful and readily intelligible to a range of audiences such as staff, borough officers, managers, and senior leadership. You will present, communicate, and disseminate data appropriately and with influence in settings ranging from operational meetings to borough officer meetings. IT and mathematics: You will apply your knowledge and experience of IT and mathematical skills, including tools and techniques. You can adopt those most appropriate for the environment and always work in a manner that is sensitive to information security. You will use your experience of using a variety of tools and techniques, but especially PowerBI. Logical and creative thinking: You will respond effectively to problems in databases, data processes, data products and services as they occur. You will initiate actions, monitor services, and identify trends to resolve problems. You will take responsibility for determining innovative solutions and assist with their implementation, and with preventative measures. Your analysis will involve creative interaction with data that takes innovative approaches to generating insight and answering business questions. Project management: You will apply your knowledge and experience of project management methodologies, including tools and techniques, adopting those most appropriate for initiatives such as the development of new reporting solutions or delivery of statutory returns. You will collaborate with colleagues in a variety of roles to achieve objectives. Statistical methods and data analysis: You will understand how and when to practically apply existing best practice solutions. You will use your experience of processing data using statistical techniques such as sampling, regression, averages, clustering to generate insight and answer business questions.