1 to 25 of 42 Remote/Hybrid Permanent Dimensional Modelling Jobs

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

senior level while remaining hands-on with architecture and modelling. The Role You will act as the technical authority for data architecture and modelling across a modern Azure environment. Key responsibilities include: Designing and governing enterprise-wide data models across a Medallion Architecture framework Creating curated data models using … dimensional modelling and Kimball methodologies Defining modelling standards, governance frameworks, and data feed specifications Supporting the design of semantic layers that enable reporting, analytics, and future AI use cases Collaborating closely with Data Engineers and Analytics Engineers in an agile delivery environment Producing architecture documentation, diagrams ...

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

transformation. You'll play a key role in shaping the future of the company's data platform, becoming the go-to expert for data modelling and architecture whilst helping drive the move towards advanced analytics and data-driven decision making. THE COMPANY Our client is a well-established professional … platform, the business is now focused on building innovative data solutions and creating greater value from its data assets. THE ROLE Own the data modelling and architecture strategy across a modern Azure Data Lakehouse environment Design and govern enterprise-wide data models across Medallion Architecture layers Create scalable curated ...

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

SaaS platforms, files and other business systems Design and develop scalable ETL and ELT processes using modern data engineering tools and cloud platforms Create dimensional models, semantic layers and reusable datasets that provide consistent business metrics across the organisation Develop efficient SQL and transformation logic to support analytics, reporting … business intelligence requirements Implement automated data quality controls, validation frameworks and monitoring processes Optimise platform performance through effective modelling, query tuning and infrastructure design Manage deployments across environments and support CI/CD and DataOps practices Configure security, governance and access controls to ensure data integrity and compliance Build ...

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

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

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

data pipelines (ingestion transformation reporting) using Azure services Work hands-on with tools including ADF, Synapse, ADLS and Microsoft Fabric Develop and optimise dimensional data models (Kimball/star schema) for analytics and reporting Provide technical guidance and support to BI Developers during delivery (non-managerial) Contribute to Power … Azure Synapse/Azure SQL Azure Data Lake (ADLS) Exposure to Microsoft Fabric (highly desirable) Strong background in data warehousing and BI environments Excellent dimensional modelling (Kimball) experience Experience working closely with BI/reporting teams (Power BI, semantic models, DAX) Confident working across end-to-end data ...

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

Lakehouse Fabric Warehouse Data Factory Notebooks Power BI Semantic Models Dataflows ✅ Advanced SQL development skills ✅ Python and/or PySpark experience ✅ Strong understanding of dimensional modelling and data warehousing concepts ✅ Experience building enterprise-scale data integration and pipeline solutions ✅ Strong Power BI development expertise, including DAX optimisation ...

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

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

Bring ✅ Extensive hands-on experience with Databricks , and Microsoft Azure data tools (must-have: Azure Data Factory, Azure Synapse, or Azure SQL). ✅ Dimensional modelling/DWH Design ✅ Medallion Architecture ✅ Strong ETL/ELT development skills. ✅ Python scripting experience for data automation. ✅ Experience with CI/CD methodologies ...

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

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