1 to 25 of 54 Dimensional Modelling Jobs in London

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 ❯

Bachelor's degree with majors in Computer Science, Information Systems, Statistics, Mathematics & Engineering Minimum 4 years of experience as a BI developer responsible for: Dimensional modelling (Kimball Methodology) Data Modelling (Kimball Methodology) ELT/ETL Dataverse (Data Flows) Data Factory Pipeline Development Dashboarding and Reporting (PBI) Data More ❯

models, ensuring seamless integration and optimal data utilization. Job Role Accountabilities Requirements Gathering: Collaborate with business stakeholders to gather and understand requirements for data modelling, data product design, and development, ensuring alignment with business goals and objectives. Data Modelling: Partner with business stakeholders and analysts to design and … quality technical documentation for all data models, ensuring it is consistently stored and accessible for future reference. Continuous Improvement: Drive innovation by continually improving modelling methods and recommending process enhancements that help the team meet and exceed expectations. Quality Assurance: Conduct peer reviews of models and documentation to ensure … lifecycle. Experience working within an Agile environment, delivering outcomes within defined Sprints, and familiarity with Agile principles and ceremonies. Skills and Knowledge: Expertise in dimensional modelling (Kimball) and familiarity with Data Vault 2.0. Strong SQL skills and aptitude for data development. Knowledge of Agile methodologies (SCRUM, Kanban, SAFe More ❯

Analytics. Proficiency in Microsoft Azure’s data and integration services, and experience working with APIs to enable cloud-based data flows. Strong experience in dimensional modelling and formal database design. A good understanding of data governance, quality, and security principles. Ability to work both independently and collaboratively, with More ❯

Analytics. Proficiency in Microsoft Azure’s data and integration services, and experience working with APIs to enable cloud-based data flows. Strong experience in dimensional modelling and formal database design. A good understanding of data governance, quality, and security principles. Ability to work both independently and collaboratively, with More ❯

S3, Snowflake, Athena, Glue), In depth understanding of database structure principles, Strong knowledge of database structure systems and data mining, Excellent understanding of Data Modelling (ERwin, PowerDesigner, Dimensional Modelling) An understanding of SQL/database management. Strong hands-on experience in Data Warehouse and Data Lake technologies 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 ❯

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 ❯

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 ❯

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 ❯

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 ❯

relationships with key data creators, data owners and 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 … easily understood and used. Locate and define new data-related process improvement opportunities. Skills and Experience: Essential: • Experience managing/leading a team. • Data modelling, cleansing and enrichment, with experience in conceptual, logical, and physical data modelling. • Familiarity with data warehouses and analytical data structures. • Experience of data quality … 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 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 ❯

Synapse, Data Lakes, etc.). Experience with CI/CD pipelines for release management. Knowledge of best practices in data ingestion, transformation, and curation (Dimensional modeling & Medallion schema). Insurance Industry experience. Fabric experience. Purview experience. Power BI experience. If this role is of interest to you or you More ❯

private equity, private credit, and real estate data-including metrics, KPIs, and market trends. Background in data modeling and data management best practices (e.g., dimensional modeling, data governance, metadata management). Ability to provide insights on complex financial data sets and collaborate with relevant stakeholders. WHAT WE OFFER: We More ❯

SSIS, SSAS, SSRS) to high level of proficiency - Essential C# Programming/JavaScript programming - Desirable Knowledge and Skills Software analysis and design good practice Dimensional modelling, Entity Relationship modelling, Normalised modelling. Data warehouse design concepts, (Inmon, Kimball) The position is based in Central and you will be More ❯

SSIS, SSAS, SSRS) to high level of proficiency - Essential C# Programming/JavaScript programming - Desirable Knowledge and Skills Software analysis and design good practice Dimensional modelling, Entity Relationship modelling, Normalised modelling. Data warehouse design concepts, (Inmon, Kimball) The position is based in Central and you will be More ❯

relationships with key data creators, data owners and 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 … easily understood and used. Locate and define new data-related process improvement opportunities. Skills and Experience: Essential: • Experience managing/leading a team. • Data modelling, cleansing and enrichment, with experience in conceptual, logical, and physical data modelling. • Familiarity with data warehouses and analytical data structures. • Experience of data quality … 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 More ❯

skills in building dashboards and using visualisation tools such as Tableau (beneficial), Power BI or Looker. Experience in database design and architecture principles, e.g. dimensional modelling and strong SQL ability Some understanding or interest in programming languages such as Python. Exposure to working with CRM/ERP systems. More ❯

skills in building dashboards and using visualisation tools such as Tableau (beneficial), Power BI or Looker. Experience in database design and architecture principles, e.g. dimensional modelling and strong SQL ability Some understanding or interest in programming languages such as Python. Exposure to working with CRM/ERP systems. More ❯