1 to 25 of 63 Dimensional Modelling Jobs

include: Designing and developing Power BI reports, data models and DAX measures Modernising existing Excel-based reporting into scalable BI solutions Implementing best practice dimensional modelling (star schema) Creating and managing trusted datasets and reusable metrics Supporting the organisation’s transition toward Microsoft Fabric Working with stakeholders … solutions Enabling self-service analytics through well-structured Power BI datasets Supporting exploratory analytics and proof-of-concept projects Mentoring colleagues on Power BI, modelling and analytics design Your Experience Strong experience with Power BI including modelling, DAX and performance optimisation Advanced Excel skills, including Power Query ...

GraphQL APIs using Azure Data Factory and metadata-driven patterns. Apply data quality and validation rules using Lakeflow Declarative Pipelines expectations. Curated Layers & Data Modelling Develop clean and conforming Silver & Gold layers aligned to enterprise subject areas. Contribute to dimensional modelling (star schemas), harmonisation logic, SCDs … . Strong PySpark and Spark SQL skills within distributed compute environments. Experience working in a Lakehouse/Medallion architecture with Delta Lake. Understanding of dimensional modelling (Kimball), including SCD Type 1/2. Exposure to operational concepts such as monitoring, retries, idempotency and backfills. Mindset Good energy ...

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

regulatory reporting functions. The role requires strong knowledge of complex insurance data structures, market standards, and modern data architecture principles. Key Responsibilities Data Modelling & Architecture Design and maintain conceptual, logical, and physical data models for insurance and financial systems. Ensure alignment with industry standards and data governance frameworks. Develop … maintain data dictionaries, metadata, and modelling documentation. Data Integration & Transformation Collaborate with business analysts, actuaries, and technology teams to integrate data from multiple sources (policy, claims, exposure, financial). Optimise data flows to support reporting, analytics, and regulatory requirements. Stakeholder Engagement Work closely with internal teams to gather ...

quality technical documentation About You You will have extensive experience designing and delivering modern data platforms, with: Strong expertise in data warehouses, data lakes, dimensional modelling, and both batch and streaming data processing A solid understanding of data strategy and management, including data governance, data quality, security ...

quality technical documentation About You You will have extensive experience designing and delivering modern data platforms, with: Strong expertise in data warehouses, data lakes, dimensional modelling, and both batch and streaming data processing A solid understanding of data strategy and management, including data governance, data quality, security ...

regulatory reporting processes. This role requires a strong understanding of insurance data structures, market-specific standards, and advanced data architecture principles. Key Responsibilities Data Modelling & Architecture Design and maintain conceptual, logical, and physical data models for insurance systems. Ensure alignment with Lloyd's market standards, including Core Data Record … rules. Ensure compliance with Lloyd's market regulations, GDPR, and Solvency II requirements. Required Skills & Experience Technical Expertise 10+ years of experience in data modelling within the Lloyd's of London or London Market insurance sector. Proficiency in ER modelling, relational and dimensional modelling, and data ...

Role – Data Modelling Lead Technology – Snowflake, SQL Server, PostgreSQL, Data Warehousing, Data Lake, Medallion, Data Vault, Data Fabric, Semantic modelling Location – London, UK Job Description We are seeking an experienced Data Modeler who can analyze and understand the existing customer data and analytics models on SQL Server … concepts—including Specialized Insurance, London Market, and Regulatory Data—is essential for success in this role. Your role In the role of a Data Modelling Lead, you will be responsible for leading the design and transformation of enterprise data models to support scalable, high-performance analytics and reporting solutions. ...

images, text) and transformation into structured/vectorized formats · Strong SQL skills for analytical queries, performance tuning, and data modeling (star/snowflake schemas, dimensional modeling, partitioning, clustering). · Unstructured data & AI/RAG: Understanding of vector databases (e.G., Elasticsearch, Milvus, pgvector), embedding models, and RAG architectures. Familiarity with ...

images, text) and transformation into structured/vectorized formats · Strong SQL skills for analytical queries, performance tuning, and data modeling (star/snowflake schemas, dimensional modeling, partitioning, clustering). · Unstructured data & AI/RAG: Understanding of vector databases (e.g., Elasticsearch, Milvus, pgvector), embedding models, and RAG architectures. Familiarity with ...

images, text) and transformation into structured/vectorized formats · Strong SQL skills for analytical queries, performance tuning, and data modeling (star/snowflake schemas, dimensional modeling, partitioning, clustering). · Unstructured data & AI/RAG: Understanding of vector databases (e.g., Elasticsearch, Milvus, pgvector), embedding models, and RAG architectures. Familiarity with ...

images, text) and transformation into structured/vectorized formats · Strong SQL skills for analytical queries, performance tuning, and data modeling (star/snowflake schemas, dimensional modeling, partitioning, clustering). · Unstructured data & AI/RAG: Understanding of vector databases (e.g., Elasticsearch, Milvus, pgvector), embedding models, and RAG architectures. Familiarity with ...

images, text) and transformation into structured/vectorized formats · Strong SQL skills for analytical queries, performance tuning, and data modeling (star/snowflake schemas, dimensional modeling, partitioning, clustering). · Unstructured data & AI/RAG: Understanding of vector databases (e.g., Elasticsearch, Milvus, pgvector), embedding models, and RAG architectures. Familiarity with ...

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

Python skills Experience delivering analytics solutions within modern cloud data platforms Experience leading teams across analytics and BI delivery Strong understanding of data modelling, including dimensional modelling Experience delivering enterprise BI and analytics solutions, including dashboards, semantic models and insight storytelling What's on Offer Salary ...

/Kinesis Experience building data solutions on at least one major cloud platform (AWS, Azure, or GCP). Strong understanding of data warehousing concepts , dimensional modelling, and schema design. Experience working with CI/CD pipelines and Git-based workflows. Familiarity with Infrastructure-as-Code (Terraform, CloudFormation … testing, and observability practices. Desirable Skills Experience supporting Machine Learning pipelines or feature engineering. Knowledge of containerisation (Docker, Kubernetes). Experience with dbt for modelling and transformation. Background in financial services, payments, trading, or other data-rich environments. Experience with real-time analytics and low‐latency data architectures. Personal ...

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

procedures, performance tuning Strong troubleshooting skills for complex multi-system data issues. Strong understanding of data architecture concepts: Data lakes/lakehouse/warehouse, dimensional modeling, ELT/ETL patterns Batch orchestration, dependency management, SCD handling, incremental loads Azure Ecosystem (Preferred/Good to Have) Azure data services experience ...

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

queries, joins, aggregations, and optimization. Python proficiency for data manipulation and automation. Power BI or Tableau experience including dashboard development. Data modeling experience including dimensional modeling and star schema. ETL and data transformation experience. Stakeholder management skills. Problem-solving mindset with ability to work independently. Strong attention to detail ...

into meaningful insights and recommendations What you'll bring Experience of building a data warehouse using an ETL/ELT tool Star schema/dimensional modelling. Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements Experience of developing using ...