2 of 2 Permanent SQL Server Analysis Services Jobs in the South West

Job summary Are you a data enthusiast ready to make an impact in Children's Services? We have an exciting opportunity for you to join our Performance and Information team as an Insight Analyst responsible for collating, reporting, and analysing management information within Education and Skills. The role will lead a new mandatory national and local school attendance … to and from a range of systems/sources (e.g., API, SharePoint, MS Excel, CSV, web, databases, JSON) using specialist understanding of BI technologies ((e.g., Microsoft Power BI, SSRS, SSAS) Support services to improve data quality to ensure end-users are making decisions on the best possible data. Understand the impact of using incorrect or incomplete data on … commensurate with this role and responsibilities in support of the delivery of effective council services. Person Specification Experience Essential High proficiency with BI technologies (e.g. Microsoft Power BI, SSRS, SSAS). Extensive experience of reporting tools to extract and combine data (2 years experience minimum). Knowledge of SQL queries; TSQL or PL/SQL. Knowledge of Python More ❯

calculated columns, and KPIsensuring consistency and accuracy across reporting. Optimising data models and queries for performance and scalability. Partnering with the Data Engineer on data modelling (Power BI tabular, SSAS) and ETL requirements. Working with business analysts and stakeholders to translate requirements into impactful reporting solutions. Supporting user enablement: training, documentation, and promoting best practice to enable self-service analytics. … visualisation skills. Ability to manage Power BI environments (workspaces, permissions, deployment pipelines). Solid understanding of data modelling principles and experience with tabular models (Power BI/Azure Analysis Services). Proficiency in SQL for querying and transforming data, including creating reports in Power BI Reporting Services. Excellent communication skills, able to work with More ❯