26 to 50 of 50 Dimensional Modelling Jobs in the UK excluding London

configure row-level security (RLS).What You BringSignificant hands on experience productionising Power BI reports and managing live estates. Deep expertise in DAX, dimensional modelling (star schema), and layered data architectures. Demonstrable excellence with SQLExposure to Microsoft Fabric, Azure Synapse, or Azure Data FactoryHigh technical rigor and diplomatic ...

data models and transformation pipelines that support reporting, analytics, and business decision-making. Key Responsibilities: Lead the design and development of curated, analytics-ready dimensional and semantic data models. Build, maintain and optimise complex SQL and PySpark transformation pipelines within Databricks. Define and maintain KPI definitions, conformed dimensions … consistent business logic across data domains. Ensure data quality, integrity, testing, observability and performance across the curated data layer. Lead modelling design reviews and contribute to technical and architectural decisions. Work closely with Data Architects, BI Developers, analysts and business stakeholders to translate requirements into effective data solutions. Establish ...

behind every report and every operational data feed at ECP, continue the migration of our data warehouse and data lake to a modern dimensional model, finish the rollout of a principle-of-least-privilege security model across a multi-server SQL estate, and continue the migration of our reporting … include: \n · Setting and personally delivering target architecture for the ECP data estate — the data warehouse, data hub, data lake, raw/ODS layers, dimensional model, audit and schema-change tracking, and the load schedules that tie them together. \n · Hands-on T-SQL, stored procedure, ETL framework ...

London 3 days a week. \n \n \n How you'll make an impact \n \n \n \n \n Data Analysis & Modelling\n \n Analyse complex insurance datasets across policy, claims, underwriting, finance and regulatory domains. \n Develop logical and physical data models to support reporting, analytics and operational … lineage \n Previous experience and an understanding of Policy/Claims data elements would be a preference. \n Knowledge of data warehouse principles i.e. Dimensional modelling, Kimbal, Start Schemas, incremental loading, master data management etc \n Understanding and ability to profile data and identify Data Quality issues ...

Experience Strong experience with Microsoft Fabric, Azure Databricks and Azure Data Factory. Solid knowledge of Delta Lake, Medallion Architecture, PySpark and SQL. Expertise in dimensional modelling and star schema design. Advanced Power BI development, including DAX and semantic modelling. Experience with Azure security, governance, DevOps and CI/ ...

using Azure DevOps Desirable Skills Experience with Kafka and real-time or streaming data solutions Exposure to Debezium and CDC frameworks Knowledge of Kimball dimensional modelling and enterprise data warehouse design principles If this Data Engineer role sounds like a good fit, you can work 3 days ...

troubleshooting complex SQL Server and T-SQL solutions. Creating and enhancing semantic and tabular data models. Supporting SSAS cube development and DAX calculations. Applying dimensional modelling and data warehousing best practices. Working with analysts and stakeholders to translate business requirements into technical solutions. Investigating and resolving data quality … Skills & Experience You will have strong commercial experience with: SQL Server and SQL development. ETL development and data pipeline engineering. Data warehousing principles and dimensional modelling. Star schema, Kimball methodologies, semantic models, and tabular models. DAX. Working within fast-paced delivery environments. Communicating effectively with both technical ...

will: Build and maintain ETL processes and data pipelines. Develop and optimise SQL Server and T-SQL solutions. Design and enhance semantic, tabular, and dimensional data models. Support SSAS cube development and DAX calculations. Work closely with data and business analysts to translate requirements into technical solutions. Troubleshoot data … Server and T-SQL development. Proven ETL development and data pipeline experience. Solid understanding of data warehousing principles and best practices. Experience with dimensional modelling, including concepts such as star schema, semantic models, tabular models and Kimball methodologies. Exposure to DAX development. Experience working across complex data environments ...

Requirements Strong understanding of finance processes including General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Budgeting and Forecasting. Knowledge of DAX, Power Query and dimensional modelling techniques. Experience supporting global finance functions and multi-currency reporting. Knowledge of manufacturing environments and associated finance processes. Experience supporting ERP implementation ...

understanding of finance processes including General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Budgeting and Forecasting. \n \n Knowledge of DAX, Power Query and dimensional modelling techniques. \n \n Experience supporting global finance functions and multi-currency reporting. \n \n Knowledge of manufacturing environments and associated finance processes. ...

maintained on a regular basis. Technical Skill Expert-level Databricks experience Advanced PySpark development Delta Lake architecture and optimisation Databricks SQL Data warehouse Dimensional modelling Data Lake Databricks Genie Python development Key Skills, Experience and Knowledge Extensive Data Engineering experience within enterprise-scale data environments. Extensive hands ...

unique ingredients we’re interested in: An experienced analyst with advanced Power BI, SQL, DAX and Power Query capability, together with strong relational and dimensional modelling knowledge. Confident working with senior stakeholders, challenging assumptions and turning complex or ambiguous questions into high-value analytical outcomes. Experienced in owning ...

. Must be an expert in Microsoft Azure Asset Bundles in Databricks STAR Schemas Medallion Architecture expert Expert in MS Fabric Expert in Data Modelling & Data Schema creation including measures, calculations, KPI's & CDE's Understanding of database management systems and ETL (Extract, transform, load) framework Understanding … Azure data lake design (e.g. dimensional modelling) and data mining Business Skills Proven abilities to take initiative and be innovative Analytical mind with a problem-solving aptitude Ability to coach and influence end users/business area data analysts. Ability to work well within a team Ability ...

analytics Client-facing or consulting experience Strong SQL and Python skills Experience with AWS, GCP or Azure Understanding of data quality, governance, observability and dimensional modelling ...

team through technical guidance and knowledge transfer. Essential experience Strong hands-on Microsoft Fabric experience, including Lakehouses, Warehouses, pipelines and semantic models. Advanced SQL, dimensional modelling, Power BI and governed business metrics. Practical experience connecting LLMs or AI agents to structured enterprise data, beyond document-based RAG. Strong ...

solutions across adjacent domains including integration, applications, infrastructure and cyber security. Knowledge of modern data architecture patterns, including Medallion Architecture, and an appreciation of dimensional modelling techniques such as Kimball. Experience developing reusable design patterns and standards that improve delivery consistency and reduce operational overhead. Awareness of architecture ...

analytics Client-facing or consulting experience Strong SQL and Python skills Experience with AWS, GCP or Azure Understanding of data quality, governance, observability and dimensional modelling ...

transformation. Ensure data is accurate, reliable, secure and available for business use. Support potential data migration and legacy system transformation projects. Apply good data modelling and warehousing practices, including dimensional modelling. Work closely with Data Analysts, Data Scientists and business stakeholders. Translate business requirements into effective technical solutions. … data platforms. Experience with SSIS and/or SSRS . Experience working with data warehouses and/or data lakes . Understanding of data modelling and database design. Experience working with cloud-based data solutions across Azure, AWS or GCP . Strong analytical and problem-solving skills. Ability ...

implementing ETL/ELT solutions. Knowledge of Lakehouse and Data Warehouse architectures. Experience with Data Pipelines, Dataflows Gen2, and Notebooks. Understanding of data modelling techniques, including star schemas and dimensional modelling. Experience with Power BI semantic models and reporting. Knowledge of data governance, security, and performance optimisation. Experience ...

implementing ETL/ELT solutions. Knowledge of Lakehouse and Data Warehouse architectures. Experience with Data Pipelines, Dataflows Gen2, and Notebooks. Understanding of data modelling techniques, including star schemas and dimensional modelling. Experience with Power BI semantic models and reporting. Knowledge of data governance, security, and performance optimisation. Experience ...

governance patterns. 7+ years strong hands-on experience with Azure-based data platforms, including Azure Data Factory, Databricks, data lake architectures, SQL, and dimensional data modeling, with the ability to build practical end-to-end solution designs. Proven ability to own solution architecture end to end: shape target designs … Relevant Microsoft certifications in Azure, Power BI, data, or AI architecture. Core Technology Stack Data platform : Azure Data Factory, Databricks, Azure data lake, SQL, dimensional modeling, ETL/ELT, orchestration. AI platform : Azure OpenAI, Azure AI Foundry, Azure AI Search, Copilot Studio, Semantic Kernel, Prompt Flow. Analytics : Power ...

Lead Data Engineer l Azure l Databricks l Dimensional Modelling l PowerBI l £550-£570 per day Outside IR35 London (2 days per week) 6 months + extensions likely We're looking for a Lead Data Engineer to join a large-scale data transformation programme, helping shape ...

redesign, with reasons. Essential Strong SQL Server and Data Warehouse migration experience Power BI report and semantic model design, including DAX and performance Dimensional modelling and clear metric definitions Reconciliation, testing and controlled deployment Able to develop solutions directly and explain design decisions to teams ...

platform administration, you will ensure the EPM ecosystem directly powers strategic decision-making and group-wide reporting. Key Responsibilities EPM Strategy & Solution Architecture: Define dimensional models, metadata structures, business rules and governance frameworks aligned with the finance transformation roadmap. Implementation & Build: Partner with external implementation partners during project delivery ...

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. Experience with data validation, testing and quality assurance. Understanding of established BI development standards … architectural patterns. What Will Make You Stand Out: Experience with Data Vault and Kimball modelling methodologies. Programming or scripting skills. Strong problem-solving abilities and a proactive approach to troubleshooting. Experience supporting junior developers through knowledge sharing and peer reviews. If you are interested in the role please apply. ...