1 to 25 of 63 Dimensional Modelling Jobs

holder will play a leading role in the design, development, and optimisation of high-quality Power BI data models. A strong understanding of data modelling, particularly dimensional modelling principles, is essential, as these models will underpin analytical reporting and the ongoing development of the Trust's data … matching. Main duties of the job Lead the design, development, and optimisation of high-quality Power BI data models, underpinned by robust dimensional modelling principles to support accurate and consistent reporting. Support the development, maintenance, and optimisation of the Trust's data warehouse and associated data platforms, ensuring ...

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

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

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

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

Google Cloud Platform (GCP) Experience with orchestration tools (e.g., Apache Airflow) Experience with version control (e.g., Git) Solid understanding of data warehousing concepts and dimensional modeling To apply for this role please submit your CV or contact Dillon Blackburn on or at . Tenth Revolution Group ...

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

you. What You'll Be Doing Architecting the Truth: Design and implement scalable business-layer models, marts, and OBTs. You'll decide whether a dimensional model or a flat OBT is the right tool for the specific business problem. Owning the Lifecycle: You take business requirements and turn them … hood' mechanics of cloud data warehouses (specifically GCP BigQuery). dbt Specialist: Strong hands-on experience with dbt Cloud or Core is essential. Modelling Pro: You understand dimensional modelling and how to structure data for varied business use cases. CI/CD Native: You're comfortable with ...

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

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

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

pipelines across operational and analytical layers, working heavily with SQL and Python-based orchestration. You’ll contribute to schema design, scalable data modelling, and metadata-driven frameworks that enable repeatable, production-ready outputs. The role also involves CI/CD automation, environment governance, and supporting the integration of machine … expertise (T-SQL, PostgreSQL or similar) Python for orchestration and data tooling Experience building ETL/ELT pipelines in cloud environments Strong understanding of dimensional modelling and data architecture principles Experience working with CI/CD pipelines and Git-based workflows Exposure to Azure, AWS or GCP Comfortable ...