Senior Data Engineer (OLAP/Semantic Modelling) | 6 Month Contract | £- p/day | Outside IR35We're seeking a highly specialised Data Engineer with deep expertise in OLAP, Tabular, and Multidimensional modelling to 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 designing semantic layers, calculated measures, perspectives, hierarchies, partitions, aggregation strategiesStrong Power BI semantic model understanding (datasets, relationships, optimisation)Ability to dynamically load data into Excel using OLAP cubes - essentialExpert in DAX / MDX, cube optimisation, processing strategiesData Engineering & SQL:Strong expertise with MSSQL Server (schema design, tuning, indexing, profiling)Advanced SQL and dimensional data modelling (SCDs, fact/dim, conformed dimensions)Experience with PostgreSQL optimisation.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 designing and supporting AWS-based analytical infrastructureSkilled in working with S3 and integrating cloud sources into data modelsKey Responsibilities: Design, build, and maintain OLAP, Tabular, and Multidimensional models used across the businessDevelop semantic models and robust data structures for Power BI and Excel cube connectivityCreate and optimise ETL/ELT pipelines integrating data from S3 and diverse source systemsAdminister and tune MSSQL Server and PostgreSQL for 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, apply now 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 privacy policy in the privacy section of the Oscar website.
Read Less
