51 to 75 of 104 Dimensional Modelling Jobs in the UK

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

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

platform reliability and supportability.Collaborate with engineers, analysts and stakeholders to deliver practical solutions.Essential SkillsStrong 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 and data processing.Azure DevOps ...

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

transformation processes. Key Responsibilities Analyse existing datasets and data structures to help prioritise, design and implement the enterprise data platform. Design and implement dimensional data models within Snowflake to support enterprise reporting and analytics. Build and maintain production-grade data transformation workflows using robust development, testing, version control … client data. Contribute to data engineering standards, naming conventions, development practices and CI/CD processes. Support data analysis, data architecture and enterprise data modelling activities across existing and new data platforms. Work closely with technical and business stakeholders to understand requirements and translate them into effective data solutions. ...

reports, dashboards and self-service experiences for a range of audiences, including senior executives. Design, develop and maintain robust semantic models using best-practice modelling principles, with a particular focus on models that support Data Agents and natural-language access to trusted data Translate business intelligence questions into clear … capacity units, consumption, performance and workload optimisation. Strong hands-on experience building, managing and developing Power BI reports and dashboards. Strong understanding of dimensional modelling, semantic models, relationships, measures, reusable metrics and best-practice Power BI architecture. Experience designing models for self-service analytics, governed reporting and/ ...

experience with DBT, building and maintaining modular, scalable data models that follow best practices Previous experience working on Data Quality engagements Strong understanding of dimensional modelling Strong understanding of Data Quality and how it is measured Desireable: Experience writing complex validation logic using tools like Great Expectations ...

BI.* Advanced SQL skills, including complex query writing, optimisation, and working with large datasets.* Solid understanding of data warehousing principles, ETL/ELT processes, dimensional modelling, and data transformation.* Experience working with ETL/ELT tools such as Azure Data Factory, SSIS, or similar technologies.* Experience delivering ...

Spark, SQL, and PythonExperience developing and optimizing batch and real-time data processing solutionsStrong understanding of modern data architecture patterns, including Kimball, Data Vault, dimensional modelling, and data product design principlesExperience implementing Infrastructure as Code using tools such as Terraform or CloudFormationExperience leading technical delivery teams and mentoring ...

Spark, SQL, and PythonExperience developing and optimizing batch and real-time data processing solutionsStrong understanding of modern data architecture patterns, including Kimball, Data Vault, dimensional modelling, and data product design principlesExperience implementing Infrastructure as Code using tools such as Terraform or CloudFormationExperience leading technical delivery teams and mentoring ...

work at a successful electronics distributor Previous experience as a data analyst Data Analyst Experience translating business problems into analytical solutions Experience of data modelling principles, including dimensional modelling, relational databases and business logic design. Data Analyst PowerBI for data visualisation and dashboard creation SQL for data ...

distributor Previous experience as a data analyst - please do not apply otherwise Data Analyst Experience translating business problems into analytical solutions Experience of data modelling principles, including dimensional modelling, relational databases and business logic design. Advanced Excel skills Data Analyst PowerBI for data visualisation and dashboard creation ...

. Extensive SQL development and performance tuning expertise. Experience building and supporting ETL/ELT frameworks. Strong understanding of data warehousing concepts and dimensional modelling. AWS experience, including services such as S3, Glue, EMR, or PySpark . Knowledge of data governance, quality controls, and testing practices. Experience working within ...

queriesHands on experience with DBT, building and maintaining modular, scalable data models that follow best practicesPrevious experience working on Data Quality engagementsStrong understanding of dimensional modellingStrong understanding of Data Quality and how it is measuredDesireable: Experience writing complex validation logic using tools like Great Expectations, dbt tests, Elementary, Soda ...

strategies for products, customers, suppliers, and stores, establishing authoritative sources and harmonization patterns across systems together with master data responsible.Establishing data quality measures and modelling standards embedded in architectural patterns: operational schemas in bronze, conformed and dimensional entities in silver, and consumption-ready models in gold.Reviewing key physical … implementation, ensuring consistent understanding across technical and business stakeholders.Mentoring teams on data architectural best practices while documenting anti-patterns to avoid common pitfalls in dimensional modelling and naming standards.The successful candidateProven experience designing enterprise-scale information architectures (multi-source, multi-domain at scale) that successfully went into production.Domain ...

products, customers, suppliers, and stores, establishing authoritative sources and harmonization patterns across systems together with master data responsible. Establishing data quality measures and modelling standards embedded in architectural patterns: operational schemas in bronze, conformed and dimensional entities in silver, and consumption-ready models in gold. Reviewing key physical … ensuring consistent understanding across technical and business stakeholders. Mentoring teams on data architectural best practices while documenting anti-patterns to avoid common pitfalls in dimensional modelling and naming standards. Qualifications Proven experience designing enterprise-scale information architectures (multi-source, multi-domain at scale) that successfully went into production. ...

Code Developing reusable Gold Layer assets and analytics-ready datasets for enterprise consumption Building and maintaining data pipelines and transformation frameworks using dbt Designing dimensional data models and Star Schema structures Contributing to a rapidly evolving Data & AI capability What We're Looking For Essential Experience Excellent commercial experience … with Snowflake Experience delivering data solutions within Wealth Management, Asset Management, Investment Management or Financial Services environments Excellent understanding of Star Schema/dimensional modelling Strong experience with dbt Strong SQL and data engineering capability Strong data quality, lineage and governance experience Exposure to market data platforms ...

deliver consistently, securely and at scale. A strong technical practitioner with advanced skills in DAX, SQL and Python, combined with deep expertise in dimensional modelling and analytics data architecture design.What's in it for youBeing a part of M&S is exactly that – playing your part to bring ...

Jobs.· Collaborate on CI/CD with Platform (Repos, Git, deployment pipelines, Terraform Jobs/Infrastructure as Code).Analytics Engineering· Model curated gold datasets, dimensional models, and semantic layers for BI (Tableau/PowerBI).· Optimise SQL Warehouses for performance, concurrency, and cost; maintain versioned metric definitions.· Document tables ...

stakeholders across the end-to-end data lifecycle. YOU WILL: Have expertise in Power BI given Microsoft stack preference across our client base. Data modelling: you should be able to build and maintain semantic models, work upstream (engineering) as well as downstream (dashboard & reports). Experienced with Tableau, Looker … enablement. Working exposure to at least one of AWS, GCP or AWS. Strong SQL skills for data extraction, transformation and analysis. Experience working with dimensional modelling concepts (e.g. Star Schema, Kimball principles). Understanding of Data Warehousing, Lakehouse and Medallion architectures. TOTAL REWARDS: Total Rewards associated with this ...

analytics engineering or data engineering with a strong focus on data modelingStrong proficiency in dbt and SQL- building modular, well-tested modelsSolid understanding of dimensional modeling and metric designExperience working with cloud data warehouses (BigQuery, Snowflake, or Redshift)Experience with metrics/semantic layers (e.g. dbt metrics, MetricFlow, Cube ...

complex security, IT, and business datasets to identify trends, anomalies, data quality issues, and emerging risks.Experience with data modeling (star/snowflake schema, dimensional modeling).Proficiency with relational database (SQL) and programming/scripting (Python or R).Typically 2 years of relevant experience in information security, IT, data analysis ...

scalable data solutions within Snowflake Building and maintaining data pipelines and transformation frameworks using dbt Working with complex market, investment and risk datasets Designing dimensional data models and Star Schema structures Supporting portfolio suitability and regulatory reporting initiatives Implementing data quality, validation and governance controls Working closely with investment … practices and AI-assisted development tools What We're Looking For Essential Experience Strong commercial experience with Snowflake Excellent understanding of Star Schema/dimensional modelling Experience with dbt Strong SQL and data engineering capability Experience working with time-series market data Exposure to market data platforms ...

prototyping and proof-of-concept builds within Databricks to demonstrate platform capabilities and accelerate client adoption Provide best practice guidance on Lakehouse architecture, data modelling, workload optimisation, and cost management Produce high-quality technical documentation including architecture diagrams, architecture decision records (ADRs), runbooks, and deployment guides Enable client teams … e.g. Terraform preferred) and CI/CD pipelines (e.g. Azure DevOps, GitHub Actions) Solid understanding of data architecture concepts including Lakehouse medallion architecture and dimensional modelling Familiarity with security and governance frameworks (e.g. RBAC, ABAC, data masking, audit, compliance standards) Excellent communication skills with the ability to explain ...

strong working knowledge of development practices and tools (code repositories, build tools, scripting languages, agile development) Deep SQL expertise and demonstrated comfort with dimensional modelling against warehouses with hundreds of tables. Hands-on experience with enterprise BI tools such as Tableau, PowerBI, or eazyBI. Strong working knowledge ...