1 to 25 of 88 Permanent Dimensional Modelling Jobs in the UK

small team of skilled Data Analysts At least 5 years’ experience in a Senior Data Analyst/Data Scientist role Demonstrable experience using data modelling (dimensional modelling), warehousing, processing (Map Reduce) and transformation techniques Expert in SQL and at least one analytical programming language (Python is preferred More ❯

the organizations systems and processes. The team has a variety of skills and experience in technical domains such as Software development, Automation, Data-pipeline-modelling, IT project management, Data visualisation. We also pride ourselves on our close integration with non-technical/non-data teams as our success comes … GCP • Experience with Terraform • Strong Python skills • Experience with version control for data models (e.g., dbt testing frameworks, data documentation) • Demonstrated experience with data modelling concepts (dimensional modelling, star schemas) • Experience writing efficient and optimised SQL for large-scale data transformations • Understanding of data warehouse design principles … working with large-scale spatial datasets (billions of rows) and performing geospatial at scale using BigQuery GIS or similar tools • Experience with advanced analytical modelling techniques, including statistical analysis and predictive modelling, particularly applying these to large-scale datasets to derive actionable insights • Knowledge of data governance and More ❯

pipelines via Azure Data Factory, Fivetran and related tools. This role would be well-suited to a data professional with core competencies in data modelling, and who is excited by the prospect of joining new data team working with cutting-edge technologies! Requirements: Strong data modelling skills Strong … experience with cloud platforms such as Snowflake or Azure Synapse Analytics Hands-on experience with dbt Understanding of modern data stack principles, including layered modelling Experience with dimensional modelling and data warehouse design principles Excellent communication and ability to engage with stakeholders at all levels Benefits: Salary More ❯

foundational data assets, and work with cutting-edge technologies like Snowflake, DBT, Microsoft Azure, and Power BI and next-gen BI platforms. Responsibilities Data Modelling & Transformation Design and maintain clean, modular data models in Snowflake, applying analytics engineering best practices using DBT. Build curated data layers (staging, intermediate, and … a reliable, enterprise-grade data foundation. Requirements Proven experience in analytics engineering or advanced BI/data roles with a strong focus on data modelling and transformation Proficiency in SQL and cloud data platforms such as Snowflake or Azure Synapse Analytics Hands-on experience with DBT for developing, testing … and documenting transformations Understanding of modern data stack principles, including layered modelling, modular SQL, and Git-based workflows Familiarity with dimensional modelling, OBT, activity schemes & data warehouse design principles Strong communication skills, with the ability to translate data into business context A proactive, detail-oriented mindset and More ❯

with over 8 years of experience within this domain, ideally in Oil and Gas. Responsibilities: Requirements capture & assessment Conceptual/logical/physical data modelling/dimensional modelling Data integration & flow design SOA architecture & principles Query & database performance tuning - ETL Cloud computing Globally-distributed database replication/ More ❯

and emerging technologies, including data integration, data warehousing and advanced analytics platforms, with the ability to assess and recommend appropriate solutions. Strong knowledge of dimensional modelling techniques, including Kimball¿s Business Dimensional Lifecycle, with the ability to provide oversight and guidance in applying these concepts effectively. Demonstrated More ❯

and emerging technologies, including data integration, data warehousing and advanced analytics platforms, with the ability to assess and recommend appropriate solutions. Strong knowledge of dimensional modelling techniques, including Kimball¿s Business Dimensional Lifecycle, with the ability to provide oversight and guidance in applying these concepts effectively. Demonstrated More ❯

Microsoft BI tools with Tableau, Amazon QuickSight , or similar platforms Understanding of REST APIs , Power BI Embedded , and programmatic data access patterns Data Engineering & Modelling Strong T-SQL skills for data retrieval and performance tuning Knowledge of dimensional modelling , star/snowflake schemas , and data warehouse best More ❯

business facing experience. Preferably in the insurance sector. Key responsibilities: Design Data Lake and Data Warehouse solutions. Design Data Models using Data Vault and Dimensional modelling methods Implement automated, reusable and efficient batch data pipelines and streaming data pipelines Work closely with Governance and Quality teams to ensure More ❯

business facing experience. Preferably in the insurance sector. Key responsibilities: Design Data Lake and Data Warehouse solutions. Design Data Models using Data Vault and Dimensional modelling methods Implement automated, reusable and efficient batch data pipelines and streaming data pipelines Work closely with Governance and Quality teams to ensure More ❯

Scala, Java, R). Experience deploying and maintaining cloud infrastructure (e.g. AWS, GCP, or Azure). Familiarity with data modeling and warehousing concepts, and dimensional modeling techniques. dbt knowledge is preferable. Comfortable working with CI/CD tools, version control, and containers (e.g Git, Jenkins, Docker). Understanding of More ❯

user reports Proficiency with reporting tools such as Oracle OAS and Microsoft Power BI Deep understanding of Data Warehouse design, including Star schema and dimensional modelling Strong analytical skills and technical aptitude, with the ability to influence system architecture decisions Experience leading testing disciplines within agile projects Self More ❯

user reports Proficiency with reporting tools such as Oracle OAS and Microsoft Power BI Deep understanding of Data Warehouse design, including Star schema and dimensional modelling Strong analytical skills and technical aptitude, with the ability to influence system architecture decisions Experience leading testing disciplines within agile projects Self More ❯

and experience: Experience with Programming languages such as (Python, SQL etc.) Experience building and maintaining data pipelines. Familiarity with medallion architecture. An understanding of dimensional modelling concepts. Proficiency with reporting tools, preferably Power BI. Practical experience working in an Agile Scrum environment. At Solus, we offer a collaborative More ❯

warehouses. Hands on experience of delivering fully reconciled Facts and Dimensions and accurate end user reports. Knowledge of Data Warehouse design; Star schema and dimensional modelling Strong analytical skills and a technical aptitude Ability to challenge and provide input in system architecture and design decisions. Good interpersonal skills More ❯

warehouses. Hands on experience of delivering fully reconciled Facts and Dimensions and accurate end user reports. Knowledge of Data Warehouse design; Star schema and dimensional modelling Strong analytical skills and a technical aptitude Ability to challenge and provide input in system architecture and design decisions. Good interpersonal skills More ❯

warehouses. Hands on experience of delivering fully reconciled Facts and Dimensions and accurate end user reports. Knowledge of Data Warehouse design; Star schema and dimensional modelling. Strong analytical skills and a technical aptitude. Ability to challenge and provide input in system architecture and design decisions. Good interpersonal skills in More ❯

data solutions that drive business value. Key Responsibilities Build Data Products: Collaborate with business domains to design and develop ETL/ELT pipelines and dimensional models optimised for Power BI Drive Governance: Define and enforce data ownership, quality, and security standards within the Data Mesh architecture Enable Self-Service … Technical Expertise: Proven experience coding ETL/ELT pipelines with Python, SQL, or ETL tools, and proficiency in Power BI, Tableau, or Qlik Data Modelling Skills: Strong knowledge of dimensional modelling and database principles Governance Experience: Track record of working in democratized data environments, establishing controls and More ❯

data solutions that drive business value. Key Responsibilities Build Data Products: Collaborate with business domains to design and develop ETL/ELT pipelines and dimensional models optimised for Power BI Drive Governance: Define and enforce data ownership, quality, and security standards within the Data Mesh architecture Enable Self-Service … Technical Expertise: Proven experience coding ETL/ELT pipelines with Python, SQL, or ETL tools, and proficiency in Power BI, Tableau, or Qlik Data Modelling Skills: Strong knowledge of dimensional modelling and database principles Governance Experience: Track record of working in democratized data environments, establishing controls and More ❯

BI. Solid hands-on experience with Azure Databricks - Pyspark coding and Spark SQL coding - Must have. Very good knowledge of data warehousing skills including dimensional modeling, slowly changing dimension patterns, and time travel. Experience in delivering Agile projects with implementation knowledge on CI/CD pipelines, preferably on Azure More ❯

strategies, data quality analysis, issue resolution, unit testing, and release management. Conduct data profiling and analysis to assess data quality, consistency, and integrity, leveraging dimensional modeling techniques where appropriate. Create and maintain data mapping documents to support ETL processes and data integration efforts to ensure clarity and consistency. Responsible More ❯

necessary. Perform SQL and ETL tuning as necessary. Basic Qualifications: 5+ years of relevant data engineering experience Strong understanding of data modeling principles including dimensional modeling & data normalization principles. Good understanding of SQL Engines and able to conduct advanced performance tuning. 2+ years of work experience implementing and reporting More ❯

systems using microservices architectural patterns. DevOps experience in implementing development, testing, release, and deployment processes using DevOps processes. Knowledge in data modeling (3NF/Dimensional modeling/Data Vault2). Work experience in agile delivery. Able to provide comprehensive documentation. Able to set and manage realistic expectations for timescales More ❯

Minimum criteria Significant database experience in Snowflake or Oracle Experience of building a data warehouse using an ETL/ELT tool Star schema/dimensional modelling. Excellent SQL skills Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements Experience More ❯

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 More ❯