24 of 24 Remote 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 ❯

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 ❯

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 ❯

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 ❯

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 ❯

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 ❯

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 ❯

pipelines handling diverse data sources. You'll work closely with our clients to design the correct data models to support their analytic requirements following best practices such as Kimball star schemas and snowflake schemas, ensuring performance and ease of use for the client. You'll manage the delivery of ETL/ELT processes using tools like Matillion, Informatica More ❯

team. About You This role will be a great fit if you: Have deep expertise in data warehousing, demonstrated through a comprehensive understanding of principles architectural patterns (e.g., Kimball, Data Vault), and industry best practices, coupled with demonstrable experience implementing engineering best practices like version control, code reviews, and CI/CD. Bring significant experience in advanced data More ❯

Stakeholder Engagement & Training Ideally you’ll have: Experience of building out modern data stacks, particularly based around Snowflake, Matillion and Looker. Proficiency in data modelling, including Kimball methodology and schema design. Knowledge of data warehousing design principles, particularly with Snowflake. Experience of implementing Master Data Management techniques with medallion architecture. Strong SQL skills, able to interrogate and More ❯

warehousing, and reporting. Experience with AWS data services (approx. 25%), particularly RDS, S3, Lambda, EventBridge, and building data pipelines in cloud-native environments. Proven delivery of dimensional/Kimball data models in collaboration with Data Analysts. Strong proficiency with Power BI, including performance optimisation and deployment strategies. Hands-on experience with Python for automation and data transformation (not More ❯

warehousing, and reporting. Experience with AWS data services (approx. 25%), particularly RDS, S3, Lambda, EventBridge, and building data pipelines in cloud-native environments. Proven delivery of dimensional/Kimball data models in collaboration with Data Analysts. Strong proficiency with Power BI, including performance optimisation and deployment strategies. Hands-on experience with Python for automation and data transformation (not More ❯

warehousing, and reporting. Experience with AWS data services (approx. 25%), particularly RDS, S3, Lambda, EventBridge, and building data pipelines in cloud-native environments. Proven delivery of dimensional/Kimball data models in collaboration with Data Analysts. Strong proficiency with Power BI, including performance optimisation and deployment strategies. Hands-on experience with Python for automation and data transformation (not More ❯

warehousing, and reporting. Experience with AWS data services (approx. 25%), particularly RDS, S3, Lambda, EventBridge, and building data pipelines in cloud-native environments. Proven delivery of dimensional/Kimball data models in collaboration with Data Analysts. Strong proficiency with Power BI, including performance optimisation and deployment strategies. Hands-on experience with Python for automation and data transformation (not More ❯

or interest in: Microsoft Fabric and its evolving role in enterprise data platforms Azure DevOps for CI/CD and deployment T-SQL and dimensional modelling (Kimball methodology) Experience in Financial Services or Lloyd's market is a plus Apply now or get in touch to find out more - alexh@pioneer-search.com More ❯

plus. Strong knowledge of data warehousing principles. Strong SQL expertise, understanding of ETL, DAX, Power Query. Ability to maintain and enhance semantic models. Knowledge of dimensional data modeling (Kimball), Data warehousing concepts … OLAP. Excellent analytical and problem-solving skills. Strong communication skills to effectively collaborate with team members and stakeholders. Experience with Azure and 365 environments. Preferred Qualifications: Experience with Agile methodology, DevOps, GIT, Modern Development. User and group Admin, including MS Entra (AD), and PowerBI service. Understanding of data privacy, data governance, and security protocols. This is an urgent vacancy More ❯

and AI-ready data across commercial, operational, and network functions. Key Responsibilities Build and maintain robust ETL/ELT pipelines across multiple data sources Design data models using Kimball/star schema Implement tooling for data quality checks, lineage, and observability (e.g., dbt tests, Great Expectations, Azure Purview) Work closely with DevOps teams to embed CI/CD More ❯

the Trusts vision of automating reporting using modern tools to enable self-service.They will maintain the Microsoft SQL Server data warehouse using ETL processes aligned to Kimball methodology, upholding data quality standards to support effective decision-making. The role includes safeguarding performance, security and integrity of data systems, using DevOps and change control practices to deliver efficient … professional development Desirable Member of a relevant professional body Fed IP, BCS knowledge Essential T-SQL Scripting, Views/Stored Procedures, Cursors and functions Kimball data warehousing methodology NHS Data Definitions, Datasets and Statistical Returns Desirable NHS Information Governance Data Protection Act 1998 and Caldicott Principles Data Accreditation/Information Quality Assurance Disclosure and Barring Service Check More ❯

Governance: Establish data quality checks and governance practices to ensure accuracy and integrity within data models. Skills/Must have: Proven experience in data modelling using Kimball methodology, with a focus on dimensional modelling and star schemas. Strong proficiency in SQL and experience with data modelling tools like ER Studio, Power Designer, or similar. Ability to translate More ❯

REST APIs, Kafka streams and other sources. Apply data cleansing rules to ensure high data quality standards. Model data into a single source of truth using Kimball methodology (star schema, snowflake, etc.). Develop high-quality code following DevOps and software engineering best practices, including testing and CI/CD. Monitor and maintain business-critical pipelines, reacting … Lake, Unity Catalog and Python (including unit and integration testing). Deep understanding of software development principles (SOLID, testing, CI/CD, version control). Strong knowledge of Kimball data modelling. Advanced SQL and data analysis skills. Proven ability to deliver under pressure while maintaining high standards. Passion for technology and its impact on business outcomes. Package: Day More ❯

Use your experience of domain models to inform new domain model design and resolve complex entity-relationship patterns. Have a good understanding of different data modelling architectures (e.g. Kimball) and be able to leverage this knowledge to inform designs. Technical Analysis All deliverables at Tasman start with a discovery process. At the core of the Tasman approach to More ❯