1 to 25 of 28 Remote/Hybrid Dimensional Modelling Jobs in London

processes. This creates an excellent opportunity for a Senior Data Architect to make a lasting impact. The Role You will lead the data modelling and architecture strategy across a modern Azure Data Lakehouse environment, ensuring scalable and governed data solutions that support both current reporting and future analytical … cases. Key responsibilities include: Designing and governing enterprise-wide data models across Medallion Architecture layers. Creating curated semantic and analytical data models using dimensional modelling and Kimball methodologies. Defining data modelling standards, governance frameworks, and data feed specifications. Collaborating with Data Engineers, Analytics Engineers, and business stakeholders ...

confident business decisions through trusted data. Whilst this is a leadership role, we expect the successful candidate to remain technically involved in architecture, data modelling and implementation. Key Responsibilities Enterprise Data Strategy Develop and own the company's enterprise data strategy, ensuring data is treated as a strategic business … warehouse supports accurate reconciliation between systems. Enterprise Data Warehouse Own the design and continual evolution of the company's enterprise data warehouse. Responsibilities include: Dimensional modelling Star schema design Fact and dimension modelling Slowly changing dimensions Master data management Metadata management Semantic layer design Data lineage Business ...

requirement for a Data Solution Architect to design, lead and deliver scalable, enterprise-grade data platforms. This role requires deep expertise in data architecture, dimensional data modelling (Kimball) and modern cloud-based data ecosystems (ideally Databricks) . Core Technical Expertise Strong experience in data solution architecture within enterprise … environments Proven hands-on expertise in data warehousing concepts and implementation Deep knowledge of Kimball dimensional modelling methodology. Platforms & Tools Experience with Databricks (preferred) or similar platforms: Snowflake, BigQuery, Redshift, Synapse, or equivalent Strong proficiency with: SQL (advanced level) Spark/PySpark Data pipeline orchestration tools (e.g., Airflow ...

requirement for a Data Solution Architect to design, lead and deliver scalable, enterprise-grade data platforms. This role requires deep expertise in data architecture, dimensional data modelling (Kimball) and modern cloud-based data ecosystems (ideally Databricks) . Core Technical Expertise Strong experience in data solution architecture within enterprise … environments Proven hands-on expertise in data warehousing concepts and implementation Deep knowledge of Kimball dimensional modelling methodology. Platforms & Tools Experience with Databricks (preferred) or similar platforms: Snowflake, BigQuery, Redshift, Synapse, or equivalent Strong proficiency with: SQL (advanced level) Spark/PySpark Data pipeline orchestration tools (e.g., Airflow ...

solid foundation in systems development: must understand the system development life cycle, project management approaches, and requirements, design, and test techniques.Demonstrable experience of data modelling and design in a large complex organisation Experience and understanding of both established and emerging data technologies, including established data management and reporting technologies.Expert … knowledge of SQL databases alongside some knowledge of columnar and NoSQL databases, predictive analytics, data visualization, and unstructured dataStrong understanding of various data modelling methodologies (e.g., dimensional modelling, data vault).Demonstrate a good understanding of Data/Information Governance principles and familiarity with processes, policies ...

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

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

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

large-scale Azure data transformation programme. You'll play a key role in shaping a modern Data Lakehouse environment, driving best practice in data modelling, governance, and analytics while working closely with senior stakeholders across the business. The Company This organisation is a well-established UK professional services business … focused on improving data visibility, strengthening governance, and enabling more advanced analytics across the business. The Role You will lead data architecture and modelling across a modern cloud platform, ensuring data is structured, governed, and accessible for reporting and analytics.Responsibilities include: Designing enterprise-wide data models within a Medallion ...

platform reliability and supportability.Collaborate with engineers, analysts and stakeholders to deliver practical solutions.Essential SkillsStrong 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 and data processing.Azure DevOps ...

+ benefits This is a rare opportunity to join an organisation undertaking a major data and digital transformation, with a clear path from data modelling into data architecture. You will step into a role designed for long-term growth, working closely with senior architects and influencing how data … support key business initiatives Contribute to the design and evolution of data architecture standards and best practices Work across multiple projects, ensuring consistency in modelling approaches and data structures Collaborate with data engineers, analysts, and governance teams to deliver high-quality data solutions Support the transition towards modern, cloud ...

reports, dashboards and self-service experiences for a range of audiences, including senior executives. Design, develop and maintain robust semantic models using best-practice modelling principles, with a particular focus on models that support Data Agents and natural-language access to trusted data Translate business intelligence questions into clear … capacity units, consumption, performance and workload optimisation. Strong hands-on experience building, managing and developing Power BI reports and dashboards. Strong understanding of dimensional modelling, semantic models, relationships, measures, reusable metrics and best-practice Power BI architecture. Experience designing models for self-service analytics, governed reporting and/ ...

Spark, SQL, and PythonExperience developing and optimizing batch and real-time data processing solutionsStrong understanding of modern data architecture patterns, including Kimball, Data Vault, dimensional modelling, and data product design principlesExperience implementing Infrastructure as Code using tools such as Terraform or CloudFormationExperience leading technical delivery teams and mentoring ...

strategies for products, customers, suppliers, and stores, establishing authoritative sources and harmonization patterns across systems together with master data responsible.Establishing data quality measures and modelling standards embedded in architectural patterns: operational schemas in bronze, conformed and dimensional entities in silver, and consumption-ready models in gold.Reviewing key physical … implementation, ensuring consistent understanding across technical and business stakeholders.Mentoring teams on data architectural best practices while documenting anti-patterns to avoid common pitfalls in dimensional modelling and naming standards.The successful candidateProven experience designing enterprise-scale information architectures (multi-source, multi-domain at scale) that successfully went into production.Domain ...

products, customers, suppliers, and stores, establishing authoritative sources and harmonization patterns across systems together with master data responsible. Establishing data quality measures and modelling standards embedded in architectural patterns: operational schemas in bronze, conformed and dimensional entities in silver, and consumption-ready models in gold. Reviewing key physical … ensuring consistent understanding across technical and business stakeholders. Mentoring teams on data architectural best practices while documenting anti-patterns to avoid common pitfalls in dimensional modelling and naming standards. Qualifications Proven experience designing enterprise-scale information architectures (multi-source, multi-domain at scale) that successfully went into production. ...

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