51 to 73 of 73 Dimensional Modelling Jobs in London

complex security, IT, and business datasets to identify trends, anomalies, data quality issues, and emerging risks.Experience with data modeling (star/snowflake schema, dimensional modeling).Proficiency with relational database (SQL) and programming/scripting (Python or R).Typically 2 years of relevant experience in information security, IT, data analysis ...

scalable data solutions within Snowflake Building and maintaining data pipelines and transformation frameworks using dbt Working with complex market, investment and risk datasets Designing dimensional data models and Star Schema structures Supporting portfolio suitability and regulatory reporting initiatives Implementing data quality, validation and governance controls Working closely with investment … practices and AI-assisted development tools What We're Looking For Essential Experience Strong commercial experience with Snowflake Excellent understanding of Star Schema/dimensional modelling Experience with dbt Strong SQL and data engineering capability Experience working with time-series market data Exposure to market data platforms ...

prototyping and proof-of-concept builds within Databricks to demonstrate platform capabilities and accelerate client adoption Provide best practice guidance on Lakehouse architecture, data modelling, workload optimisation, and cost management Produce high-quality technical documentation including architecture diagrams, architecture decision records (ADRs), runbooks, and deployment guides Enable client teams … e.g. Terraform preferred) and CI/CD pipelines (e.g. Azure DevOps, GitHub Actions) Solid understanding of data architecture concepts including Lakehouse medallion architecture and dimensional modelling Familiarity with security and governance frameworks (e.g. RBAC, ABAC, data masking, audit, compliance standards) Excellent communication skills with the ability to explain ...

other routine healthcare data at patient level Unity Catalog, Delta Lake and medallion structure, bronze to silver to gold Exposure to dbt and dimensional modelling Experience contributing to vendor or partner relationships, such as with Databricks Experience designing for multi-region operations (UK, Middle East, EU) Flexible working ...

engineering standards, design patterns, and development best practices. Database & Data Engineering Strong experience with SQL Server, PostgreSQL, and enterprise database platforms. Expertise in: Data modelling (OLTP, OLAP, dimensional models) Query optimization and performance tuning Database scalability and resilience Data governance and quality management Experience delivering large-scale ...

solution designs meet business requirements whilst aligning with architecture standards, governance frameworks and strategic objectives. The successful candidate will combine strong data architecture and modelling expertise with a broad understanding of Microsoft Azure data technologies and modern data platforms, enabling them to guide delivery teams and make informed design … ability to influence both technical and non-technical stakeholders. Proven experience designing conceptual, logical and physical data models. Strong knowledge of relational and dimensional modelling techniques. Experience undertaking data profiling and source system analysis. Experience designing enterprise data architectures and integration patterns. Ability to produce and review architecture ...

Defining and owning the enterprise data architecture strategy and roadmap Designing scalable data models, pipelines, and storage solutions Establishing architectural frameworks (eg data vault, dimensional modelling, medallion architecture) Leading the design of cloud data platforms (AWS) - including services like Redshift, S3, Glue, Athena Evaluating and introducing new technologies … both technical and business stakeholders What We're Looking For Proven experience as a Data Architect/Enterprise Data Architect Strong expertise in data modelling and SQL Hands-on experience with AWS data stack (or similar cloud platforms) Deep understanding of modern data architectures (lakehouse, warehousing, ETL/ ...

fastest way to grow is by doing, so we give you the ownership to run with things and see real-time results.Owns the data modelling strategy, sets standards for data modelling, transformations, and governance.Leads the design and implementation of new features,, such as the creation …/or other languages relevant to data processingExtensive experience in dbt and ideally Airflow (or other orchestration tools)Extensive experience in Entity-Relationship modelling and Dimensional modellingExperience with Cloud Data Warehousing (eg Snowflake, Databricks or BigQuery) and Cloud (AWS, GCP or Azure)Familiarity with TableauExcellent communication and problem ...

rule definition, thresholding, automated alerting, and root-cause remediation). Craft complex SQL transformations, optimize query performance, handle advanced window functions, and design conformed dimensional models for curated platform layers. Map end-to-end data flows from ingestion to serving, defining upstream/downstream contracts and data ownership boundaries. ...

rule definition, thresholding, automated alerting, and root-cause remediation). Craft complex SQL transformations, optimize query performance, handle advanced window functions, and design conformed dimensional models for curated platform layers. Map end-to-end data flows from ingestion to serving, defining upstream/downstream contracts and data ownership boundaries. ...

provide guidance where required, in the software development lifecycle (SDLC) submitting work for technical test, cosmetic test and applying re-work when required.Dimensional Modelling (Kimball Methodology), database principles and ETL (Extract, Transform and Load).Coordinate and maintain the reporting requirements backlog, working with stakeholders to deliver value ...

historical queries and usage of gateways.• Containerised data workloads using Docker and Kubernetes, with reproducible, environment-agnostic deployment of data infrastructure.• Analytical data modelling expertise, including dimensional models or data vaults, schema evolution, slowly changing dimensions, and downstream impact analysis.• Strong experience managing and troubleshooting environments based ...

over 1,800 global colleagues.Purpose of the jobThe Lead Data Analytics Engineer is a senior technical leadership role responsible for advancing Enterprise Data Modelling, Analytics Automation and Engineering Empowerment across Global Analytics.Working directly with the Head of Analytics Engineering, the role translates the Analytics Engineering strategy into technical direction … engineering practices. The role enables squads to independently deliver trusted, scalable Data Products while maintaining enterprise consistency and engineering excellence.Key Responsibilities:1. Enterprise Data Modelling• Lead the enterprise approach to analytical data modelling, including domain models, dimensional models and semantic layers.• Establish reusable modelling patterns ...

Deep knowledge of the Azure data stack (Azure SQL Server, CosmosDB, Azure Data Factory, Purview, Synapse, Event Hub, Azure Databricks/Fabric) Extensive data modelling experience: both normalised relational models and de-normalised Star Schema/dimensional models Excellent relational database design skills with expertise in diagnosing ...

direction.Deep knowledge of the Azure data stack (Azure SQL Server, CosmosDB, Azure Data Factory, Purview, Synapse, Event Hub, Azure Databricks/Fabric) Extensive data modelling experience: both normalised relational models and de-normalised Star Schema/dimensional models Excellent relational database design skills with expertise in diagnosing ...

strong experience across the Oracle analytics and reporting ecosystem. This role focuses on translating business needs into practical intelligence solutions through business analysis, SQL, dimensional data understanding, report development, dashboard support, Oracle BI Repository (RPD) modeling, and effective use of Oracle BI tools. As a core member of Stantec … Layer objects, dashboards, analyses, and reporting solutions.• Ensure data quality through thorough testing and validation of new or updated analytical subject areas[.• Utilize dimensional and relational data models to develop effective reporting and analytics solutions.• Create summarization, aggregation, and reporting logic for high‐ volume datasets.Collaboration and Stakeholder Management ...

love to hear from you.What you'll doWork with customers daily to transform their existing solutions, spreadsheets, and business problems into sophisticated multi-dimensional models byUnderstanding business requirements & document themDesigning & building the corresponding Pigment applicationsTraining/Co-building with the customer o they are self-sufficient in the solutionParticipating ...

required to possess strong computer CAD/BIM and technical skills to support and oversee the management of 4D/3D/2D dimensional models, technical and quality checking and control, coordination and constructability analysis.Missions/Main DutiesWorking in collaboration with our designers and contract partners, the Principal Digital ...

projects digital and information management requirements. The Senior Digital Engineer is required to oversee technical and quality checking, the management of 3D/2D dimensional models, as well as control, coordination and constructability analysis.Missions/Main DutiesSupport the Design Integration Team, BIM Production Manager, GIS Specialists and Production Team ...

hear from you. What you'll do Work with customers daily to transform their existing solutions, spreadsheets, and business problems into sophisticated multi-dimensional models by Understanding business requirements & document them Designing & building the corresponding Pigment applications Training/Co-building with the customer o they are self-sufficient ...

sheets. The CAD manager/CDE administrator is required to possess strong computer CAD/BIM and technical skills to produce 3D/2D dimensional models required for model and drawing production, quality checking and control, coordination, and constructability analysis.What You'll Be Doing:Support the BIM Manager ...

Deep knowledge of the Azure data stack (Azure SQL Server, CosmosDB, Azure Data Factory, Purview, Synapse, Event Hub, Azure Databricks/Fabric) Extensive data modelling experience: both normalised relational models and de-normalised Star Schema/dimensional models Excellent relational database design skills with expertise in diagnosing ...

foundation of our global reporting capabilities. Your primary focus over the coming year will be the design and implementation of a high-performance, scalable dimensional model built to serve multiple global clients.This role is not just about moving data; it is about the sophisticated translation of complex schema designs … abstract data architecture and the high-performance scripts that power our business intelligence.Key ResponsibilitiesDimensional Model Architecture: Lead the transition to a robust, multi-tenant dimensional model. You will be responsible for ensuring the architecture is scalable enough to onboard several major global clients without compromising performance.Expert SQL Development: Translate ...