7 of 7 Dimensional Modelling Jobs in the South East

Engineer, you will be responsible for transforming raw data into well modelled, business ready data marts and semantic layers. You will take ownership of dimensional modelling, dbt transformations, and core metrics that power BI tools used across the business. This role blends hands on technical delivery with technical … managing 2 to 3 Analytics Engineers while working closely with senior data leaders and stakeholders on multi market initiatives. Key Responsibilities * Design and own dimensional data models using Kimball methodology* Build and maintain dbt pipelines from raw to gold layer marts* Define and enforce modelling, testing, and documentation ...

Databricks (PySpark, Spark SQL) Hands-on experience with Azure Synapse Analytics (dedicated and/or serverless pools) Solid understanding of data warehousing concepts and dimensional modeling Proficiency in SQL and Python Experience with Azure data services such as Azure Data Lake Storage (ADLS Gen2) , Azure Data Factory , and Azure ...

revenue domains, enabling trusted reporting in tools such as Looker, Power BI, and Tableau. This is a hands on role with real influence over modelling standards, semantic definitions, and how data is consumed across the business. Key responsibilities Data modelling and transformation Design and build Kimball style dimensional … pipelines that are performant, tested, and easy to use Partner with Data Engineers to shape upstream data structures and improve handoffs from ingestion to modelling Implement data quality testing using dbt tests and expectations frameworks Semantic layer and analytics enablement Help define and maintain a consistent semantic layer across ...

Role – Technology Lead Technology – Snowflake, SQL Server, PostgreSQL, Data Warehousing, Data Lake, Medallion, Data Vault, Data Fabric, Semantic modelling Location – London, UK Job Description We are seeking an experienced Data Modeler who can analyse and understand the existing customer data and analytics models on SQL Server, and design efficient … concepts—including Specialized Insurance, London Market, and Regulatory Data—is essential for success in this role. Your role In the role of a Data Modelling Lead, you will be responsible for leading the design and transformation of enterprise data models to support scalable, high-performance analytics and reporting solutions. ...

/Silver/Gold) patterns Build metadata-driven ingestion pipelines and transformation frameworks Develop advanced PySpark/Spark SQL notebooks for data cleansing and modelling Create production-ready semantic models and support BI teams Implement governance, security, and CI/CD best practices Engage with clients to translate business … scale transformations Integration with Dynamics 365, Dataverse, and/or Business Central CI/CD implementation using Azure DevOps or GitHub Solid understanding of dimensional modelling and Power BI optimisation Desirable Microsoft Fabric certifications Familiarity with Azure services and Power Platform Experience in consultancy environments and large enterprise ...

Strong SQL skills and experience working with cloud data warehouses (BigQuery, Redshift, Snowflake, etc.) Solid experience building models and transformations using dbt Understanding of dimensional modelling and data transformation principles Exposure to BI tools (Looker, Power BI, or similar) and how they consume data Experience working with cloud ...

various projects Proven experience in data engineering and architecture, with a focus on developing scalable cloud solutions in Azure, GCP or AWS. Data Modelling using Kimball, 3NF or Dimensional methodologies Analytics Engineering lean, with experience within BigQuery (GCP) with data modelling in DBT and mobile/telecoms … operationally efficient pipelines, utilising core Cloud components, such as Azure Data Factory, Big Query, AirFlow, Google Cloud Composer and Pyspark etc Proven experience in modelling data through a medallion-based architecture, with curated dimensional models in the gold layer built for analytical use Strong understanding ...