Senior Data Engineer OLAP

Senior Data Engineer (OLAP/Semantic Modelling) | 6 Month Contract | £550-600 p/day | Outside IR35We're seeking a highly specialisedData Engineer with deep expertise in OLAP, Tabular, and Multidimensional modellingto join a technology-driven organisation on a long-term contract.If you have strong SSAS, semantic modelling, and Excel cube integration experience - this role is for you.This is a hands-on, onsite position where you'll architect and optimise analytical models, build high-performance data pipelines, and design robust semantic layers that directly power business-critical reporting and Excel-based analysis.Required Skills:OLAP, Tabular, Semantoc Layer Expertise:Advanced SSAS Tabular & Multidimensional modelling(MUST have)Proven experience degsemantic layers, calculated measures, perspectives, hierarchies, partitions, aggregation strategiesStrong Power BI semantic model understanding (datasets, relationships, optimisation)Ability todynamically load data into Excel using OLAP cubes-essentialExpert inDAX / MDX, cube optimisation, processing strategiesData Engineering & SQL:Strong expertise withMSSQL Server(schema design, tuning, indexing, profiling)AdvancedSQLanddimensional data modelling(SCDs, fact/dim, conformed dimensions)Experience withPostgreSQLoptimisation.Advanced Python skillsETL/ELT Pipelines:Hands-on experience building pipelines using SSIS, dbt, Airflow, or similarStrong understanding of enterprise ETL frameworks, lineage, and data qualityCloud & Infrastructure:Experience deg and supportingAWS-based analytical infrastructureSkilled in working withS3and integrating cloud sources into data modelsKey Responsibilities:Design, build, and maintainOLAP, Tabular, and Multidimensional modelsused across the businessDevelopsemantic modelsand robust data structures for Power BI and Excel cube connectivityCreate and optimiseETL/ELT pipelinesintegrating data from S3 and diverse source systemsAdminister and tuneMSSQL Server and PostgreSQLfor high performance and reliabilityEnsure model scalability, accuracy, consistency, and rapid processing timesCollaborate closely with BI, reporting, and business teams to improve data accessibility and performanceMaintain secure, scalable cloud infrastructure in AWS supporting analytical workloadsEvaluate and introduce new modelling techniques and performance optimisationsIf you're an OLAP/Tabular Specialist who enjoys complex modelling challenges and building powerful analytical layers that the business relies on daily - we want to speak with you.If this sounds like you, for immediate consideration!Oscar Associates (UK) Limited is acting as an Employment Business in relation to this vacancy.To understand more about what we do with your data please review our policy in the section of the Oscar website. Senior Data Engineer (OLAP/Semantic Modelling) | 6 Month Contract | £550-600 p/day | Outside IR35 We're seeking a highly specialisedData Engineer with deep expertise in OLAP, Tabular, and Multidimensional modellingto join a technology-driven organisation on a long-term contract. If you have strong SSAS, semantic modelling, and Excel cube integration experience - this role is for you. This is a hands-on, onsite position where you'll architect and optimise analytical models, build high-performance data pipelines, and design robust semantic layers that directly power business-critical reporting and Excel-based analysis. Required Skills: OLAP, Tabular, Semantoc Layer Expertise: Advanced SSAS Tabular & Multidimensional modelling(MUST have) Advanced SSAS Tabular & Multidimensional modelling(MUST have) Proven experience degsemantic layers, calculated measures, perspectives, hierarchies, partitions, aggregation strategies Proven experience degsemantic layers, calculated measures, perspectives, hierarchies, partitions, aggregation strategies Strong Power BI semantic model understanding (datasets, relationships, optimisation) Strong Power BI semantic model understanding (datasets, relationships, optimisation) Ability todynamically load data into Excel using OLAP cubes-essential Ability todynamically load data into Excel using OLAP cubes-essential Expert inDAX / MDX, cube optimisation, processing strategies Expert inDAX / MDX, cube optimisation, processing strategies Data Engineering & SQL: Strong expertise withMSSQL Server(schema design, tuning, indexing, profiling) Strong expertise withMSSQL Server(schema design, tuning, indexing, profiling) AdvancedSQLanddimensional data modelling(SCDs, fact/dim, conformed dimensions) AdvancedSQLanddimensional data modelling(SCDs, fact/dim, conformed dimensions) Experience withPostgreSQLoptimisation. Experience withPostgreSQLoptimisation. Advanced Python skills ETL/ELT Pipelines: Hands-on experience building pipelines using SSIS, dbt, Airflow, or similar Hands-on experience building pipelines using SSIS, dbt, Airflow, or similar Strong understanding of enterprise ETL frameworks, lineage, and data quality Strong understanding of enterprise ETL frameworks, lineage, and data quality Cloud & Infrastructure: Experience deg and supportingAWS-based analytical infrastructure Experience deg and supportingAWS-based analytical infrastructure Skilled in working withS3and integrating cloud sources into data models Skilled in working withS3and integrating cloud sources into data models Key Responsibilities: Design, build, and maintainOLAP, Tabular, and Multidimensional modelsused across the business Design, build, and maintainOLAP, Tabular, and Multidimensional modelsused across the business Developsemantic modelsand robust data structures for Power BI and Excel cube connectivity Developsemantic modelsand robust data structures for Power BI and Excel cube connectivity Create and optimiseETL/ELT pipelinesintegrating data from S3 and diverse source systems Create and optimiseETL/ELT pipelinesintegrating data from S3 and diverse source systems Administer and tuneMSSQL Server and PostgreSQLfor high performance and reliability Administer and tuneMSSQL Server and PostgreSQLfor high performance and reliability Ensure model scalability, accuracy, consistency, and rapid processing times Ensure model scalability, accuracy, consistency, and rapid processing times Collaborate closely with BI, reporting, and business teams to improve data accessibility and performance Collaborate closely with BI, reporting, and business teams to improve data accessibility and performance Maintain secure, scalable cloud infrastructure in AWS supporting analytical workloads Maintain secure, scalable cloud infrastructure in AWS supporting analytical workloads Evaluate and introduce new modelling techniques and performance optimisations Evaluate and introduce new modelling techniques and performance optimisations If you're an OLAP/Tabular Specialist who enjoys complex modelling challenges and building powerful analytical layers that the business relies on daily - we want to speak with you. If this sounds like you, for immediate consideration! Oscar Associates (UK) Limited is acting as an Employment Business in relation to this vacancy. To understand more about what we do with your data please review our policy in the section of the Oscar website.