1 to 25 of 39 Dimensional Modelling Jobs

Engineer, you will be responsible for transforming raw data into well modelled, business ready data marts and semantic layers. You will take ownership of dimensional modelling, dbt transformations, and core metrics that power BI tools used across the business. This role blends hands on technical delivery with technical … managing 2 to 3 Analytics Engineers while working closely with senior data leaders and stakeholders on multi market initiatives. Key Responsibilities * Design and own dimensional data models using Kimball methodology* Build and maintain dbt pipelines from raw to gold layer marts* Define and enforce modelling, testing, and documentation ...

control and code deployment. Pipeline Orchestration: Architect reliable data workflows (using platform-native schedulers) to manage complex dependencies and ensure timely data delivery. Data Modelling & Quality Semantic Layer Design: Partner with the Business Systems team to design optimised data models, ensuring seamless integration with downstream BI tools. Business Logic … comfortable building from the ground up using modern cloud-native technologies. Core Languages: Strong proficiency in SQL for complex querying and data modelling, and strong proficiency in Python for scripting, API integration, and data automation. Cloud Data Platforms: Proven experience architecting and managing modern Cloud Data Warehouses (e.g. Snowflake ...

would be a bonus! Key outputs for the role• Design, build, and maintain scalable and trustworthy data models in dbt, making use of Kimball Dimensional and One Big Table (OBT) methodologies.• Translate business requirements from stakeholders into robust, well-documented and tested dbt models.• Develop and own workflows within … performant dbt models that serve as a single source of truth for business reporting.• Implement and champion data quality testing, documentation standards, and modelling best practices within dbt projects.• Troubleshoot and resolve any issues or errors in the data pipelines.• Stay updated with the latest cloud technologies and industry ...

automate testing, version control and code deployment. Pipeline Orchestration: Architect reliable data workflows to manage complex dependencies and ensure timely data delivery. Data Modelling & Quality Semantic Layer Design: Partner with the Business Systems Team to design optimised data models, ensuring seamless integration with downstream BI tools. Business Logic Standardisation … writing complex, optimised queries for data manipulation and analysis. Python Proficiency: Strong functional programming skills in Python for building pipelines and automating tasks. Data Modelling: Deep understanding of dimensional modelling concepts and modern data warehouse design patterns. Modern Data Platform Experience Platform Architecture: Strong understanding of cloud ...

Server, SSIS, SSAS, SSRS) Hands-on experience building and maintaining data pipelines and integrations (ETL/ELT) Solid understanding of data warehousing concepts, dimensional modelling, and data normalisation Experience with data manipulation languages such as T-SQL and DAX Experience working in an Agile environment (ideally Kanban) Strong ...

Server, SSIS, SSAS, SSRS) Hands-on experience building and maintaining data pipelines and integrations (ETL/ELT) Solid understanding of data warehousing concepts, dimensional modelling, and data normalisation Experience with data manipulation languages such as T-SQL and DAX Experience working in an Agile environment (ideally Kanban) Strong ...

spreadsheets and legacy tools. Collaborate with stakeholders to define reporting needs, translating complex requirements into actionable technical specifications. Provide expert guidance on data architecture, modelling, and analytics approaches. Contribute to policies on data governance and promote best practices across the organisation. Mentor junior BI developers and train stakeholders … Power BI for data visualisation and reporting. Hands-on experience with Azure services (Azure Data Factory, Azure SQL Server). Strong understanding of dimensional modelling (e.g., Kimball methodology). Proficiency in sourcing, manipulating, and interpreting complex datasets. Strong analytical mindset with excellent attention to detail and accuracy. Experience ...

Power BI sitting on top of a fully curated Gold Layer. They develop everything using PBIP + Git + Tabular Editor 3 , and semantic modelling is treated as a first-class engineering discipline. This is your chance to own the creation of high-quality datasets and dashboards used across … every day. Why This Role Exists To turn clean, curated Gold Lakehouse data into trusted, enterprise-grade Power BI insights.You'll own semantic modelling, dataset optimisation, governance and best-practice delivery across a modern BI ecosystem. What You'll Do Semantic Modelling with PBIP + Git Build ...

SharePoint and SFTP using ADF + metadata-driven frameworks . Apply Lakeflow expectations for data quality, schema validation and operational reliability. Curated Data Layers & Modelling Build clean, conformed Silver/Gold models aligned to enterprise business domains (customers, subscriptions, deliveries, finance, credit, logistics, operations). Deliver star schemas, harmonisation … + Databricks . Strong PySpark/Spark SQL and distributed data processing expertise. Proven Medallion/Lakehouse delivery experience using Delta Lake . Solid dimensional modelling (Kimball) including surrogate keys, SCD types 1/2, and merge strategies. Operational experience-SLAs, observability, idempotent pipelines, reprocessing, backfills. Mindset Strong ...

queries, joins, aggregations, and optimization. Python proficiency for data manipulation and automation. Power BI or Tableau experience including dashboard development. Data modeling experience including dimensional modeling and star schema. ETL and data transformation experience. Stakeholder management skills. Problem-solving mindset with ability to work independently. Strong attention to detail ...

Power BI sitting on top of a fully curated Gold Layer. They develop everything using PBIP + Git + Tabular Editor 3 , and semantic modelling is treated as a first-class engineering discipline. This is your chance to own the creation of high-quality datasets and dashboards used across … every day. Why This Role Exists To turn clean, curated Gold Lakehouse data into trusted, enterprise-grade Power BI insights.You'll own semantic modelling, dataset optimisation, governance and best-practice delivery across a modern BI ecosystem. What You'll Do Semantic Modelling with PBIP + Git Build ...

design, build, and maintain scalable data pipelines using Azure Data Factory and Databricks to automate data ingestion, transformation, and processing workflows. Create and maintain dimensional data models and semantic layers that support business intelligence and analytics use cases. Build and optimise data transformation workflows using dbt, SQL, and Python … modern data transformation tools ( dbt strongly preferred), with experience in cloud data platforms ( Azure Databricks ) Proven experience designing and implementing scalable data architectures, including dimensional modelling, data lakehouse/warehouse concepts, and modern data stack technologies. Strong software engineering practices including version control (Git), CI/CD pipelines ...

quality, and availability across core data assets. Data Platforms, Governance & Maturity Develop and maintain enterprise data models, including master data management (MDM) and core dimensional models. Establish and embed data governance frameworks covering data quality, security, access, and regulatory compliance. Support the introduction of data standards, cataloguing, and best ...

senior decision-makers through clear data storytelling, visual narratives, and strategic insight. Act as a subject matter expert in Power BI, including DAX, data modelling, and visualisation best practices. Build strong, trusted relationships with cross-functional teams to ensure BI outputs align with business objectives. Contribute to the continuous … improvement of BI standards, governance, tools, and ways of working. Required Experience: Expert-level proficiency in Power BI, including DAX, data modelling, and advanced visualisation techniques. Strong communication and stakeholder management skills, with the ability to influence at all organisational levels. Demonstrated experience mentoring or upskilling others ...

such as Data Factory, Synapse and Azure SQL Experience using Databricks and Python in data processing workflows Strong SQL skills and practical knowledge of dimensional modelling and warehouse design Familiarity with CI/CD approaches for data and analytics solutions Confident communicator with the ability to work across ...

such as Data Factory, Synapse and Azure SQL Experience using Databricks and Python in data processing workflows Strong SQL skills and practical knowledge of dimensional modelling and warehouse design Familiarity with CI/CD approaches for data and analytics solutions Confident communicator with the ability to work across ...

dashboards (DAX, Power Query, RLS, performance). Advanced Excel: advanced formulas, Pivot tables, Power Pivot. ETL/ELT tooling (SSIS/Power Query) and dimensional modelling (Star Schema). Practical AI/ML exposure (e.g., Python notebooks, Azure ML, or equivalent) and the ability to operationalise models responsibly ...

hands-on experience with SSIS and SQL Server. Proven ability to deliver reliable, scalable data warehouse solutions. Strong understanding of data modeling principles, including dimensional modeling and slowly changing dimensions. Experience in ETL/ELT design and development. Familiarity with data quality and profiling techniques. Background in building ...

Duration: FTC Mode of Work: Hybrid Job Spec: Design and own enterprise-level data architecture including data lakes, warehouses, and lakehouse platforms. Define data modelling standards (conceptual, logical, physical; dimensional modelling; canonical models). Lead cloud data platform design using Azure/AWS/GCP services, including ...

business goals Design logical and physical data models optimised for reporting, analytics, and self-service BI Establish and govern architectural patterns (e.g. medallion architecture, dimensional modelling, data vault) Design cloud-based data platform architectures (AWS preferred), including data storage, processing, and consumption layers Technology Leadership Evaluate and recommend … cloud-native services Lead proofs-of-concept and technical assessments for new technologies Ensure the data architecture remains modern, performant, and future-proof Data Modelling & Governance Define standard business entities, metrics, and KPIs for consistent reporting Review and approve complex data models created by BI Engineers Design and embed ...

responsibilities: Design, build and maintain data pipelines using Azure Data Factory and Azure Databricks Develop and optimise PySpark and SQL transformations Model data using dimensional modelling principles Support ingestion of data from various data sources and formats Collaborate with BI developers, analysts and business stakeholders to understand data ...

with business stakeholders and technical teams. Key Responsibilities Administer and optimise Microsoft SQL Server environments, including performance tuning & security Own Data Warehouse operations, including dimensional modelling, indexing, and optimisation for large datasets. Design and maintain ETL/ELT pipelines with strong data quality controls. Develop and govern Power ...

Desirable Familiarity with Tableau or similar BI tools. Awareness of NHS datasets and reporting requirements (e.g. MHSDS, RTT). Understanding of Kimball or other dimensional modelling techniques. Knowledge of Agile development methodology. Skills Essential Excellent interpersonal and communication skills Ability to work on own initiative and deliver objectives ...

years of experience of SSIS and SQL Server Database. Proven track record in delivering scalable and reliable Data Warehouse solutions. Strong data modeling and dimensional modeling skills (including slowly changing dimensions). Experience with data quality and data profiling. ETL/ELT design and development experience. Experienced in designing ...

technical concepts clearly to non-technical audiences Act as a positive, approachable technical lead and support other team members Maintain robust data dictionaries and dimensional data models Apply strong analytical thinking and stay up to date with existing and emerging technologies Demonstrate expertise in SQL, data warehousing, dimensional modelling, Databricks, Data Lakes, and knowledge of CDL Kingfisher, Classic data, OGI, and main PAS data sources Skills, Experience & Knowledge: Development experience in SQL programming and systems integration Strong knowledge of SQL, data modelling, data warehousing concepts, and Kimball methodology Experience within Insurance or Broking (preferred) Proven ...