4 of 4 Remote/Hybrid SQL Server Analysis Services Jobs

within our Business Intelligence team. You will help ensure that the Trust's data is secure, accurate, timely and ready to support reporting, analysis, national submissions and informed decision-making, contributing to improved services, productivity and patient care. The team has a hybrid working pattern with … tools and concepts Experience Essential Significant experience developing Microsoft BI solutions, including SQL Server (2016 or later), SSIS, SSRS and SSAS Experience of writing Python scripts Experience querying data and developing reports or dashboards in Power BI or other BI tools Experience developing ETL routines ...

reporting solutions, working closely with analysts and developers to deliver high-quality BI solutions. The Role: Develop and maintain ETL processes, data warehouses and SSAS cubes. Build and enhance data and semantic models, including advanced DAX calculations. Write and optimise SQL queries and stored procedures. Support testing, quality … deliver scalable, reliable BI solutions. The Requirements: Strong SQL Server and T-SQL development experience. Experience with SSAS multidimensional and Tabular models, including DAX. Knowledge of ETL processes, data warehousing and dimensional modelling. Familiarity with Azure data services and modern data platforms. ...

integration processes Writing, optimising, and troubleshooting complex T-SQL queries and stored procedures Building and enhancing semantic and tabular data models Supporting SSAS cube development and DAX calculations Applying dimensional modelling and data warehousing best practices Collaborating with business and data analysts to translate requirements into technical solutions … data warehousing concepts and dimensional modelling Experience working with semantic models, tabular models, star schemas, Kimball methodologies, or similar data modelling approaches Exposure to SSAS, DAX, and BI solution development Experience working across different data architectures and technology environments Strong problem-solving and stakeholder communication skills Ability to work independently ...

solutions that meets the ever-increasing organisational need for real time operational data. Your key skill set will include Microsoft ETL Stack (SSIS and SSAS), analysing and reporting on large, complex data sets and experience of using appropriate tools for data visualisation and reporting. About us Our commitment … support of ETL processing solutions. Develop expert knowledge of BI implementation methodologies and in-depth experience with the Microsoft BI ETL Stack (SSIS, SSAS). Design, create, implement, and update reference tables as and when required. Design and produce thorough and detailed test plans and scripts which are adopted prior ...