4 of 4 Remote/Hybrid Permanent 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 ...

planning for legacy components Core Technical Skills Azure Synapse & Data Platform Mandatory hands-on expertise with: Azure Synapse Analytics (Pipelines, Spark Pool, Dedicated SQL Pool) Azure Data Lake Storage Gen2 (ADLS Gen2) Delta Lake on Azure (Synapse Lakehouse patterns) Oracle Golden Gate Replication for real-time source integration … Azure Analysis Services and Power BI consumption layer patterns Deep understanding of medallion architecture: Raw/Harmonized/Conformed/Consumption layers Strong knowledge of SCD Type 0/1/2, CDC patterns, soft/hard delete, and retroactive change processing Experience with Synapse SQL ...

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 ...