26 to 50 of 96 Dimensional Modelling Jobs in the UK

services (Azure Data Factory, ADLS Gen2, Azure SQL, Synapse or Databricks)Solid understanding of data warehousing and lakehouse concepts, Delta/Parquet formats and dimensional modeling (Kimball)Experience with Real-Time Intelligence (Eventstreams, Eventhouse/KQL, Activator)Ability to turn architecture documents and requirements into working, well-documented solutionsAnalytical ...

maintain scalable ETL/ELT pipelines, ensuring data quality, integrity and reconciliation throughout the migration. Develop and optimise data warehouse structures, star schemas and dimensional models to support business and regulatory reporting. Apply best practices for Snowflake performance tuning, query optimisation and cost efficiency. Implement automated testing, source control … Experience Extensive hands-on experience developing solutions in Snowflake , ideally with at least three years of dedicated experience. Strong experience with dbt , including data modelling, transformation, testing and deployment. Advanced Python development skills for data engineering and automation. Strong SQL Server experience, including database design, query optimisation, performance tuning ...

looking for: Solid experience in data architecture, with a track record of designing and delivering enterprise-scale data solutions Proficiency in data modelling techniques (e.g. dimensional modelling, data vault, medallion architecture) and strong SQL skills Experience with cloud data platforms, particularly AWS, as well as platforms such ...

technologies.We are looking for:Solid experience in data architecture, with a track record of designing and delivering enterprise-scale data solutionsProficiency in data modelling techniques (e.g. dimensional modelling, data vault, medallion architecture) and strong SQL skillsExperience with cloud data platforms, particularly AWS, as well as platforms such ...

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

decision-making, service performance and client reporting.Key ResponsibilitiesDesign, develop and maintain Power BI reports and semantic models.Design and maintain scalable data models, including relationships, dimensional structures and reusable semantic layers.Build DAX measures and Power Query transformations to support accurate and efficient reporting.Develop reporting across SLA/KPI performance … skills.Strong experience developing reports using Power BI.Advanced knowledge of DAX and Power Query (M).Experience working with large datasets and multiple data sources.Strong data modelling capability, including relationships, dimensional modelling and semantic model design.Strong analytical, problem-solving and data-validation skills.Ability to manage competing priorities and work ...

data issues arising from the data intake platform. Reporting to the Data & BI Lead, the successful candidate will work closely with IT on data modelling for Silver and Gold, bringing strong technical input to those discussions, while collaborating with the wider business, from Underwriters to Actuaries. Key Responsibilities: Design … maintain Silver and Gold table transformations within the Azure Databricks lakehouse, in line with agreed medallion architecture principles Contribute technical input into data modelling discussions for Silver and Gold layers, working closely with IT to ensure models are performant and aligned to Munich Re modelling standards Investigate ...

DescriptionRole – Data Modelling LeadTechnology – Snowflake, SQL Server, PostgreSQL, Data Warehousing, Data Lake, Medallion, Data Vault, Data Fabric, Semantic modellingLocation – London, UKJob DescriptionWe are seeking an experienced Data Modeler who can analyse and understand the existing customer data and analytics models on SQL Server, and design efficient data models … Analysts to gather requirements and translate them into optimized data structures, ensuring scalability and compliance with industry standards.Your roleIn the role of a Data Modelling Lead, you will be responsible for leading the design and transformation of enterprise data models to support scalable, high-performance analytics and reporting solutions. ...

experience with Azure SQL Database and SQL Server.Proficiency in Python, PySpark, Scala and Spark for data processing and distributed computing.Understanding of data warehousing concepts, dimensional modelling and ETL/ELT frameworks.Knowledge of data quality, data governance, metadata management and data security principles.Experience with CI/CD pipelines using ...

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

with Azure Databricks and Azure SQL/SQL Server to process and manage large datasets. Design and implement data models using Kimball, 3NF and dimensional modelling approaches. Develop metadata-driven pipelines to improve automation and efficiency. Work closely with technical teams and clients to understand data requirements ...

collaboratively with other members of the IT and development teams. What Were Looking For Essential Hands-on experience with Power BI Desktop, including data modelling, Power Query and report development. Good working knowledge of DAX, including an understanding of measures, filter context and relationships. Good SQL development skills, including … joins, aggregations, and window functions. Good understanding of dimensional modelling, including facts, dimensions and star-schema design. Experience working with relational databases and data warehouse environments. Strong attention to detail and a disciplined approach to validating the accuracy and consistency of data. Ability to investigate discrepancies between reports ...

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

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

practicesExperience contributing to or leading data warehouse architecture or redesign initiativesAbility to collaborate effectively with technical and non-technical stakeholdersStrong experience with data warehousing, dimensional modelling, and data architectureTeya is proud to be an equal opportunity employer. We are committed to creating an inclusive environment where everyone regardless ...

including S3, Lambda, Glue, Athena, Kinesis, RDS, IAM and CloudWatch. Lakehouse architectures and open table formats such as Iceberg. Medallion-style data layering and dimensional modelling. Strong SQL and Python development skills. Infrastructure as code using Terraform. CI/CD, automated testing and modern engineering practices. SQL Server, SSIS ...

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

delivery. Success will mean turning complex business requirements into clear, trusted and scalable insight. You will work across the analytics lifecycle, from data modelling and pipeline development through to dashboard performance, stakeholder adoption and continuous improvement, while also assessing where automation and emerging AI capabilities can create practical value. … technical audiences. Requirements Demonstrable experience delivering business intelligence solutions in a live operational or commercial environment. Strong Power BI capability, including dashboard development, semantic modelling, visual design and performance optimisation. Advanced SQL skills with the ability to develop efficient queries, transformations and analytical logic. Practical experience building, monitoring ...

Python Experience developing and optimizing batch and real-time data processing solutions Strong understanding of modern data architecture patterns, including Kimball, Data Vault, dimensional modelling, and data product design principles Experience implementing Infrastructure as Code using tools such as Terraform or CloudFormation Experience leading technical delivery teams ...

Python Experience developing and optimizing batch and real-time data processing solutions Strong understanding of modern data architecture patterns, including Kimball, Data Vault, dimensional modelling, and data product design principles Experience implementing Infrastructure as Code using tools such as Terraform or CloudFormation Experience leading technical delivery teams ...

Python Experience developing and optimizing batch and real-time data processing solutions Strong understanding of modern data architecture patterns, including Kimball, Data Vault, dimensional modelling, and data product design principles Experience implementing Infrastructure as Code using tools such as Terraform or CloudFormation Experience leading technical delivery teams ...

CTEs, query optimization. Experience with cloud data platforms (e.g., Snowflake, Azure Synapse, BigQuery, Databricks). Expertise in data modeling concepts: star/snowflake schemas, dimensional modeling,semantic layers, and performance tuning at scale. Experience with Python or R for data wrangling and exploratory analysis. Analytical & Business Acumen Strong ability ...

Working with business stakeholders and providing technical leadership through delivery What You'll Bring Extensive hands-on Snowflake experience, with strong dbt for transformation, modelling and deployment Python for data engineering, particularly loading and processing files Solid grounding in data warehousing, dimensional modelling, source control ...

Working with business stakeholders and providing technical leadership through delivery What You'll Bring Extensive hands-on Snowflake experience, with strong dbt for transformation, modelling and deployment Python for data engineering, particularly loading and processing files Solid grounding in data warehousing, dimensional modelling, source control ...

data architecture and optimised analytical datasets.Own data model delivery for the domain area, ensuring documentation and data definitions are accurate and accessible.ColleagueChampion data literacy, modelling best practices, and standard transformation guidelines across the organisation.Mentor trainee data practitioners on SQL standards, data testing, version control, and business domain context.Facilitate clear … priorities.More about you What we’re looking for:Skills, Qualifications and ExperienceAs a Data & Analytics Specialist - Analytics Engineer you will have experience of: Data Modelling: Proven experience building and maintaining data models using recognised patterns (e.g., Kimball, Inmon, dimensional modelling).Semantic Layer Architecture: Hands-on experience building ...