1 to 25 of 141 Kimball Methodology Jobs in England

functions through robust, scalable, and innovative data solutions. In this position, you'll be responsible for designing, building, and optimizing data warehouses using best practices in dimensional modelling, Kimball methodologies, star schema design, and Data Vault principles, ensuring adherence to sound data architecture practices. Based in Avonmouth on a hybrid working basis – 2 days in office per week … and optimizing on-premises SQL Server data warehouses, focusing on stored procedures, indexing, partitioning, and load performance. A proven track record in designing and building data warehouses using Kimball methodologies, dimensional modeling, star schema design, and Data Vault techniques is essential. You should be well-versed in applying data architecture principles to create robust, scalable solutions Azure Cloud More ❯

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 ❯

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. Desirable: Databricks (or Alternative Modern Data Platform such as Snowflake) Experience working in a regulated environment and knowledge of the risk and compliance requirements associated with this. More ❯

solutions Large scale Data Lakehouse/Data Warehouse design Conceptual architecture Logical architecture Physical architecture ETL/ELT best practice approaches to monitoring and error-handling Understanding of Kimball data-modelling techniques Hands-on experience and ability to collaborate with data engineers to polish solutions for customer-readiness SQL Azure, Synapse Analytics (dataflows, Jupyter notebooks, on-demand SQL More ❯

Integrate data from various sources including APIs, Excel, CSV, JSON, and databases. Manage data lakes, warehouses, and lakehouses within Azure cloud environments. Apply data modelling techniques such as Kimball methodologies, star schemas, and data warehouse design principles. Build and support ETL workflows using tools like Azure Data Factory, Synapse, Delta Live Tables, dbt, SSIS, etc. Automate infrastructure deployment … data engineering experience. Has strong skills in Python, SQL, and PySpark. Experienced working with data lakes, warehouses, lakehouses, and cloud platforms, preferably Azure. Knowledgeable in data modelling, including Kimball and star schemas. Familiar with ETL tools such as Azure Data Factory, Synapse, Delta Live Tables, dbt, SSIS. Experienced with Infrastructure as Code (Terraform, ARM, Bicep). Skilled in More ❯

the mobile/telecoms industry 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 Google Cloud Platform environments … Expert level proficiency in SQL. • Deep, practical experience of building and architecting data models with dbt. • A strong understanding of data warehousing concepts and data modelling techniques (e.g., Kimball, Dimensional Modelling, One Big Table). • Solid, hands-on experience within the Google Cloud Platform, especially with BigQuery. • Proven experience working directly with business stakeholders to translate their needs 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 ❯

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 ❯

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 ❯

building CI/CD pipelines Desirable experience: Integration to D365 and working knowledge of Microsoft Common Data Model Databricks, Snowflake Azure Functions, Service Bus, Event Grid Understanding of Kimball data-modelling techniques Microsoft Azure data certifications Azure Synapse: Synapse-link, on-demand SQL engine, serverless SQL pool, Spark pool Writing unit tests, Git version control Awareness of reliability More ❯

content distribution. Strong understanding of data management platforms, BI lifecycle methodologies, and data visualisation best practices. Proficiency in SSMS or Azure Data Studio, dimensional data modelling (Kimball methodology), and data presentation in Power BI using DAX. Expertise in writing efficient and robust SQL code to support dimensional data models. Experience gathering reporting requirements and translating them into 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 Clearing More ❯

Factory, and Power BI. Azure Analysis Services is a nice to have. Extensive experience developing SQL relational databases and data warehousing technologies. Knowledge of Kimball, or similar methodology, a nice to have. Advanced DBA level understanding of Microsoft SQL Server concepts such as performance tuning with row or column store indexing, graph databases, or geocoding/geospatial More ❯

management principles, encompassing both relational and non-relational databases, data warehousing, ETL processes, and cloud-based data storage solutions like AWS and Azure. Expertise in data modelling methodologies (Kimball, DataVault) is essential, as is hands-on experience with RDBMS (preferably Snowflake or SQL Server) and large-scale data processing through ETL pipelines. Familiarity with Git or MS Visual 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 ❯

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 ❯

Strong data modelling and SQL/database design skills. Proficiency in ETL/ELT processes. Expert-level SQL and Python programming. Understanding of different data modelling techniques (e.g., Kimball, star, and snowflake schemas). Data quality techniques. Data normalisation. Cloud and Big Data Technologies. Extensive experience with Databricks. Familiarity with cloud data warehouses (AWS, Azure, GCP, or Snowflake More ❯

We are Dufrain, a pure-play data consultancy specialising in helping businesses unlock the true value of their data by providing market-leading data solutions and services which includes developing strategies for AI readiness, improving data literacy and culture, enhancing 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 ❯