1 to 25 of 37 Dimensional Modelling Jobs in the UK

scale. You will have strong experience in data architecture, ETL development, and modern data warehousing practices, including the application of Kimball methodology and dimensional modelling, alongside a proven track record of building reliable, high-performance data solutions in a business-focused environment. This is a newly created role … transformation logic in a data warehousing environment. Experience designing and maintaining ETL pipelines and data integration processes. Strong experience of Kimball data modelling techniques (e.g. star schema, dimensional modelling). Experience working within a Microsoft data stack (e.g. SQL Server, Azure Data Factory, Azure Synapse, Microsoft Fabric ...

intelligence capability. This is an excellent opportunity for a highly skilled Power BI professional who enjoys working across the full BI lifecycle, from data modelling and dashboard development through to governance, optimisation, and stakeholder engagement. You'll work closely with Data Engineering teams and business leaders to deliver trusted … Responsibilities: Own and develop the organisation's Power BI reporting estate, including dashboards, reports, and semantic models Design and maintain scalable data models using dimensional modelling and star schema best practices Develop advanced DAX calculations and Power Query transformations Optimise report and dataset performance, ensuring reliability and scalability ...

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

processes, partitioning, governance and performance optimisation. Responsibilities: Designing and developing enterprise-grade Power BI reports, dashboards and scorecards. Building and maintaining semantic models using dimensional modelling best practices. Developing advanced DAX calculations, calculation groups and optimisation techniques. Implementing Incremental Refresh and semantic model partitioning strategies. Managing large-scale … Power BI assets. Skills & Experience: Essential Expert Power BI Desktop and Power BI Service experience. Extensive experience developing enterprise semantic models. Advanced DAX, semantic modelling and performance tuning skills. Strong understanding of VertiPaq, composite models, aggregations and query optimisation. Hands-on experience implementing Incremental Refresh and dataset partitioning. Experience ...

processes, partitioning, governance and performance optimisation. Responsibilities: Designing and developing enterprise-grade Power BI reports, dashboards and scorecards. * Building and maintaining semantic models using dimensional modelling best practices. * Developing advanced DAX calculations, calculation groups and optimisation techniques. * Implementing Incremental Refresh and semantic model partitioning strategies. * Managing large-scale … Power BI assets. Skills & Experience: Essential * Expert Power BI Desktop and Power BI Service experience. * Extensive experience developing enterprise semantic models. * Advanced DAX, semantic modelling and performance tuning skills. * Strong understanding of VertiPaq, composite models, aggregations and query optimisation. * Hands-on experience implementing Incremental Refresh and dataset partitioning. * Experience ...

Hands-on experience with Cloud Storage, Dataflow, Dataproc, Pub/Sub, Cloud Composer, BigQuery Transfer Service, Cloud Functions, and Cloud Run, Strong SQL, data modelling, dimensional modelling, and data warehousing expertise, Experience in migrating on-premise or Legacy data platforms to GCP, Knowledge of ETL/ ...

batch processing Desirable Skills Working knowledge of SAS (especially in ETL context) Experience in migrating SAS workloads to Informatica ETLs Familiarity with data modelling (dimensional modelling/star schema) Exposure to scheduling tools (e.g., Control-M, Autosys) Understanding of data governance and data quality frameworks Must have ...

govern solution architectures aligned to business and technical requirements Design scalable cloud data platforms, lakehouse architectures, and analytics ecosystems Lead architecture for data modelling, warehousing, and ETL/ELT pipelines Design and oversee BI and semantic layer architecture (Power BI and similar tools) Define standards for data governance, security … background in enterprise data platform and analytics architecture Extensive experience with Azure data ecosystem (Fabric, Databricks, Synapse, Azure Data Factory) Strong understanding of data modelling (Kimball, dimensional modelling, lakehouse patterns) Experience designing enterprise ETL/ELT and data integration architectures Strong BI architecture experience (Power BI, Tableau ...

development including query development and optimisation, stored procedures, and performance tuning Expert knowledge of end-to-end enterprise BI using Power BI including semantic modelling, DAX, Power Query, data visualisation best practice, report development, and performance optimisation Advanced data modelling including dimensional modelling, star schema design ...

frameworks and integration patterns Shape architecture decisions across technologies including Microsoft Fabric, Azure Databricks, Azure Synapse Analytics and Azure Data Factory Define data modelling strategies, including dimensional modelling, enterprise data models and lakehouse patterns Establish architectural standards around data governance, security, metadata, lineage and data quality ...

term work supports broader programme and client objectives. About You Professional knowledge and experience Essential Proven experience in data engineering, data integration and data modelling Expertise with cloud platforms (e.g. AWS, Azure, GCP) Expertise with modern cloud data platforms (e.g. Microsoft Fabric, Databricks) Expertise with multiple data analytics tools … e.g. Power BI) Deep understanding of data warehousing concepts, ETL/ELT pipelines and dimensional modelling Proficiency in advanced programming languages (Python/PySpark, SQL) Experience in data pipeline orchestration (e.g. Airflow, Data Factory) Familiarity with DevOps and CI/CD practices (Git, Azure DevOps etc) Ability ...

Overview We are seeking an experienced Data Architect/Data Modelling Consultant with a strong banking and investment management background to lead the design of target-state reporting and analytics data models within a modern cloud-based data platform. The successful candidate will work closely with business and technology … target-state data model as solutions are developed and deployed, rather than undertaking a standalone discovery or design phase. This is primarily a data modelling and consulting-focused role rather than a platform or infrastructure architecture position. Key Responsibilities Analyse existing data models and architectures and define target-state ...

expertise Proven experience designing and implementing data engineering solutions using Microsoft Fabric and Azure . Strong background in ETL/ELT , data warehousing concepts, dimensional modelling and modern data architecture patterns. Hands-on skills across T-SQL , Python , PySpark , and developing robust data processing solutions. Experience optimising performance ...

English communication skills and a proven ability to thrive in a fast-paced, highly collaborative environment. Desirable (Bonus) Skills: Languages: PySQL, C#, R. Reporting & Modelling: Power BI (or similar), SQL Server SSAS Tabular (DAX), Dimensional Modelling, Data Warehousing. Ecosystem & Management: Azure DevOps, SQL MI/DB, Active ...

experience with data orchestration tooling such as dbt or dataform. Platform Specifics: Hands‐on experience with Databricks. Modeling Expertise: Practical knowledge of Kimball’s dimensional modeling. Here at Kaluza we have five core values that guide our business: Play to win, Solve the real problem, Build trust every ...

quality, governance and best practice across the wider business. Ensuring Your Success To succeed in this role, you'll bring strong experience in data modelling, reporting, and analytics, with expert knowledge of SQL, Databricks, Azure Data Factory and Power BI, including DAX and semantic modelling. You'll have … solid understanding of Azure Data Lake architecture, ETL processes, dimensional modelling and modern reporting principles, with the ability to translate complex business requirements into practical, scalable data solutions. Experience with Cognos would be beneficial but isn't essential. You'll be a confident communicator who enjoys collaborating with ...

integrations using Azure Data Factory and Databricks and related services. Develop and maintain datasets and data models that support analytics and reporting, following established modelling standards Contribute to data lineage, metadata management and cataloguing practices, including exposure to Purview Work closely with the Lead Data Engineer, Analysts and Architects … production or near-production environment Practical experience building and maintaining ETL/ELT pipelines in a cloud environment Working knowledge of data modelling concepts including star schema and dimensional modelling Please see full job description attached. What you can expect from us We believe doing your best ...

such as Airflow to schedule, monitor and manage data pipelines Experience working with at least one major cloud data platform, preferably Azure Strong data modelling skills, including relational and dimensional modelling Knowledge of relational database technologies and best practices Proficiency in Python for data engineering, automation ...

logical and physical data models that support efficient reporting, analytics, and self-service BI capabilitiesEstablish architectural patterns and frameworks (e.g. medallion architecture, data vault, dimensional modelling) for consistent implementation across data solutionsEvaluate and recommend architectural approaches for data storage, processing, and consumption, including lakehouse, data warehousing, and data … concept and technical assessments to validate new technologies before adoptionMonitor industry best practices and ensure Arriva's architecture remains competitive and future-proofData Modelling & StandardsDefine and document standard business entities, metrics, and KPIs to ensure consistency across reportingReview and approve complex data models designed by BI Engineers, ensuring alignment ...

physical data models that support efficient reporting, analytics, and self-service BI capabilities* Establish architectural patterns and frameworks (e.g. medallion architecture, data vault, dimensional modelling) for consistent implementation across data solutions* Evaluate and recommend architectural approaches for data storage, processing, and consumption, including lakehouse, data warehousing, and data … technical assessments to validate new technologies before adoption* Monitor industry best practices and ensure Arriva's architecture remains competitive and future-proof## Data Modelling & Standards* Define and document standard business entities, metrics, and KPIs to ensure consistency across reporting* Review and approve complex data models designed by BI Engineers ...

physical data models that support efficient reporting, analytics, and self-service BI capabilities* Establish architectural patterns and frameworks (e.g. medallion architecture, data vault, dimensional modelling) for consistent implementation across data solutions* Evaluate and recommend architectural approaches for data storage, processing, and consumption, including lakehouse, data warehousing, and data … technical assessments to validate new technologies before adoption* Monitor industry best practices and ensure Arriva's architecture remains competitive and future-proof## Data Modelling & Standards* Define and document standard business entities, metrics, and KPIs to ensure consistency across reporting* Review and approve complex data models designed by BI Engineers ...

medallion architecture and Delta Lake Desirable Experience with Azure Synapse Analytics Experience with Azure Data Factory Experience in financial services or regulated environments Dimensional modelling/star schema knowledge Databricks Certification What you'll get in return - Competitive Salary - Great Career Progression - Hybrid Working Policy - 2 days ...

database design. Experience developing ETL/ELT solutions using tools such as SSIS. Experience with Tableau A solid understanding of data warehousing and dimensional modelling. Experience working with large, complex data sets. Desirable: Experience with Power BI dashboards Knowledge of Lakehouse architecture and real-time data solutions. Python ...

year Technical Skills. Expert in Data Bricks, ADF & SQL (SQL queries, SQL Server Integration Services (SSIS) (Stored Procedures Development). Expert in Data Modelling & Data Schema creation including measures, calculations, KPI's & CDE's Working knowledge of Microsoft Power BI Report Builder, PowerBI Working knowledge of tools to help …/SharePoint/One Drive Understanding of database management systems and ETL (Extract, transform, load) framework Understanding of MS Azure data lake design (e.g. dimensional modelling) and data mining Business Skills Proven abilities to take initiative and be innovative Analytical mind with a problem-solving aptitude Ability ...

Platforms: Hands-on experience with Databricks and Azure Data Lake . ETL: Proven ability to build efficient pipelines (ADF, SSIS, APIs). Desirable: PySpark, Dimensional Modelling, DAX/SSAS, or an interest in AI/ML applications. Interested in learning more? Send me a DM or comment below ...