1 to 25 of 127 Permanent Dimensional Modelling Jobs in the UK

pipelines, ensuring seamless integration and transformation of data from various sources to deliver clean, reliable data. Develop and maintain sophisticated data models, employing dimensional modelling techniques to support comprehensive data analysis and reporting. Implement and uphold best practices in data governance, security, and compliance, using tools like Azure … retrieval. Experience in Power BI Dashboard Development: You possess experience in creating insightful and interactive Power BI dashboards that drive business decisions. Proficiency in Dimensional Modelling: You are adept at applying dimensional modelling techniques, creating efficient and effective data models tailored to business needs. CI/ ...

have experience of providing data modelling expertise, including defining data modelling frameworks and embedding modelling processes, on a complex data improvement project within a financial services environment? This consulting opportunity is to support our client, a leading Wealth and Asset Management organisation, in developing and maintaining scalable … models that support enterprise data platforms, reporting, analytics and data products. The project needs a consultant who has: strong conceptual, logical and physical data modelling expertise experience of 3NF and dimensional modelling expertise in data warehouse, data mart, master and reference data modelling strong SQL, data ...

domain teams can self serve across batch, streaming, and real time workloads. • Set cross domain data standards Define and enforce enterprise standards for data modelling, schema evolution, quality, lineage, security, and metadata to ensure data products are consistent and interoperable across domains. • Enable and unblock domain teams Provide templates … with schema management, data governance, and cost optimization in cloud data environments • Hands-on experience migrating legacy systems to modern cloud platforms Data Architecture & Modelling • Strong grasp of conceptual, logical, and physical data modelling (ER modelling, dimensional modelling, star schema) • Familiarity with data modelling ...

Senior Data Engineer (Data Modelling)****UK Remote-First** (occasional travel to parks, head office and team events)**Permanent | Full Time****Competitive salary + bonus and benefits****About the role**Do you think in facts and dimensions? Are you the kind of engineer who gets a genuine kick … forecast and guest insight sits a data model that someone thought carefully about. That someone could be you. As a **Senior Data Engineer Data Modelling)**, you'll be a specialist at the heart of our data engineering community, focused squarely on the craft of dimensional modelling ...

Senior Data Engineer (Data Modelling) UK Remote-First (occasional travel to parks, head office and team events). Permanent | Full Time. Competitive salary + bonus and benefits. About the role Do you think in facts and dimensions? Are you the kind of engineer who gets a genuine kick … forecast and guest insight sits a data model that someone thought carefully about. That someone could be you. As a Senior Data Engineer (Data Modelling), you'll be a specialist at the heart of our data engineering community, focused squarely on the craft of dimensional modelling ...

help turn a growing analytics estate into a clear, governed and scalable foundation for better decisions, better products and trustworthy AI-powered experiences. Data modelling is at the heart of this role. You’ll shape the layered warehouse model, define the grains and conformed dimensions, and design the semantic … models that other people can confidently build on. What you’ll be doing Own the analytics data architecture end to end, including layers, modelling conventions, data contracts and the governed semantic layer. Build the foundational curated layer yourself, creating dimensional models with clear grain, conformed dimensions ...

cases. Business Intelligence and broader Analytics capabilities are managed by separate teams. Key Accountabilities Data Engineering and Analytics Engineering Oversee reliable ingestion, transformation, orchestration, modelling and lifecycle management across the data platform. Implement a medallion architecture that supports trusted, reusable and well-governed data assets. Establish effective engineering practices … version control, automated testing, deployment and operational support. Lead analytics engineering practices, including dimensional modelling, semantic modelling, shared metrics and curated business-facing data products, partnering with consuming teams to ensure platform outputs are usable, dependable and aligned to agreed requirements. Lead, coach and develop a cross ...

analytics platform. This is a hands‐on, high‐impact role suited to someone who enjoys greenfield analytics work, has strong opinions on data modelling and architecture, and partners closely with stakeholders to translate business problems into trusted, well‐governed data products. You will work within the PlayStation Partners Platform … decision‐making, improve operational efficiency, and uncover revenue opportunities. In this role, you will help shape how analytics is delivered across the organisation, from modelling standards and dbt best practices to the creation of trusted, decision‐ready datasets. What You Will Be DoingAnalytics Engineering and Data ModellingDesign, build ...

This is an opportunity to influence not only what we build, but how we engineer--establishing better approaches to architecture, ingestion, orchestration, transformation, data modelling, testing, deployment, monitoring, automation and reuse.Working closely with Data Engineers, Data Scientists and analysts, you will see how engineering decisions affect analytical delivery … building and operating complex data platforms, pipelines and analytical data models at scale.You will understand the complete data lifecyclefrom ingestion and orchestration through transformation, modelling, validation, deployment, monitoring and optimisationand be able to determine the appropriate engineering approach for complex analytical requirements. You will combine engineering expertise with strategic ...

products are built on robust, scalable information models that align with enterprise architecture, governance standards and domain ownership principles. Youll also provide guidance on modelling best practices, data standards and business terminology, helping establish a consistent and trusted data foundation that supports both operational decision-making and strategic insight. … Data Engineers to validate models against ingestion pipelines and sample data Providing high-quality model documentation to support downstream development and analytics Maintaining data modelling standards and best practices across squads Applying change management principles to ensure consistency and traceability of model changes Supporting governance and metadata management using ...

Public Services. Job Title/Role: Lead Analytics Engineer Mandatory Required Skills Expert Snowflake knowledge and advanced dbt (Core/Cloud) experience. Modelling Concepts: Semantic Modelling, Dimensional Modelling (Kimball), Business/Logical/Physical Modelling. Skills: Software engineering mindset applied to SQL; git workflows, and automated … controls (ABAC), and query performance tuning. Technical Requirements Core Platforms: Expert Snowflake knowledge and advanced dbt (Core/Cloud) experience. Modeling Concepts: Semantic Modeling, Dimensional Modeling (Kimball), Business/Logical/Physical Modelling. Skills: Software engineering mindset applied to SQL; git workflows, and automated testing. #J-18808-Ljbffr ...

cases. In this D&A architecture role, you will define shared information models, create conceptual and logical designs, establish naming and modelling standards, and create information blueprints that engineering teams can implement. Working across commerce, manufacturing and supply chain operations spanning clusters and markets, you will make data easier … products, customers, suppliers and stores, establishing authoritative sources and harmonisation patterns across systems together with master data responsible teams. Establish information quality measures, modelling standards and metadata expectations embedded in architectural patterns: operational schemas in bronze, conformed and dimensional entities in silver, and consumption-ready models in gold. ...

data sync between our ERP and the wider estate. Our stack is Python, PySpark, Delta Lake and Databricks, with T‐SQL, Kimball dimensional modelling and Power BI on top, working closely with Microsoft Dynamics 365 Finance and Operations data structures. We are currently reviewing whether to move from … reconciliations and platform work, and pick up the hardest builds yourself. Owning the Data Warehouse and Data Sync Own our data warehouse, including the dimensional model, the pipelines that load it and the standards that keep it consistent as it grows. Own the data sync between ...

need to arrive doing all three confidently - you need to be strong in analysis and reporting today, and genuinely keen to develop into the modelling and engineering side with support from the team. You will be part of the bridge between our small data team and the rest … will report to the BI Lead and work closely with our Data Engineer, who you'll pair with regularly as you build up the modelling and engineering side of the role. The team is small and deliberately focused - we aim to do fewer things better, rather than spread thin ...

Storage, Pub/Sub, Datastream and Cloud Composer/Airflow, alongside Terraform and infrastructure-as-code. Set and champion high engineering standards across data modelling, dbt (data build tool) transformations, testing, monitoring, documentation, deployment, version control and cost optimisation. Partner with teams across the firm to turn business needs …/Cloud Composer, dbt, Git/GitHub, CI/CD and Terraform or other infrastructure‐as‐code tooling . A solid understanding of data modelling, dimensional modelling, orchestration, testing, data quality and operational monitoring , with a focus on building solutions that are scalable and maintainable. Experience designing ...

Storage, Pub/Sub, Datastream and Cloud Composer/Airflow, alongside Terraform and infrastructure-as-code. Set and champion high engineering standards across data modelling, dbt (data build tool) transformations, testing, monitoring, documentation, deployment, version control and cost optimisation. Partner with teams across the firm to turn business needs …/Cloud Composer, dbt, Git/GitHub, CI/CD and Terraform or other infrastructure-as-code tooling . A solid understanding of data modelling, dimensional modelling, orchestration, testing, data quality and operational monitoring , with a focus on building solutions that are scalable and maintainable. Experience designing ...

behind every report and every operational data feed at ECP, continue the migration of our data warehouse and data lake to a modern dimensional model, finish the rollout of a principle-of-least-privilege security model across a multi-server SQL estate, and continue the migration of our reporting … will include: Setting and personally delivering target architecture for the ECP data estate the data warehouse, data hub, data lake, raw/ODS layers, dimensional model, audit and schema-change tracking, and the load schedules that tie them together. Hands-on T-SQL, stored procedure, ETL framework and PowerShell ...

behind every report and every operational data feed at ECP, continue the migration of our data warehouse and data lake to a modern dimensional model, finish the rollout of a principle-of-least-privilege security model across a multi-server SQL estate, and continue the migration of our reporting … will include: · Setting and personally delivering target architecture for the ECP data estate — the data warehouse, data hub, data lake, raw/ODS layers, dimensional model, audit and schema-change tracking, and the load schedules that tie them together. · Hands-on T-SQL, stored procedure, ETL framework and PowerShell ...

. Hands‐on experience building or scaling an experimentation programme, with solid statistics: power analysis, variance reduction, sequential testing, and common pitfalls. Strong data modelling: dimensional modelling, SCDs, event schema design, dbt, and SQL at a high level. A track record of driving change: introducing new practices … getting non-technical teams to adopt them. Clear communication with executives and with non-technical stakeholders. Nice to have Data science and predictive modelling, including forecasting. Experience building an AI‐first data stack and taking an AI‐first approach to analytical problems. Data governance frameworks, marketing analytics and attribution. ...

visualizations in Qlik Strong knowledge of data visualization best practices using Qlik Experience working with a relational database (SQL, Oracle, etc.) a plus Data modelling, dimensional modelling, and working with large datasets a plus Experience working with business teams to translate functional requirements into technical requirements Additional ...

inform future platform decisions. Work with the Data and Insights Manager and wider team to provide clear recommendations based on pilot outcomes. Data Transformation & Modelling Develop transformation logic that cleanses, validates and enriches data for operational and analytical use. Create and maintain reusable data sets and semantic models that … support reporting and insight requirements. Apply good-practice data modelling techniques, including dimensional modelling and star schema design where appropriate. Work with business users to understand data requirements and translate them into scalable technical solutions. Data Migration & System Implementation Support system implementation and data migration projects through ...

grow is by doing, so we give you the ownership to run with things and see real-time results. Owns the data modelling strategy, sets standards for data modelling, transformations, and governance. Leads the design and implementation of new features, such as the creation of a new star …/or other languages relevant to data processing Extensive experience in dbt and ideally Airflow (or other orchestration tools) Extensive experience in Entity-Relationship modelling and Dimensional modelling Experience with Cloud Data Warehousing (eg Snowflake, Databricks or BigQuery) and Cloud (AWS, GCP or Azure) Familiarity with Tableau ...

about creating reliable, scalable foundations that help organisations make better decisions and deliver better services. You’ll tackle complex engineering challenges across integration, migration, modelling and platform design, working with Microsoft Fabric, Azure and modern data technologies. We value engineering craft, thoughtful problem-solving and building solutions that … following areas is important: Microsoft Fabric and Azure data services, includinglakehouse, warehouse,notebooksand pipeline capabilities. Building enterprise-scale data platforms,lakehousesand data warehouses. Data modelling and dimensional modelling techniques such as Kimball. ETL/ELT development and large-scale data integration. PySpark, Spark SQL and modern transformation ...

data architecture experience, including at least three years delivering Power BI at enterprise scale. Expert knowledge of Power BI, DAX, Power Query (M), semantic modelling and dimensional modelling, supported by strong SQL capability. Hands‐on experience with Power BI Service, Premium or Microsoft Fabric capacity, gateways, deployment ...

Proficiencyin programming languages such asPythonandSQL fordata processing and transformation. Experience designing and implementingETL/ELT pipelines, data integration patterns, and workflow orchestration. Understanding ofdata modelling concepts(dimensional modelling, data vault, normalized schemas) and when to apply them. Knowledge ofdata governance, data quality, and metadata managementprinciples. Experience withInfrastructure ...