12 of 12 Contract Dimensional Modelling Jobs in the UK

ingestion frameworks for integrating multiple source systems into the cloud data platform. Design and govern data transformation frameworks using DBT. Define and enforce data modelling standards including dimensional modelling, star schema, and enterprise data models. Lead architecture reviews and solution design discussions for new data initiatives. Optimize … Platform Strong experience with Amazon Web Services, including: S3 IAM AWS Glue Lambda CloudWatch Data Transformation Strong experience with DBT for enterprise-scale data modelling, testing, and transformation pipelines. Programming/Query Strong expertise in SQL for data transformation and performance optimization Python (preferred) for automation and data engineering ...

datasets and dashboards that underpin key regulatory and business decision-making. It's ideal for a hands-on Power BI specialist with strong data modelling expertise , capable of working in a highly regulated environment where data accuracy, lineage, and performance are critical . THE ROLE Design and develop scalable … KPIs, time intelligence, and business logic Perform data transformation using Power Query (M) and SQL-based pipelines Design robust data models (star schema, dimensional modelling) to support performance and scalability Ensure data quality, lineage, and governance standards across all BI assets Monitor and improve dataset performance, refresh reliability ...

wealth management firm undergoing a major digital and data transformation . You will take ownership of the data platform architecture, ingestion pipelines, dimensional models, and API layer , delivering a scalable Bronze/Silver/Gold medallion architecture and establishing best practices for data engineering and DevOps. Must Have Azure … Database Azure Data Factory (ADF) Azure Synapse Analytics Azure Functions Data Warehouse Delivery Delivered end-to-end DWH as a lead engineer (source integration dimensional models API layer) Designed and implemented Bronze/Silver/Gold medallion architecture Made architectural decisions and produced Architecture Decision Records (ADRs) Data Engineering ...

. Experience with Power BI semantic models or Azure Analysis Services/SQL Server Analysis Services (SSAS). Strong data modeling skills (star schema, dimensional modeling). Azure & Data Engineering Experience with: Azure Synapse Analytics Azure Data Factory or similar ETL tools Azure Storage/Data Lake Experience designing ...

ingestion frameworks for integrating multiple source systems into the cloud data platform. Design and govern data transformation frameworks using DBT. Define and enforce data modelling standards including dimensional modelling, star schema, and enterprise data models. Lead architecture reviews and solution design discussions for new data initiatives. Optimize … Platform Strong experience with Amazon Web Services, including: S3 IAM AWS Glue Lambda CloudWatch Data Transformation Strong experience with DBT for enterprise-scale data modelling, testing, and transformation pipelines. ...

logical data models across key investment banking domains (e.g. clients, products, trades, positions, risk, finance, market and collateral data) Ensure models align to agreed modelling standards, naming conventions, and reusable design patterns Translate business requirements into clear, structured data models aligned to authoritative upstream sources Facilitate workshops with SMEs … data teams to validate definitions and resolve data discrepancies Embed modelling standards, metadata, and quality controls in line with enterprise data governance frameworks Operate within a high-throughput, iterative delivery (factory) model, supporting multiple concurrent data products Collaborate closely with architects, governance, engineering, onsite leadership, and offshore teams ...

logical data models across key investment banking domains (e.g. clients, products, trades, positions, risk, finance, market and collateral data) Ensure models align to agreed modelling standards, naming conventions, and reusable design patterns Translate business requirements into clear, structured data models aligned to authoritative upstream sources Facilitate workshops with SMEs … data teams to validate definitions and resolve data discrepancies Embed modelling standards, metadata, and quality controls in line with enterprise data governance frameworks Operate within a high-throughput, iterative delivery (factory) model, supporting multiple concurrent data products Collaborate closely with architects, governance, engineering, onsite leadership, and offshore teams ...

meet audit and regulatory standards.Key ResponsibilitiesBuild and maintain a secure PostgreSQL-based data platformLead the shift away from Databricks and spreadsheet-dependent reportingCreate dimensional data models covering investments, pricing, performance and related domainsDevelop reliable ETL/ELT processes in PythonImplement data quality, reconciliation and validation controlsOptimise database performance … PostgreSQL knowledge, including indexing, optimisation and partitioningBackground in financial or investment data environmentsAdvanced SQL and Python skillsExperience migrating data from platforms like DatabricksConfident with dimensional modelling, star schemas, SCDs etc.Experience within regulated financial servicesDesirableExperience in pensions, asset management or institutional investingUnderstanding of performance measurement and attributionExposure to Airflow ...

looking for an experienced Data Design Analyst/Data Modeler with 6 8 years of experience to take end-to-end ownership of data modelling for data migrated from Oracle to Azure Microsoft Fabric. Key Responsibilities Design and implement conceptual, logical, and physical data models in Azure MS Fabric. … Lead data modelling activities for Oracle-to-Azure migration initiatives. Define and optimize Medallion Architecture layers (Bronze, Silver, Gold). Translate business and analytical requirements into robust data structures. Ensure data integrity, performance, scalability, and compliance with governance standards. Collaborate with data engineers, architects, and business stakeholders. Data Analysis ...

distributed environments and values technical excellence through CI/CD and Agile. The Essentials Modern Modeling: Expert skills in Data Vault Mandatory and Dimensional modeling. Cloud & DevOps: Strong AWS experience with a focus on CI/CD and writing secure code. Data Governance: Proven ability to embed quality, lineage ...

requirements into technical BI solutions, including KPIs, metrics, and visual narratives. Ensure reports are intuitive, performant, accessible, and aligned to UX best practices. Data Modelling and Analytics: Develop robust data models using star and snowflake schemas. Write and optimise complex SQL queries, views, and stored procedures. Implement and maintain … best practices. Provide insight and recommendations based on data trends and analysis. About You Strong experience with Power BI (Power Query, DAX, data modelling, visuals). Advanced SQL skills for data transformation and performance optimisation. Hands-on experience with Microsoft SQL Server and/or Azure data services. Experience ...

integration, advanced analytics, and AI driven decision making across complex digital transformation programmes. With access to modern data platforms, high quality datasets, and leading modelling frameworks, you will guide engineering, analytics, and architecture teams in building secure, scalable, and well governed data structures. This role empowers you to shape … operational needs Translate business requirements into robust data entities, attributes, relationships, and constraints; ensure traceability from requirements to models Establish and enforce GDM modelling standards and naming conventions (e.g., normalization, dimensional/star/snowflake patterns, data vault where appropriate) Design dimensional models (facts, dimensions, hierarchies, slowly ...