26 to 50 of 104 Dimensional Modelling Jobs in the UK

fluently, debug it fast and critically review it - including AI-generated code, with a sharp eye for where it goes subtly wrongProven data modelling ownership - Dimensional modelling, defining grain and shaping the structure of a data domain from the ground up for warehousing and BIDeep, hands ...

assets).Be accountable for the data architecture within the enterprise data platform, ensuring it remains coherent, scalable and aligned to enterprise standards (e.g., data modelling, metadata/lineage, security and governance).Define, embed and govern lakehouse patterns such as medallion architecture (bronze/silver/gold), including ingestion, refinement … capabilities (data quality, master/reference data, analytics and AI enablement), including transitional architectures.Define, embed and govern enterprise standards, patterns and reference architectures (data modelling, data integration, data products, semantic layers and AI data/knowledge patterns) to ensure consistency, interoperability and reuse.Engage key stakeholders (Information Security, Office ...

communication and stakeholder engagement. Key Responsibilities Design, develop and maintain scalable data pipelines using Snowflake and DBT. Build high-quality data models, including dimensional and star schema models. Engineer solutions supporting complex investment and portfolio data. Work with market data platforms and external data feeds. Develop solutions for time … performance optimisation. Skills & Experience Essential Strong commercial experience as a Data Engineer. Expert knowledge of Snowflake . Strong experience with DBT . Data modelling experience, including dimensional modelling and star schemas. Experience working with time-series data. Experience integrating and managing market data feeds or financial datasets. ...

performance tuning. Data transformation, enrichment, aggregations, and joins. SQL Advanced SQL skills. Stored procedures, CTEs, window functions, and query optimization. Data warehousing and dimensional modelling concepts. AWS Skills Expected Candidate should have experience with one or more of the following AWS services: Amazon S3 AWS Glue Amazon … Lambda AWS Step Functions Amazon Redshift Amazon Athena Amazon RDS/Aurora AWS IAM AWS KMS Amazon CloudWatch AWS Secrets Manager Data Modelling Skills Star Schema Snowflake Schema Dimensional Modeling Data Vault Data Warehouse Design Data Lake Architecture Data Formats Experience working with: Parquet Avro JSON ...

retesting, and reporting. Perform back-end data testing, analysing large datasets to identify data quality issues, inconsistencies, and root causes. Validate data models and dimensional models, ensuring data structures, relationships, and business rules are correctly implemented. Use SQL to interrogate databases, read schemas and tables, reconcile data, and verify … skills with the ability to write queries, interrogate databases, read schemas and tables, and perform data reconciliation and validation. Solid understanding of data modelling and dimensional modelling, including testing data relationships, facts, dimensions, and business rules. ISTQB Data Testing certification (or equivalent) and recent, demonstrable experience working ...

retesting, and reporting. Perform back-end data testing, analysing large datasets to identify data quality issues, inconsistencies, and root causes. Validate data models and dimensional models, ensuring data structures, relationships, and business rules are correctly implemented. Use SQL to interrogate databases, read schemas and tables, reconcile data, and verify … skills with the ability to write queries, interrogate databases, read schemas and tables, and perform data reconciliation and validation. Solid understanding of data modelling and dimensional modelling, including testing data relationships, facts, dimensions, and business rules. ISTQB Data Testing certification (or equivalent) and recent, demonstrable experience working ...

modern ELT approaches and tools such as Snowflake, ADF and dbt CloudTranslating business requirements into clear technical specifications, delivery plans and engineering tasksLeading data modelling activity, including Kimball-style fact and dimension designSupporting migration from legacy tooling towards Snowflake-centred data solutionsWorking within Scrum teams to refine, plan … documentation, quality, governance and release processesWho we’re looking for:Strong experience in data engineering, including building and operating data pipelinesGood understanding of data modelling and dimensional modelling, using Kimball principlesExperience with modern data tooling such as Snowflake, ADF, dbt Cloud or equivalent technologiesConfidence translating business needs ...

.* Proven expertise in data integration and analytics platforms, including Azure Data Factory, Microsoft Fabric (Lakehouse/Warehouse), and strong understanding of data warehousing, dimensional modelling, and lakehouse concepts.* Experience with Microsoft Azure cloud platform, including Azure Data Lake Storage/ADLS Gen2, Microsoft Fabric (OneLake, Workspaces, Capacity ...

looking for: Solid experience in data architecture, with a track record of designing and delivering enterprise-scale data solutions Proficiency in data modelling techniques (e.g. dimensional modelling, data vault, medallion architecture) and strong SQL skills Experience with cloud data platforms, particularly AWS, as well as platforms such ...

technologies.We are looking for:Solid experience in data architecture, with a track record of designing and delivering enterprise-scale data solutionsProficiency in data modelling techniques (e.g. dimensional modelling, data vault, medallion architecture) and strong SQL skillsExperience with cloud data platforms, particularly AWS, as well as platforms such ...

equally as important as communication and stakeholder engagement.Key ResponsibilitiesDesign, develop and maintain scalable data pipelines using Snowflake and DBT.Build high-quality data models, including dimensional and star schema models.Engineer solutions supporting complex investment and portfolio data.Work with market data platforms and external data feeds.Develop solutions for time-series datasets … development tools.Champion best practice around data quality, governance and performance optimisation.Skills & ExperienceEssentialStrong commercial experience as a Data Engineer.Expert knowledge of Snowflake.Strong experience with DBT.Data modelling experience, including dimensional modelling and star schemas.Experience working with time-series data.Experience integrating and managing market data feeds or financial datasets.Strong ...

important as communication and stakeholder engagement. Key ResponsibilitiesDesign, develop and maintain scalable data pipelines using Snowflake and DBT.Build high-quality data models, including dimensional and star schema models. Engineer solutions supporting complex investment and portfolio data. Work with market data platforms and external data feeds. Develop solutions for time … practice around data quality, governance and performance optimisation. Skills & ExperienceEssentialStrong commercial experience as a Data Engineer. Expert knowledge of Snowflake. Strong experience with DBT.Data modelling experience, including dimensional modelling and star schemas. Experience working with time-series data. Experience integrating and managing market data feeds or financial ...

impact the education sector.This role sits within the Data & Insights department.Key ResponsibilitiesAct as a subject matter expert for Looker, advocating best practices in semantic modelling, governance, and self-service analyticsDesign, develop, and maintain LookML models, including views, explores, and dashboardsBuild scalable and reusable semantic layers to ensure consistency … into robust Looker solutionsDevelop and maintain data pipelines and transformations (in collaboration with analytics engineering teams) to support Looker modelsOptimise Looker performance through efficient modelling, caching strategies, and query designEnable and promote self-service analytics by creating intuitive dashboards and curated exploresEnforce data governance standards, ensuring accuracy, consistency ...

impact the education sector.This role sits within the Data & Insights department.Key ResponsibilitiesAct as a subject matter expert for Looker, advocating best practices in semantic modelling, governance, and self-service analyticsDesign, develop, and maintain LookML models, including views, explores, and dashboardsBuild scalable and reusable semantic layers to ensure consistency … into robust Looker solutionsDevelop and maintain data pipelines and transformations (in collaboration with analytics engineering teams) to support Looker modelsOptimise Looker performance through efficient modelling, caching strategies, and query designEnable and promote self-service analytics by creating intuitive dashboards and curated exploresEnforce data governance standards, ensuring accuracy, consistency ...

Collaborate with engineers, analysts and stakeholders to deliver practical solutions. Essential Skills Strong SQL and Snowflake experience. Data engineering and ETL/ELT development. Dimensional modelling (Kimball methodology). dbt development and engineering best practices. Azure Data Factory, Azure Functions and CI/CD. Python development for automation ...

Collaborate with engineers, analysts and stakeholders to deliver practical solutions. Essential Skills Strong SQL and Snowflake experience. Data engineering and ETL/ELT development. Dimensional modelling (Kimball methodology). dbt development and engineering best practices. Azure Data Factory, Azure Functions and CI/CD. Python development for automation ...

Collaborate with engineers, analysts and stakeholders to deliver practical solutions. Essential Skills Strong SQL and Snowflake experience. Data engineering and ETL/ELT development. Dimensional modelling (Kimball methodology). dbt development and engineering best practices. Azure Data Factory, Azure Functions and CI/CD. Python development for automation ...

Collaborate with engineers, analysts and stakeholders to deliver practical solutions. Essential Skills Strong SQL and Snowflake experience. Data engineering and ETL/ELT development. Dimensional modelling (Kimball methodology). dbt development and engineering best practices. Azure Data Factory, Azure Functions and CI/CD. Python development for automation ...

Collaborate with engineers, analysts and stakeholders to deliver practical solutions. Essential Skills Strong SQL and Snowflake experience. Data engineering and ETL/ELT development. Dimensional modelling (Kimball methodology). dbt development and engineering best practices. Azure Data Factory, Azure Functions and CI/CD. Python development for automation ...

Strong experience working with GCP (or a comparable cloud platform), Infrastructure as Code, and CI/CD practices. Deep understanding of data storage and modelling principles, including dimensional modelling, lakehouse patterns, and the governance and operational setup of tools like dbt, and applies data security and GDPR ...

implementing solutions on AWS data and analytics platforms.* Proven expertise in data integration and analytics platforms on AWS, with strong understanding of data warehousing, dimensional modelling, and lakehouse/data lake concepts.* Experience with AWS cloud platform, including Amazon S3, AWS Lake Formation, AWS Glue, Amazon Redshift, Amazon ...

Mastery: Deep experience with data orchestration tooling such as dbt or dataform.Platform Specifics: Hands-on experience with Databricks.Modeling Expertise: Practical knowledge of Kimball’s dimensional modeling. Here at Kaluza we have five core values that guide our business: Play to win, Solve the real problem, Build trust every ...

Airflow. Advanced Python and SQL skills with a strong software engineering mindset. Proven experience building complex, scalable batch and event-driven pipelines. Strong data modelling experience, including dimensional modelling, Data Vault or equivalent. Experience with Dataform or similar SQL-based transformation tooling. Understanding of CI/ ...

What you'll be doing Design, develop and maintain high-quality Power BI dashboards and reports. Translate business requirements into scalable reporting and data modelling solutions. Develop robust semantic models using star schema principles. Build complex DAX measures, KPIs and Power Query transformations. Optimise report performance, datasets and refresh … Extensive commercial experience with Microsoft Power BI (Desktop & Service). Advanced DAX, Power Query (M) and SQL (T-SQL preferred). Strong understanding of dimensional modelling and star schema design. Experience developing high-performance enterprise reporting solutions. Strong understanding of ETL processes and data warehousing concepts. Experience integrating ...

proactive mindset, eager to provide guidance to less experienced developers and support collaborative pair-programming. Desirable Skills Experience with PySpark or PySQL. Experience in Dimensional Modelling and data warehousing principles. Experience with SQL Server SSAS Tabular and DAX. Exposure to SQL Server RDBMS and Managed Instance. Knowledge ...