15 of 15 Contract Dimensional Modelling Jobs

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

strategies. Experience integrating data via APIs and services. Clear communication skills and experience working in Agile delivery teams. Nice to Have: Data warehousing and dimensional modelling (e.g. dbt). Basic Power BI knowledge. Relevant Microsoft or Azure certifications. Reasonable Adjustments: Respect and equality are core values to us. ...

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

practices. Continuously optimise data pipelines and support enhancements to the wider analytics infrastructure. What Were Looking For Strong hands-on experience with dbt Core (modelling, testing, documentation). Skilled in building models for on-prem Microsoft SQL Server (MSSQL) . Excellent SQL skills with a focus on performance optimisation. … Solid Python experience in data or analytics engineering contexts. Comfortable working in Git-based, collaborative engineering environments . Strong understanding of data warehousing, dimensional modelling, ELT/ETL . Clear communicator with strong documentation habits. Ability to work closely with non-technical stakeholders. Industry Preference Because ...

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

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

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

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

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