1 to 25 of 49 Dimensional Modelling Jobs in the UK

standards of data quality and integrity Design and implement cloud-based data lake and data warehousing architectures Create and maintain analytical data marts using dimensional modelling techniques (e.g. star and snowflake schemas) Work collaboratively with analysts, data scientists, and business stakeholders to translate requirements into technical solutions Monitor … solutions Advanced skills in SQL and Python, with experience using distributed processing frameworks such as Spark Demonstrated experience building analytical data marts and applying dimensional modelling principles Hands-on experience implementing Infrastructure as Code, ideally using Terraform or similar tooling Familiarity with DevOps concepts, CI/CD pipelines ...

tools such as Azure Data Factory and/or Fabric Data Pipelines Experience with Python or PySpark for data transformation Understanding of data modelling (dimensional modelling, medallion architecture) Strong communication skills and ability to work with non-technical stakeholders Desirable: Experience migrating from legacy systems (e.g. ...

optimisation * Relational databases: PostgreSQL at production scale - query optimisation, indexing strategies, table partitioning, replication, schema design for both OLTP and analytical workloads * MongoDB - document modelling, aggregation pipelines, indexing strategy, replica sets; clear judgment on when document vs relational storage is the right architectural call * Containerisation: Docker and Kubernetes-based … deployment of data workloads; reproducible, environment-agnostic data infrastructure * Data modelling for analytical workloads - dimensional modelling, data vault, or equivalent; schema evolution, slowly changing dimensions, and downstream impact analysis * Stream and batch processing patterns; late data handling, watermarking, and backfill strategies; throughput vs latency trade-offs ...

e.g., Azure SQL, Snowflake). Experience with ETL/ELT tooling (e.g., SSIS, dbt, Azure Data Factory) and data pipeline design. Understanding of data modelling principles (normalisation, dimensional modelling/star schema for data warehousing). Experience of diagnosing and resolving database performance issues. Familiarity with database ...

e.g., Azure SQL, Snowflake). Experience with ETL/ELT tooling (e.g., SSIS, dbt, Azure Data Factory) and data pipeline design. Understanding of data modelling principles (normalisation, dimensional modelling/star schema for data warehousing). Experience of diagnosing and resolving database performance issues. Familiarity with database ...

collaborative manner in a large, fast paced environment within a multifunctional technical team Nice to have Languages: PySQL, C#, R Reporting: PowerBI or similar Modelling: SQL Server SSAS Tabular (DAX)/Dimensional Modelling/Data Warehousing Development Management: Azure DevOps SQL MI/DB ETL: Active Batch ...

their data strategy, advising senior stakeholders and articulating architecture decisions with clarity and confidence. Quality, Standards & Best Practice Create and enforce architectural guidelines, including modelling standards, reference architectures, blueprints and reusable components to ensure consistent delivery quality. Technology Strategy & Continuous Improvement Stay current with emerging data platform technologies, architectural … architectures in large-scale, enterprise or transformation programmes. Proven expertise designing cloud-native data platforms across Azure, GCP or AWS. Strong background in data modelling methodologies (Kimball, 3NF, Data Vault, dimensional modelling). Experience with modern data transformation approaches — familiarity with DBT and analytics engineering principles ...

ingestion frameworks for integrating multiple source systems into the cloud data platform. Design and govern data transformation frameworks using DBT. Define and enforce data modelling standards including dimensional modelling, star schema, and enterprise data models. Lead architecture reviews and solution design discussions for new data initiatives. Optimize … Platform Strong experience with Amazon Web Services, including: S3 IAM AWS Glue Lambda CloudWatch Data Transformation Strong experience with DBT for enterprise-scale data modelling, testing, and transformation pipelines. ...

work closely with engineers and stakeholders across the business, providing technical leadership and taking ownership. Key responsibilities include: Designing and building curated datasets using dimensional and semantic modelling techniques Developing and maintaining SQL and PySpark transformation pipelines Partnering closely with Data Engineers Translating business requirements into clear, well … documented data models YOUR SKILLS AND EXPERIENCE: Advanced SQL, including complex transformations and modelling Databricks PySpark and working within a Lakehouse or modern data platform Dimensional modelling and analytics engineering best practices Communicating effectively with both technical and non-technical stakeholders THE BENEFITS: You will receive ...

work closely with engineers and stakeholders across the business, providing technical leadership and taking ownership. Key responsibilities include: Designing and building curated datasets using dimensional and semantic modelling techniques Developing and maintaining SQL and PySpark transformation pipelines Partnering closely with Data Engineers Translating business requirements into clear, well … documented data models YOUR SKILLS AND EXPERIENCE: Advanced SQL, including complex transformations and modelling Databricks PySpark and working within a Lakehouse or modern data platform Dimensional modelling and analytics engineering best practices Communicating effectively with both technical and non-technical stakeholders THE BENEFITS: You will receive ...

work closely with engineers and stakeholders across the business, providing technical leadership and taking ownership. Key responsibilities include: Designing and building curated datasets using dimensional and semantic modelling techniques Developing and maintaining SQL and PySpark transformation pipelines Partnering closely with Data Engineers Translating business requirements into clear, well … documented data models YOUR SKILLS AND EXPERIENCE: Advanced SQL, including complex transformations and modelling Databricks PySpark and working within a Lakehouse or modern data platform Dimensional modelling and analytics engineering best practices Communicating effectively with both technical and non-technical stakeholders THE BENEFITS: You will receive ...

work closely with engineers and stakeholders across the business, providing technical leadership and taking ownership. Key responsibilities include: Designing and building curated datasets using dimensional and semantic modelling techniques Developing and maintaining SQL and PySpark transformation pipelines Partnering closely with Data Engineers Translating business requirements into clear, well … documented data models YOUR SKILLS AND EXPERIENCE: Advanced SQL, including complex transformations and modelling Databricks PySpark and working within a Lakehouse or modern data platform Dimensional modelling and analytics engineering best practices Communicating effectively with both technical and non-technical stakeholders THE BENEFITS: You will receive ...

work closely with engineers and stakeholders across the business, providing technical leadership and taking ownership. Key responsibilities include: Designing and building curated datasets using dimensional and semantic modelling techniques Developing and maintaining SQL and PySpark transformation pipelines Partnering closely with Data Engineers Translating business requirements into clear, well … documented data models YOUR SKILLS AND EXPERIENCE: Advanced SQL, including complex transformations and modelling Databricks PySpark and working within a Lakehouse or modern data platform Dimensional modelling and analytics engineering best practices Communicating effectively with both technical and non-technical stakeholders THE BENEFITS: You will receive ...

work closely with engineers and stakeholders across the business, providing technical leadership and taking ownership. Key responsibilities include: Designing and building curated datasets using dimensional and semantic modelling techniques Developing and maintaining SQL and PySpark transformation pipelines Partnering closely with Data Engineers Translating business requirements into clear, well … documented data models YOUR SKILLS AND EXPERIENCE: Advanced SQL, including complex transformations and modelling Databricks PySpark and working within a Lakehouse or modern data platform Dimensional modelling and analytics engineering best practices Communicating effectively with both technical and non-technical stakeholders THE BENEFITS: You will receive ...

analysis Create compelling, insight-led storytelling reports for technical and non-technical audiences Liaise with stakeholders to share findings and drive action Data, BI & Modelling Perform data manipulation, mining, validation and transformation across Azure, Snowflake and other data warehouses Design and develop scalable data solutions, pipelines and warehouse structures … Build and maintain Power BI data models using Kimball dimensional modelling (fact/dim tables) Develop advanced Power BI solutions using DAX, Power Query and Row Level Security Create clear, engaging and innovative visualisations that enable insight-led decision making Implement governance, access controls and data quality assurance ...

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

programming language commonly used in data engineering, preferably Python. Scala or Java is a plus. Solid understanding of data warehousing concepts, data modeling techniques (dimensional modeling, Kimball, Inmon), and ETL/ELT processes. Experience with version control systems (e.g., Git). Strong analytical, problem-solving, and debugging skills. Excellent ...

well as contribute to architectural direction and best practices. Key Responsibilities Design and maintain scalable data architectures across Snowflake and Databricks Lead schema design, dimensional modelling, and SQL performance optimisation Build robust ETL/ELT pipelines Develop resilient API ingestion workflows Implement data quality frameworks and enforce data … Skills and Experience Management of technical teams and near shore partners 5+ years hands-on Data Engineering experience Expert-level SQL and advanced data modelling Strong Python Experience with Snowflake and Databricks Cloud experience Experience with orchestration tools (Airflow, Prefect) CI/CD and DataOps experience for data platforms ...

well as contribute to architectural direction and best practices. Key Responsibilities Design and maintain scalable data architectures across Snowflake and Databricks Lead schema design, dimensional modelling, and SQL performance optimisation Build robust ETL/ELT pipelines Develop resilient API ingestion workflows Implement data quality frameworks and enforce data … Skills and Experience Management of technical teams and near shore partners 5+ years’ hands-on Data Engineering experience Expert-level SQL and advanced data modelling Strong Python Experience with Snowflake and Databricks Cloud experience Experience with orchestration tools (Airflow, Prefect) CI/CD and DataOps experience for data platforms ...

well as contribute to architectural direction and best practices. Key Responsibilities Design and maintain scalable data architectures across Snowflake and Databricks Lead schema design, dimensional modelling, and SQL performance optimisation Build robust ETL/ELT pipelines Develop resilient API ingestion workflows Implement data quality frameworks and enforce data … Skills and Experience Management of technical teams and near shore partners 5+ years’ hands-on Data Engineering experience Expert-level SQL and advanced data modelling Strong Python Experience with Snowflake and Databricks Cloud experience Experience with orchestration tools (Airflow, Prefect) CI/CD and DataOps experience for data platforms ...

integration patterns Design and govern scalable data models for both enterprise and time-series data, ensuring consistency and reuse Establish standards for data modelling, transformation, and pipeline design across analytical and operational use cases Work closely with data engineering teams to ensure pipelines align with agreed architectural patterns … lakes/warehouses, and pipeline design Experience working closely with data engineering teams, and contributing directly to delivery where needed Strong knowledge of data modelling techniques (e.g. dimensional modelling, normalisation, time-series considerations) Familiarity with both structured enterprise data and high-volume time-series data environments Experience ...

CTEs, with experience in query optimization, performance tuning, and designing data models for relational databases. Good understanding of relational databases, data warehousing concepts, and dimensional modelling (Kimball or similar). Experience collaborating within agile scrum delivery teams, throughout SDLC and contributing to iterative development cycles. Methodologies. Familiarity with ...

medallion architecture and Delta Lake Desirable Experience with Azure Synapse Analytics Experience with Azure Data Factory Experience in financial services or regulated environments Dimensional modelling/star schema knowledge Databricks Certification What you'll get in return Competitive Salary Great Career Progression Hybrid Working Policy - 2 days ...

clients § A deep grounding in data: for example, you should have experience of translating business data and requirements to analytical data models (e.g. Kimball dimensional modelling) § A broad understanding of data and AI: across data engineering, data visualisation, generative AI and automation § Experience leading teams: you need ...

support excellent customer service, and help deliver our vision of Improving People’s Lives. What You’ll Do: Power BI; Coding DAX Measures and Dimensional Models. Developing & delivering visually compelling Power BI Dashboards & Reports to specification. Delivering data engineering solutions with Microsoft Fabric, SQL and Python. Developing & maintaining ...