1 to 25 of 131 Permanent Dimensional Modelling Jobs

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

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

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

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

built on robust, scalable information models that align with enterprise architecture, governance standards and domain ownership principles. You'll 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. What … 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 ...

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

someone with: Substantial experience delivering and supporting production BI and cloud data platforms Strong Microsoft Fabric knowledge and Power BI expertise, including DAX, semantic modelling, security and performance Strong SQL and data-modelling skills, with working knowledge of Python and/or PySpark Experience of data integration, governance … metadata, lineage, definitions and dependencies. Build in logging, alerting, recovery and maintainability, assessing ownership, security, licensing and support before integrating new systems. Power BI modelling and product delivery Develop governed workspaces, apps, reusable semantic models and dashboards, agreeing consistent measures and definitions across directorates. Set dimensional-modelling ...

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

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

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

Expert in ETL development Proficiency in Python/SQL notebooks for incremental and full data loads to serverless architectures Experience with Git and data modelling (preferably dimensional modelling) Strong analytical and problem-solving abilities Proactive, take initiative and ownership Excellent communication and collaboration skills SQL and database ...

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

Have personally built and owned production data pipelines, and can explain the design choices and trade-offs behind them. Bring strong SQL and data modelling, including dimensional modelling and production dbt with tests, version control and CI/CD. Treat data protection as part of engineering, applying ...

pipeline workflows, including unit testing, integration testing, and data quality validation frameworks Proven experience leading technical aspects of data projects Strong data architecture and modelling skills with the ability to design scalable data solutions Deep understanding of data warehouse design principles and methodologies Advanced knowledge of optimisation techniques … Azure data stack Knowledge of workflow orchestration tools like Azure Data Factory or Apache Airflow Experience with containerisation technologies like Docker Proficiency in dimensional modelling techniques Experience with CI/CD pipelines for data solutions Strong communication skills for translating complex technical concepts You may also have some ...

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

Pipelines, SSIS, Notebooks) and data engineering languages (Python, SQL). Proficiency in designing and optimizing modern data architectures, including data lakehouse/cloud patterns, dimensional modeling (star/snowflake schemas), and Power BI analytics (datasets, dashboards, DAX, M). Familiarity with Software Development Lifecycle, DevOps practices (Git-based source ...

Pipelines, SSIS, Notebooks) and data engineering languages (Python, SQL). Proficiency in designing and optimizing modern data architectures, including data lakehouse/cloud patterns, dimensional modeling (star/snowflake schemas), and Power BI analytics (datasets, dashboards, DAX, M). Familiarity with Software Development Lifecycle, DevOps practices (Git-based source ...

CD. Strong programming experience in Python, with knowledge of other programming languages beneficial. Experience with both synchronous and asynchronous interface approaches. Knowledge of data modelling, including 3NF, dimensional modelling and Data Vault 2.0. Experience working within Agile delivery environments. Ability to produce comprehensive technical documentation. Ability … success. Power BI experience is desirable. The role requires experience across the following skill areas: Data Engineering Software Design Analytics Data Management Data Modelling and Design Data Visualisation Database Design Release and Deployment Nice to Have Experience integrating and implementing data cataloguing tools such as Azure Purview/Collibra. ...