1 to 25 of 51 Dimensional Modelling Jobs

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. Programming/Query Strong expertise in SQL for data transformation and performance optimization Python (preferred) for automation and data engineering ...

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. Programming/Query Strong expertise in SQL for data transformation and performance optimization Python (preferred) for automation and data engineering ...

long-standing data team. This is a traditional on-prem BI Developer/SQL Data Engineer role, focused on database development, ETL, data modelling, and data warehouse work. If you enjoy hands-on SQL development, building robust ETL solutions, and working in a supportive environment where the team shares … work across the full data lifecycle, including: Developing and optimising SQL databases Creating and maintaining SSIS packages Designing and delivering ETL processes Performing data modelling and dimensional modelling Supporting and enhancing the on-prem data warehouse xehkeey Handling ad-hoc support, troubleshooting, and performance tuning Required Experience ...

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

OVERVIEW: We are seeking an experienced Data Architect/Data Modeler with strong insurance industry standards knowledge and a solid foundation in modern data modelling practices. The ideal candidate will have hands-on experience with modelling tools, data frameworks, and insurance industry data exchange standards. This role involves … Excel bordereaux templates to support real-time API ingestion from MGA/TPA partner systems and monthly bordereaux submissions Develop data models using Dimensional (Star/Snowflake), Data Vault, and 3NF methodologies. Create and manage metadata and modelling artefacts using Erwin with traceability and governance. Support Medallion Architecture ...

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

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

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

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

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

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

with Azure data services , including Azure Data Factory, Databricks, Azure Synapse, and Azure SQL. Good understanding of data warehouse design , including star schema and dimensional modelling. Experience working with Azure Data Lake/Blob Storage and cloud-native data architectures. Strong proficiency in SQL , with experience designing and optimising ...

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

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