1 to 25 of 48 Dimensional Modelling Jobs

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

Market expertise to design, govern, and evolve enterprise-grade data models across policy, underwriting, pricing, and claims domains. The role requires strong hands-on modelling capability combined with the ability to work with senior business stakeholders , translate London Market processes into robust data structures, and support cloud-based, analytics … ideal candidate will have strong knowledge of Syndicates, Delegated Authority, Reinsurance (including Ceded Reinsurance) and be proficient in selecting and applying the right modelling techniques (Canonical, Data Vault, Dimensional) across Silver, Gold, and Semantic layers . Key Responsibilities Data Modelling & Architecture Design and maintain enterprise-wide data ...

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

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

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

implementations Required Skills & Experience 8 - 12 years of experience in data modeling within the Financial Services industry Strong expertise in data modeling techniques (e.g., dimensional modeling, 3NF, Data Vault) Proficiency in SQL and experience with relational and non-relational databases Hands-on experience with data modeling tools (e.g., ERwin ...

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

Senior Data Modeller to design and govern enterprise-grade data models across core insurance domains. This role requires deep domain knowledge, hands-on modelling expertise, and the ability to work closely with senior stakeholders. Key Responsibilities Design and maintain enterprise data models across policy, underwriting, claims and reinsurance Develop … govern Data Vault and Dimensional models Select appropriate modelling approaches based on integration, analytics and audit requirements Design data structures aligned to cloud and Medallion architectures Lead data modelling workshops and design sessions Embed data quality, governance, and traceability into models Required Experience: Extensive experience ...