26 to 46 of 46 Dimensional Modelling Jobs

trusted datasets for analytics and business intelligence Implement data quality tests and monitoring to ensure accuracy and reliability Optimise query performance using effective data modelling and materialisation strategies Establish and maintain documentation and data dictionaries for analytical models, KPI definitions and metrics frameworks Conduct exploratory data analysis to identify … Strong SQL skills with experience in complex data transformations, CTEs and window functions Expertise with dbt and modern analytics engineering tools Solid understanding of dimensional modelling and data warehousing concepts Experience with Git-based workflows for version control and collaboration for analytics Knowledge of data testing frameworks ...

making across the business. As a senior member of the BI team, you will help develop scalable reporting solutions, promote best practice in data modelling and visualisation, and support the continued adoption of self-service analytics. Key Responsibilities Design, develop and maintain enterprise-grade Power BI dashboards, reports … semantic models Build and optimise data models using best-practice dimensional modelling techniques Develop advanced DAX measures and calculations to support complex analytical requirements Create intuitive and visually engaging dashboards that allow stakeholders to explore and interpret data effectively Optimise report and dataset performance to ensure scalable ...

Desktop, Power Query (M), DAX, and Power BI Service. Solid SQL skills (joins, CTEs, window functions) and experience with SQL Server. Strong understanding of dimensional modelling and data warehouse principles. Experience building and maintaining ETL pipelines. Excellent analytical, problem solving, and troubleshooting skills. Strong communication skills, able ...

Advanced command of SQL/T-SQL (Complex queries, Window Functions, Performance Tuning, and Relational Modeling). Data Warehousing Foundations: Solid understanding of dimensional modeling (Star/Snowflake schemas, Surrogate Keys, and Slowly Changing Dimensions - SCD). ETL Tooling: Hands-on experience with SSIS (SQL Server Integration Services ...

Required 8+ years of professional experience in data engineering, including 5+ years of people management and technical leadership experience. Deep understanding of Ralph Kimball dimensional modelling best practices, including star schema design and data cube modelling to support scalable analytics and reporting. Experience building and optimising cloud ...

Essentials Pipeline Tech: 5+ years of experience with Kafka, Spark, Hadoop, and DBT . Modern Modeling: Expert skills in Data Vault Mandatory and Dimensional modeling. Cloud & DevOps: Strong AWS experience with a focus on CI/CD and writing secure code. Data Governance: Proven ability to embed quality, lineage ...

looking for an experienced Data Design Analyst/Data Modeler with 6 8 years of experience to take end-to-end ownership of data modelling for data migrated from Oracle to Azure Microsoft Fabric. Key Responsibilities Design and implement conceptual, logical, and physical data models in Azure MS Fabric. … Lead data modelling activities for Oracle-to-Azure migration initiatives. Define and optimize Medallion Architecture layers (Bronze, Silver, Gold). Translate business and analytical requirements into robust data structures. Ensure data integrity, performance, scalability, and compliance with governance standards. Collaborate with data engineers, architects, and business stakeholders. Data Analysis ...

robust data platform from ingestion through to consumption. Tech Environment: Azure Data Lake Storage Azure Synapse Medallion Architecture ETL/data ingestion pipelines Dimensional modelling Strong governance, security, and error handling Ideal Experience: Azure-based data platform architecture End-to-end data warehouse design and delivery Data governance ...

distributed environments and values technical excellence through CI/CD and Agile. The Essentials Modern Modeling: Expert skills in Data Vault Mandatory and Dimensional modeling. Cloud & DevOps: Strong AWS experience with a focus on CI/CD and writing secure code. Data Governance: Proven ability to embed quality, lineage ...

design, deployment, and maintenance process is followed. Experience in Agile delivery methodology in a data and analytics context Deep understanding of data warehouse processes, dimensional modeling and ETL/Integration Knowledge of industry standard Business Intelligence (BI) tools, such as: Oracle (OBIEE), Business Objects, etc. Experience with statistical programming ...

four domains (Customers, Applications, Assessments, Cases), aligning with the DSFS data model and existing Netezza structures. Produce the EDW logical and physical data models, dimensional models for the Semantic Layer, and Data Lake zone architecture (Bronze/Silver/Gold). Define Enterprise Semantic Layer design, including pre-computed … aggregations, dimensional models, and Tableau connectivity specifications. Lead source system profiling (D02), producing profile reports for each system in the seven-system scope. Ensure data model designs meet NFRs: 200 concurrent users, 1-hour maximum response time, and 99.5% availability. Provide architectural guidance to the Data Architect and Lakehouse ...

Office) Salary: Up to £90,000 This is an exciting opportunity to join a high-growth consultancy environment where you will shape data modelling standards, influence enterprise-level design, and work directly with senior stakeholders across complex financial services programmes. If you enjoy combining hands-on modelling with … strong footprint across financial services and energy. Their data capability exceeds 300 specialists, and their Data Architecture function is known for delivering high-quality modelling, strategy and metadata solutions across large-scale transformation programmes. They operate in a collaborative, low-ego environment where expertise is valued and career progression ...

escalation point for advanced BI issues. Key Responsibilities: Develop and maintain enterprise-grade Power BI reports, datasets, and data models (including star schemas and dimensional models). Lead ETL/ELT design and optimisation within Microsoft Fabric Lakehouse, including Data Pipelines, Notebooks, and cloud-based ingestion/transformation layers. … standards are met. Collaborate with global teams on BI modernisation initiatives, ERP data projects, and multi-region rollouts. Skills & Experience Power BI (DAX, data modelling, composite models, dataset optimisation). Strong capability in Microsoft Fabric, including Lakehouse architecture, Data Pipelines, and Notebooks. Advanced SQL, T-SQL optimisation, Python ...

escalation point for advanced BI issues. Key Responsibilities: Develop and maintain enterprise-grade Power BI reports, datasets, and data models (including star schemas and dimensional models). Lead ETL/ELT design and optimisation within Microsoft Fabric Lakehouse, including Data Pipelines, Notebooks, and cloud-based ingestion/transformation layers. … standards are met. Collaborate with global teams on BI modernisation initiatives, ERP data projects, and multi-region rollouts. Skills & Experience Power BI (DAX, data modelling, composite models, dataset optimisation). Strong capability in Microsoft Fabric, including Lakehouse architecture, Data Pipelines, and Notebooks. Advanced SQL, T-SQL optimisation, Python ...

escalation point for advanced BI issues. Key Responsibilities: Develop and maintain enterprise-grade Power BI reports, datasets, and data models (including star schemas and dimensional models). Lead ETL/ELT design and optimisation within Microsoft Fabric Lakehouse, including Data Pipelines, Notebooks, and cloud-based ingestion/transformation layers. … standards are met. Collaborate with global teams on BI modernisation initiatives, ERP data projects, and multi-region rollouts. Skills & Experience Power BI (DAX, data modelling, composite models, dataset optimisation). Strong capability in Microsoft Fabric, including Lakehouse architecture, Data Pipelines, and Notebooks. Advanced SQL, T-SQL optimisation, Python ...

escalation point for advanced BI issues. Key Responsibilities: Develop and maintain enterprise-grade Power BI reports, datasets, and data models (including star schemas and dimensional models). Lead ETL/ELT design and optimisation within Microsoft Fabric Lakehouse, including Data Pipelines, Notebooks, and cloud-based ingestion/transformation layers. … standards are met. Collaborate with global teams on BI modernisation initiatives, ERP data projects, and multi-region rollouts. Skills & Experience Power BI (DAX, data modelling, composite models, dataset optimisation). Strong capability in Microsoft Fabric, including Lakehouse architecture, Data Pipelines, and Notebooks. Advanced SQL, T-SQL optimisation, Python ...

escalation point for advanced BI issues. Key Responsibilities: Develop and maintain enterprise-grade Power BI reports, datasets, and data models (including star schemas and dimensional models). Lead ETL/ELT design and optimisation within Microsoft Fabric Lakehouse, including Data Pipelines, Notebooks, and cloud-based ingestion/transformation layers. … standards are met. Collaborate with global teams on BI modernisation initiatives, ERP data projects, and multi-region rollouts. Skills & Experience Power BI (DAX, data modelling, composite models, dataset optimisation). Strong capability in Microsoft Fabric, including Lakehouse architecture, Data Pipelines, and Notebooks. Advanced SQL, T-SQL optimisation, Python ...

escalation point for advanced BI issues. Key Responsibilities: Develop and maintain enterprise-grade Power BI reports, datasets, and data models (including star schemas and dimensional models). Lead ETL/ELT design and optimisation within Microsoft Fabric Lakehouse, including Data Pipelines, Notebooks, and cloud-based ingestion/transformation layers. … standards are met. Collaborate with global teams on BI modernisation initiatives, ERP data projects, and multi-region rollouts. Skills & Experience Power BI (DAX, data modelling, composite models, dataset optimisation). Strong capability in Microsoft Fabric, including Lakehouse architecture, Data Pipelines, and Notebooks. Advanced SQL, T-SQL optimisation, Python ...

model redesign, and production cutover. Expert-Level PySpark & Python Skills. Strong ability to design, optimize, and refactor distributed data processing workflows. Advanced SQL & Data Modelling Expertise. Experience in dimensional modeling, lakehouse architecture patterns, and query optimization. Cloud Platform Experience (Azure preferred). Hands-on experience deploying and managing ...

data platform using SQL and Python (PySpark), with a focus on reliability, performance and maintainability. Develop and maintain core data models (curated layers, dimensional models, shared definitions) that enable consistent KPI reporting and analysis. Implement and embed data quality controls (freshness, completeness, accuracy, reconciliation checks) and monitoring so issues … models from "fragile and fragmented" to "trusted, governed and embedded" through practical engineering improvements. Solid experience across the data engineering lifecycle: ingestion, transformation/modelling, and enabling consumption through BI/semantic conventions. Hands-on capability with modern cloud data platforms and tooling, and a clear view of what ...

closely with engineering, data governance, and business teams to ensure data structures are efficient, consistent, and aligned with organizational standards. Data Modeling & Architecture Design dimensional models (fact tables, conformed dimensions, SCD types) and/or 3NF or Data Vault structures appropriate for business and technical requirements. Create and maintain … Clearly communicate model changes, business impacts, and dependencies to technical and non technical stakeholders. YOUR PROFILE Technical Expertise Demonstrated experience in data modeling, including dimensional modeling (star, snowflake), normalization (3NF), and/or Data Vault 2.0. Strong SQL and DDL skills, with the ability to reason about query performance ...