76 to 100 of 160 Dimensional Modelling Jobs in the UK

enabled analytics, Copilot and natural language reporting capabilities. Desirable Exposure to Microsoft Fabric including Lakehouses, Warehouses, Dataflows Gen2 and Semantic Models. Experience designing dimensional models and star schemas to support reporting and analytics solutions. Azure data services, Databricks or cloud-based analytics platforms. Agile delivery environments. Data dictionaries, report ...

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

Senior Data Engineer - Databricks - Pyspark - Dimensional Models - Unity Catalog - Kimball - Perm We're looking for a Senior Analytics Engineer to lead the design and delivery of curated, analytics-ready data within our Lakehouse environment. You'll translate complex business requirements into robust SQL and PySpark pipelines, own the data … analytics and BI. You'll also provide technical leadership and mentorship, helping to establish best practices across the team. Key Responsibilities: Design and deliver dimensional and semantic data models for analytics. Define and maintain KPIs, conformed dimensions and consistent data definitions. Develop and optimise SQL and PySpark pipelines using ...

leadership experience working with a modern cloud data platform (must have some direct Snowflake exposure to be able to hit the ground running) Dbt modelling experience, or the demonstrable capability and willingness to own that learning quickly, alongside a commitment to continuous professional development Advanced SQL, including complex transformation … logic, data modelling and query performance optimisation Strong dimensional modelling knowledge: facts, dimensions, conformed dimensions and slowly changing dimensions Hands‐on engineering credibility, with the judgement to know when to build, when to simplify, and when to stop Proven people leadership: setting direction, giving feedback, and developing ...

leadership experience working with a modern cloud data platform (must have some direct Snowflake exposure to be able to hit the ground running) Dbt modelling experience, or the demonstrable capability and willingness to own that learning quickly, alongside a commitment to continuous professional development Advanced SQL, including complex transformation … logic, data modelling and query performance optimisation Strong dimensional modelling knowledge: facts, dimensions, conformed dimensions and slowly changing dimensions Hands-on engineering credibility, with the judgement to know when to build, when to simplify, and when to stop Proven people leadership: setting direction, giving feedback, and developing ...

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

Product at Legora you will turn data into decisions. You'll sit close to the business, taking questions end-to-end: shaping the metric, modelling the data in dbt, running the analysis, and making the recommendation. You'll pull in new data sources when you need to. Insights … help define what that looks like in practice. There's no single profile we hire for. Some of us are strongest at data modelling and analytics engineering, some at experimentation and causal inference, some at machine learning, some at stakeholder influence. You'll likely be excellent ...

cloud-based data platforms. Advanced SQL skills and experience building transformation pipelines. Strong Python capability for orchestration, automation, and data tooling. Excellent understanding of dimensional modelling and scalable data architecture. Experience working with cloud technologies such as Azure, AWS, or GCP. Knowledge of CI/CD practices ...

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

Understanding of data management standards, regulatory compliance including GDPR and HIPAA, and security protocols Deep knowledge of entity-relationship modeling, normalization and denormalization, and dimensional modeling Proficiency with data modeling tools such as erwin Data Modeler, SAP PowerDesigner, or ER/Studio Advanced SQL skills, including ...

ability to explain complex topics in an easy‐to‐understand manner for both technical and non‐technical audiences. Experience of querying data warehouse dimensional models is advantageous. Familiarity with Azure data technologies, version control and CI/CD tooling (e.g. Azure DevOps, Git) for managing report and pipeline assets ...

will thrive within our recognition and empowerment culture. To be successful in this role, you'll bring strong commercial experience of data warehousing, data modelling and data engineering , ideally including experience administering and working within Snowflake . You'll have strong SQL skills and experience of dbt , building data … models and flows using dimensional modelling techniques, and developing and maintaining data pipelines across multiple data sources. You’ll also be comfortable working with BI and analytics tools such as Power BI , with the ability to take complex data and translate it into clear, actionable insights for both ...

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

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. The successful candidate Proven experience designing enterprise-scale information architectures (multi-source, multi-domain at scale) that successfully went ...

learning and AI to accelerate change across our industry. This role is an opportunity to apply and develop your expertise in analytics engineering, data modelling and visualisation to build, extend and maintain the analytics and reporting capabilities that are central to decision making across Canopius. You will contribute … reliable and aligned to approved sources. Document solutions clearly, including data sources, logic, refresh schedules, access requirements and support considerations. Follow team standards for modelling conventions, naming, testing, deployment and version control, contributing suggestions for improvement where appropriate. Support the rationalisation and redevelopment of legacy reporting solutions as part ...

optimised analytical datasets. Own data model delivery for the domain area, ensuring documentation and data definitions are accurate and accessible. Colleague Champion 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. … about you What we’re looking for: Skills, Qualifications and Experience As 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 ...

analytics solutions Extensive experience with: Azure SQL Azure Data Factory Power BI Azure DevOps Experience delivering greenfield data platform implementations Strong understanding of dimensional modelling and modern data warehouse design Experience developing scalable, secure and maintainable cloud architectures Expertise establishing CI/CD and DevOps practices for data ...

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

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

pipelines in Azure Data Factory, Databricks, Synapse Integrate multi-format sources including Primavera P6 XER, cost/risk registers, CEMAR extracts, and Excel Develop dimensional models for reporting across project controls domains Build Power BI reporting datasets with lineage, validation, and exception checks Work with planners, commercial teams ...

.data architecture and creating data models and documentation.data monitoring, testing, and implementing quality improvements.SQL and technical database experience using relational databases and/or dimensional modellingusing CI/CD techniques and processes DevOps/Git repository code promotion and change management experience.Proven proficiency in relevant technology, Microsoft Azure certification ...

.data architecture and creating data models and documentation.data monitoring, testing, and implementing quality improvements.SQL and technical database experience using relational databases and/or dimensional modellingusing CI/CD techniques and processes DevOps/Git repository code promotion and change management experience.Proven proficiency in relevant technology, Microsoft Azure certification ...

reports/dashboards within the organisation with the goal of providing robust analytical solutions that support the strategic aims Gathering, inspecting, cleaning, transforming and modelling data with the goal of discovering useful information, suggesting conclusions, and supporting decision-making Capturing data requirements to design, extend or maintain, logical … advice, product information and 1st line support for the BI user community What we are looking for: Strong, demonstrable Power BI development skill: data modelling, advanced DAX (filter context, time intelligence, performance), Power Query, and report design Experience with composite models and shared/enterprise datasets (DirectQuery to Analysis ...

testing to ensure analytics outputs are accurate and reliable Document data sources, logic, refresh schedules, access requirements and support considerations Follow standards for modelling, naming, testing, deployment and version control Support rationalisation and redevelopment of legacy reporting solutions for migration onto modern platforms Communicate analytics outputs, assumptions, risks … Hands-on development experience with Power BI, including DAX, tabular/semantic models and paginated reports Good understanding of analytics engineering principles, semantic/dimensional modelling and cloud-based data platforms Experience building clear, reliable and user-friendly reports and dashboards that support business decision making Good ...