1 to 25 of 40 Dimensional Modelling Jobs

deliveries Your skills: To be considered you must be a Data Consultant or Data Engineer who has strong hands-on technical skills in data modelling/dimensional modelling & architecting BI solutions.You will bring a track record of leading projects and driving them across all aspects … delivering end-to-end projects successfully.Your hands-on technical skillset will need to be strong, and you must have experience of data engineering, data modelling, dimensional modelling and designing/architecting BI solutions. You will be adaptable and able to work with different tools and technologies, depending ...

would be a bonus! Key outputs for the role• Design, build, and maintain scalable and trustworthy data models in dbt, making use of Kimball Dimensional and One Big Table (OBT) methodologies.• Translate business requirements from stakeholders into robust, well-documented and tested dbt models.• Develop and own workflows within … performant dbt models that serve as a single source of truth for business reporting.• Implement and champion data quality testing, documentation standards, and modelling best practices within dbt projects.• Troubleshoot and resolve any issues or errors in the data pipelines.• Stay updated with the latest cloud technologies and industry ...

engineering standards, own key architectural decisions, and deliver scalable, reliable pipelines and models. You will: Lead the technical strategy for data engineering across ingestion, modelling, orchestration, and automation. Build and maintain high‐quality ETL pipelines using modern tooling and cloud‐native infrastructure. Develop robust data models and frameworks … similar). Experience with modern data warehouses such as Snowflake, Redshift, or BigQuery. Infrastructure‐as‐code experience (Terraform or Pulumi). Strong data modelling capability (dimensional modelling, Data Vault, etc.). Background in software engineering or backend development is highly desirable. Experience in high‐growth or smaller ...

skills including performance tuning Experience with Python or PySpark for data transformations Practical experience building ETL or ELT pipelines Solid understanding of data modelling approaches such as dimensional modelling and medallion architecture Experience working with data governance, RBAC, and GDPR within a UK environment Familiarity with ...

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

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

Server, SSIS, SSAS, SSRS) Hands-on experience building and maintaining data pipelines and integrations (ETL/ELT) Solid understanding of data warehousing concepts, dimensional modelling, and data normalisation Experience with data manipulation languages such as T-SQL and DAX Experience working in an Agile environment (ideally Kanban) Strong ...

Server, SSIS, SSAS, SSRS) Hands-on experience building and maintaining data pipelines and integrations (ETL/ELT) Solid understanding of data warehousing concepts, dimensional modelling, and data normalisation Experience with data manipulation languages such as T-SQL and DAX Experience working in an Agile environment (ideally Kanban) Strong ...

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

quality, and availability across core data assets. Data Platforms, Governance & Maturity Develop and maintain enterprise data models, including master data management (MDM) and core dimensional models. Establish and embed data governance frameworks covering data quality, security, access, and regulatory compliance. Support the introduction of data standards, cataloguing, and best ...

operational reporting. Key Responsibilities: Build, maintain and optimise scalable, secure and well-governed data pipelines. Develop and maintain data models (Data Vault and Dimensional). Ensure data quality, lineage, governance and security standards are embedded in all pipelines. Troubleshoot and resolve data pipeline issues, performing root cause analysis … distributed environments (DBT, Snowflake, SQL Server Stack; experience with Kafka, MySQL, Azure or AWS is a plus). Strong expertise in Data Vault and Dimensional modelling is essential. Experience embedding data governance, quality, monitoring and alerting into pipelines. Knowledge of Agile delivery and CI/CD principles. Excellent ...

such as Data Factory, Synapse and Azure SQL Experience using Databricks and Python in data processing workflows Strong SQL skills and practical knowledge of dimensional modelling and warehouse design Familiarity with CI/CD approaches for data and analytics solutions Confident communicator with the ability to work across ...

such as Data Factory, Synapse and Azure SQL Experience using Databricks and Python in data processing workflows Strong SQL skills and practical knowledge of dimensional modelling and warehouse design Familiarity with CI/CD approaches for data and analytics solutions Confident communicator with the ability to work across ...

dashboards (DAX, Power Query, RLS, performance). Advanced Excel: advanced formulas, Pivot tables, Power Pivot. ETL/ELT tooling (SSIS/Power Query) and dimensional modelling (Star Schema). Practical AI/ML exposure (e.g., Python notebooks, Azure ML, or equivalent) and the ability to operationalise models responsibly ...

business goals Design logical and physical data models optimised for reporting, analytics, and self-service BI Establish and govern architectural patterns (e.g. medallion architecture, dimensional modelling, data vault) Design cloud-based data platform architectures (AWS preferred), including data storage, processing, and consumption layers Technology Leadership Evaluate and recommend … cloud-native services Lead proofs-of-concept and technical assessments for new technologies Ensure the data architecture remains modern, performant, and future-proof Data Modelling & Governance Define standard business entities, metrics, and KPIs for consistent reporting Review and approve complex data models created by BI Engineers Design and embed ...

business goals Design logical and physical data models optimised for reporting, analytics, and self-service BI Establish and govern architectural patterns (e.g. medallion architecture, dimensional modelling, data vault) Design cloud-based data platform architectures (AWS preferred), including data storage, processing, and consumption layers Technology Leadership Evaluate and recommend … cloud-native services Lead proofs-of-concept and technical assessments for new technologies Ensure the data architecture remains modern, performant, and future-proof Data Modelling & Governance Define standard business entities, metrics, and KPIs for consistent reporting Review and approve complex data models created by BI Engineers Design and embed ...

trusted data foundations and then turning them into clear, decision-ready insight. You'll sit at the intersection of data engineering and business intelligence, modelling clean, reliable datasets in dbt and designing impactful dashboards in Power BI and Tableau. If you care about well-defined metrics, strong governance … just look good), this role offers real ownership and visibility. You'll lead the development of the analytics layer, building and maintaining robust dimensional models using dbt. You'll create production-ready fact and dimension tables, implement testing and documentation standards, and ensure business metrics are consistent and reliable. ...

closely with data engineers, analysts, and architects to deliver high-quality, scalable data pipelines and models. Strong expertise in Snowflake, ETL/ELT, data modelling, and data warehousing is essential. Responsibilities Snowflake Development: Build and optimise Snowflake objects (databases, schemas, tables, views, tasks, streams, resource monitors). ETL/… Pipelines: Develop and maintain robust data pipelines using tools like dbt, Airflow, Azure Data Factory, or similar. Data Modelling: Implement dimensional models (star/snowflake schemas), handle SCDs, and design efficient structures for analytics. Performance Tuning: Optimise queries, manage clustering, caching, and warehouse sizing for cost and speed. ...

closely with data engineers, analysts, and architects to deliver high-quality, scalable data pipelines and models. Strong expertise in Snowflake, ETL/ELT, data modelling, and data warehousing is essential. Responsibilities Snowflake Development: Build and optimise Snowflake objects (databases, schemas, tables, views, tasks, streams, resource monitors). ETL/… Pipelines: Develop and maintain robust data pipelines using tools like dbt, Airflow, Azure Data Factory, or similar. Data Modelling: Implement dimensional models (star/snowflake schemas), handle SCDs, and design efficient structures for analytics. Performance Tuning: Optimise queries, manage clustering, caching, and warehouse sizing for cost and speed. ...

. Technical Expertise: Strong expertise in Microsoft Data Platform technologies, including: SQL Server SSIS SSAS SSRS Solid understanding of data warehousing concepts, data normalisation, dimensional modelling, and associated best practices. Hands-on experience with data pipelines and integrations (ETL/ELT). Proficiency in data manipulation languages such ...

. Technical Expertise: Strong expertise in Microsoft Data Platform technologies, including: SQL Server SSIS SSAS SSRS Solid understanding of data warehousing concepts, data normalisation, dimensional modelling, and associated best practices. Hands-on experience with data pipelines and integrations (ETL/ELT). Proficiency in data manipulation languages such ...

technical concepts clearly to non-technical audiences Act as a positive, approachable technical lead and support other team members Maintain robust data dictionaries and dimensional data models Apply strong analytical thinking and stay up to date with existing and emerging technologies Demonstrate expertise in SQL, data warehousing, dimensional modelling, Databricks, Data Lakes, and knowledge of CDL Kingfisher, Classic data, OGI, and main PAS data sources Skills, Experience & Knowledge: Development experience in SQL programming and systems integration Strong knowledge of SQL, data modelling, data warehousing concepts, and Kimball methodology Experience within Insurance or Broking (preferred) Proven ...