1 to 25 of 40 Remote/Hybrid Dimensional Modelling Jobs in England

Kafka, Flink, Beam or equivalent. Deep knowledge of modern data architectures including data warehouses, data lakes and lakehouse platforms. Strong understanding of analytical data modelling, dimensional modelling, semantic modelling and data product design. Experience designing data structures and models that support reporting, self-service analytics, machine ...

Spark, Kafka, Flink, Beam or equivalent.Deep knowledge of modern data architectures including data warehouses, data lakes and lakehouse platforms.Strong understanding of analytical data modelling, dimensional modelling, semantic modelling and data product design.Experience designing data structures and models that support reporting, self-service analytics, machine learning ...

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

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

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

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

team if you have the following skills, knowledge and experienceStrong SQL skills and experience building analytical data models in a production environmentData modelling approaches such as dimensional modelling, star schemas, metric layers or similarWorking with dbt or similar transformation and orchestration toolsBuilding semantic models or reusable business … agents consume structured data, metric definitions and business contextExperience working with data contracts, medallion-style architecture or silver-to-gold data modelling patternsWhat success looks likeSuccess in this role is about helping the business trust and use data with confidence.You’ll create reliable analytical models, clear metric definitions ...

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