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

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

creating at least 5 new assets during the contract Who We're Looking For Strong experience in SQL, DBT, and Snowflake Familiarity with dimensional modelling (Kimball methodology preferred) Understanding of building models for large stakeholder groups Experience with performance optimisation, data quality, and query/resource efficiency Comfortable … with a supportive and experienced Analytics Engineering team Interview Process Case study (essential - candidates complete a provided template) Technical/market conversation focusing on: Dimensional modelling experience Snowflake model design for multiple stakeholders Performance optimisation and data quality Refactoring and migrations Availability: Interviews scheduled across Thursday 26th ...

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

Power BI Developer We are looking for a Power BI specialist with strong data modelling and analytical capability to help establish the foundations for sustainable reporting across the business. This is not purely a dashboard development role. While Power BI reporting will form part of the work, the primary … knowledge into a structured, well-documented data model that Power BI and other reporting tools can build upon. Key Responsibilities Data Understanding & Documentation Data Modelling & Reporting Foundations Power BI Development Data Transformation & Integration Data Platform Development Required Skills & Experience Strong experience with Power BI Strong DAX knowledge Strong ...

ideal candidate will have the following: Strong SQL; Snowflake ELT; dbt experience. Python/PySpark, ETL/ELT design. Data Vault 2.0 or dimensional modeling. AWS services (S3, Glue, Lambda, Redshift) or GCP equivalents. Experience with CI/CD for data pipelines. Good to have skills Although not essential ...

using Snowflake Optimise workflows and integrations using Openflow Develop and maintain ETL and ELT pipelines from Salesforce, relational databases, files, and NoSQL sources Implement dimensional modelling to support data warehousing and BI reporting Build and optimise data pipelines across Azure and AWS Ensure data quality, governance, and security ...

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

Desktop, Power Query (M), DAX, and Power BI Service. Solid SQL skills (joins, CTEs, window functions) and experience with SQL Server. Strong understanding of dimensional modelling and data warehouse principles. Experience building and maintaining ETL pipelines. Excellent analytical, problem solving, and troubleshooting skills. Strong communication skills, able ...

Essentials Pipeline Tech: 5+ years of experience with Kafka, Spark, Hadoop, and DBT . 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 ...

Essentials Pipeline Tech: 5+ years of experience with Kafka, Spark, Hadoop, and DBT . 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 ...

Agile. The Essentials Pipeline Tech: 5+ years of experience with Kafka, Spark, Hadoop, and DBT . Modern Modeling: Expert skills in Data Vault 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 ...

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

demonstrate the following key skills: Advanced SQL Server development (stored procedures, query optimisation, indexing strategies, tuning techniques) Strong understanding of data warehouse principles and dimensional modelling Experience working with MDM data structures and concepts Knowledge of ETL tools (Alteryx preferred) for data preparation, integration and automation Experience with ...

sector experience (banking, capital markets, insurance, asset management, or payments) Demonstrable experience modeling data for regulatory, risk, finance, or operational reporting Deep expertise in dimensional modeling, data vault, or hybrid approaches Strong hands-on experience with Snowflake Experience designing semantic layers for BI and analytics platforms Track record ...