8 of 8 Contract Dimensional Modelling Jobs

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 ...

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. ...

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 ...

working in a Devops Agile Environment with differing skill levels. Experience of Implementing advanced DW techniques, including but not limited to SCD, index strategies, Dimensional Modelling, Performance Optimisation Able to communicate a technical solution to a wide audience of technical and non-technical colleagues and clients. Qualifications/ ...

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 ...