1 to 25 of 67 Kimball Methodology Jobs in the UK

data consumers. Ensure data assets are properly defined and maintained within a central data catalogue. Data modelling to transform operational data into analytic/reporting structures such as Kimball style multi-dimensional models. Take ownership of data issues through to resolution, working with IT and other internal stakeholders. Perform and automate data validation to improve data quality and … other source control software. • Knowledge of Orchestration Tools and processes (e.g SSIS, Data Factory, Alteryx) • Power BI Development including the data model, DAX, and visualizations. • Relational and Dimensional (Kimball) data modelling • Proficiency in SQL (T-SQL, PL/SQL, Databricks SQL) Desirable: • Databricks (or Alternative Modern Data Platform such as Snowflake) • Experience working in a regulated environment and More ❯

Experience working with one or more of Kafka, Snowflake, Azure Data Factory, Azure Synapse or Microsoft Fabric is highly desirable. Knowledge of data modelling and data architectures: Inmon, Kimball, DataVault. About You A high level of drive with the ability to work to tight deadlines. Experience of providing insightful solutions. The ability to participate effectively in meetings with More ❯

trusted source for enterprise-wide reporting and analytics. JOB PROFILE We are seeking a skilled Data Warehouse Developer to design, build, and maintain an internal data warehouse using the Kimball methodology. The ideal candidate will have expertise in creating fact and dimension tables, ETL processes, and ensuring data integrity. Experience with Dynamics 365 CE & F&O is highly … desirable. KEY DUTIES AND RESPONSIBILITIES Design and implement a Kimball-style data warehouse architecture, including fact and dimension tables. Develop and optimize ETL/ELT pipelines to integrate data from Dynamics 365 (CE & F&O) and other sources. Collaborate with business stakeholders to define key business metrics and reporting needs. Ensure data quality, consistency, and performance across the … and best practices for the warehouse. Develop and maintain documentation on data models, processes, and business rules. SKILLS AND QUALIFICATIONS Data Warehousing: Strong knowledge of the Kimball methodology (star schema, fact & dimension tables). Experience in designing and implementing data models for analytical reporting. ETL/ELT & Data Integration: Hands-on experience with ETL tools (e.g., Azure More ❯

Ecosystem: At least 2 years of experience delivering business solutions using: Azure Data Factory/Synapse Power BI Azure SQL Server Data Modelling: Strong knowledge of dimensional modelling (Kimball). Familiarity with other techniques such as Data Vault 2.0. Development Experience: Minimum 3 years in database and/or analytics systems development and deployment. Strong understanding of Python More ❯

/ETL tools (Matillion preferred) Experience of SQL Server and Snowflake (or other variants of Cloud Data Warehousing solutions e.g Azure/AWS etc) Experience using Kimball methodology to support analytics and reporting Experience with data migration, including mapping existing business logic to new data sources Experience of converting business requirements into a delivered solution Experience with …/ELT tools (Matillion preferred) Experience of SQL Server and Snowflake (or other variants of Cloud Data Warehousing solutions e.g Azure/AWS etc) Experience using Kimball methodology to support analytics and reporting Experience with data migration, including mapping existing business logic to new data sources Experience of converting business requirements into a delivered solution Experience with More ❯

/ELT tools (Matillion preferred) Proficiency with SQL Server and Snowflake or similar cloud data warehousing solutions (Azure, AWS, etc.) Experience supporting analytics and reporting using Kimball methodology Experience with data migration and business logic mapping Proven ability to convert business requirements into solutions Experience with Power BI Desirable: Experience with Business Systems reporting, including ERP Knowledge More ❯

Ability to operate in a client-facing environment, contributing to multi-disciplinary teams and complex programmes Ideally, experience with containerisation technologies such as Docker and Kubernetes Exposure to Kimball data modeling, data architecture, and performance optimisation Experience delivering end-to-end solutions involving Azure data platform components If this role interests you and you would like to find More ❯

Ability to operate in a client-facing environment, contributing to multi-disciplinary teams and complex programmes Ideally, experience with containerisation technologies such as Docker and Kubernetes Exposure to Kimball data modeling, data architecture, and performance optimisation Experience delivering end-to-end solutions involving Azure data platform components If this role interests you and you would like to find More ❯

Ability to operate in a client-facing environment, contributing to multi-disciplinary teams and complex programmes Ideally, experience with containerisation technologies such as Docker and Kubernetes Exposure to Kimball data modeling, data architecture, and performance optimisation Experience delivering end-to-end solutions involving Azure data platform components If this role interests you and you would like to find More ❯

Ability to operate in a client-facing environment, contributing to multi-disciplinary teams and complex programmes Ideally, experience with containerisation technologies such as Docker and Kubernetes Exposure to Kimball data modeling, data architecture, and performance optimisation Experience delivering end-to-end solutions involving Azure data platform components If this role interests you and you would like to find More ❯

Ability to operate in a client-facing environment, contributing to multi-disciplinary teams and complex programmes Ideally, experience with containerisation technologies such as Docker and Kubernetes Exposure to Kimball data modeling, data architecture, and performance optimisation Experience delivering end-to-end solutions involving Azure data platform components If this role interests you and you would like to find More ❯

Ability to operate in a client-facing environment, contributing to multi-disciplinary teams and complex programmes Ideally, experience with containerisation technologies such as Docker and Kubernetes Exposure to Kimball data modeling, data architecture, and performance optimisation Experience delivering end-to-end solutions involving Azure data platform components If this role interests you and you would like to find More ❯

skills with a passion for optimising workflows. Excellent communication and teamwork abilities to thrive in a dynamic consultancy environment. Data modelling experience and understanding of the Kimball methodology Desirable Expertise: DP-600 – Fabric Analytics Engineer Associate PL-300 – Power BI Data Analyst Associate Responsibilities: On a daily basis your varied role will include, but will not be More ❯

with the business and delivering complex requirements to tight timescales. Strong interest in latest data engineering technologies, best practises, techniques and trends in the data industry Required Toolsets: Kimball data modelling Microsoft SQL Server Analysis Services (Multidimensional/Tabular), Power BI Python, MDX, DAX Responsibilities The Data Manager will be responsible for supporting Head of Data and Analytics More ❯

with the business and delivering complex requirements to tight timescales. Strong interest in latest data engineering technologies, best practises, techniques and trends in the data industry Required Toolsets: Kimball data modelling Microsoft SQL Server Analysis Services (Multidimensional/Tabular), Power BI Python, MDX, DAX Responsibilities The Data Manager will be responsible for supporting Head of Data and Analytics More ❯

with the business and delivering complex requirements to tight timescales. Strong interest in latest data engineering technologies, best practises, techniques and trends in the data industry Required Toolsets: Kimball data modelling Microsoft SQL Server Analysis Services (Multidimensional/Tabular), Power BI Python, MDX, DAX Responsibilities The Data Manager will be responsible for supporting Head of Data and Analytics More ❯

Azure technologies: SQL Server, ADF, Logic Apps, Data Lake, Power Query, Fabric, Function Apps, Power Automate, Spark, Databricks, SSIS. Strong understanding of data modelling techniques including Normalisation and Kimball methodologies. Proficient in SQL, and experience with programming languages such as Python or C#. Familiarity with low-code platforms (e.g., SharePoint, Power Apps, Power Automate, Nintex). Experience or More ❯

Azure technologies: SQL Server, ADF, Logic Apps, Data Lake, Power Query, Fabric, Function Apps, Power Automate, Spark, Databricks, SSIS. Strong understanding of data modelling techniques including Normalisation and Kimball methodologies. Proficient in SQL, and experience with programming languages such as Python or C#. Familiarity with low-code platforms (e.g., SharePoint, Power Apps, Power Automate, Nintex). Experience or More ❯

downstream consumption. Key outputs for the role • Develop and maintain data pipelines using Azure Data Factory (ADF), ensuring efficient and reliable data movement and transformation. • Data Modelling using Kimball, 3NF or Dimensional methodologies • Utilize SQL and Python languages to extract, transform, and load data from various sources into Azure Databricks and Azure SQL/SQL Server. • Design and More ❯

Microsoft Azure T-SQL Development (MS SQL Server 2005 onwards) Python, PySpark Experience of the following systems would also be advantageous: Azure DevOps MDS Kimball Dimensional Modelling Methodology Power Bi Unity Catalogue Microsoft Fabric Experience of the following business areas would be advantageous: Insurance sector (Lloyds Syndicate, Underwriting, Broking) Qualifications: Degree educated in relevant field or long More ❯

What do I need? Experienced with data warehouse and business intelligence, including delivering low-level ETL design and physical data models. Proficient in Data Warehousing Design Methodologies (e.g., Kimball dimensional models) and Data Modelling tools (e.g., ER Studio). Strong Data Analysis skills and hands-on experience with SQL/Python for data interrogation. Working knowledge of Cloud More ❯

of various financial products and the trading life cycle. The role Advanced proficiency in SQL (T-SQL, PL/SQL, Databricks SQL) Knowledge of Kimball data modelling methodology Experience using scripting languages such as Python, PowerShell etc. Experience with Microsoft Azure. Strong knowledge of ETL/ELT tools and experience navigating data pipelines. Advanced Power BI (Modelling More ❯

of various financial products and the trading life cycle. The role Advanced proficiency in SQL (T-SQL, PL/SQL, Databricks SQL) Knowledge of Kimball data modelling methodology Experience using scripting languages such as Python, PowerShell etc. Experience with Microsoft Azure. Strong knowledge of ETL/ELT tools and experience navigating data pipelines. Advanced Power BI (Modelling More ❯

transactional data and analytic data sources. Analysis of semi structured and file-based data extracts. Data modelling to transform operational data into analytic/reporting structures such as Kimball style multi-dimensional models. Essential Skills for the Data Analyst: Proven Data Analyst experience of at least 5 years, within a Financial Services environment, with particular emphasis on Risk More ❯

transactional data and analytic data sources. Analysis of semi structured and file-based data extracts. Data modelling to transform operational data into analytic/reporting structures such as Kimball style multi-dimensional models. Essential Skills for the Data Analyst: Proven Data Analyst experience of at least 5 years, within a Financial Services environment, with particular emphasis on Risk More ❯