8 of 8 Permanent Dimensional Modelling Jobs in Central London

behind every report and every operational data feed at ECP, continue the migration of our data warehouse and data lake to a modern dimensional model, finish the rollout of a principle-of-least-privilege security model across a multi-server SQL estate, and continue the migration of our reporting … will include: Setting and personally delivering target architecture for the ECP data estate the data warehouse, data hub, data lake, raw/ODS layers, dimensional model, audit and schema-change tracking, and the load schedules that tie them together. Hands-on T-SQL, stored procedure, ETL framework and PowerShell ...

visualizations in Qlik Strong knowledge of data visualization best practices using Qlik Experience working with a relational database (SQL, Oracle, etc.) a plus Data modelling, dimensional modelling, and working with large datasets a plus Experience working with business teams to translate functional requirements into technical requirements Additional ...

with Azure Databricks and Azure SQL/SQL Server to process and manage large datasets. Design and implement data models using Kimball, 3NF and dimensional modelling approaches. Develop metadata-driven pipelines to improve automation and efficiency. Work closely with technical teams and clients to understand data requirements ...

Python Experience developing and optimizing batch and real-time data processing solutions Strong understanding of modern data architecture patterns, including Kimball, Data Vault, dimensional modelling, and data product design principles Experience implementing Infrastructure as Code using tools such as Terraform or CloudFormation Experience leading technical delivery teams ...

warehouse using an ETL/ELT tool, preferably Oracle ODI or dbt Significant database experience in Snowflake and/or Oracle 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 ...

data and analytics capabilities. Working within a complex insurance environment, you will define the future-state data architecture, champion best practices in data modelling and governance, and help create a scalable, data-driven foundation for the business. Leveraging your expertise in Snowflake and dbt, you will enable the delivery … from legacy policy, claims, and finance systems to modern cloud data solutions Establish architectural patterns supporting data domains, data products, and reusable assets Data Modelling Skills & Experience Excellent understanding of conceptual, logical, and physical data modelling principles. Experience designing enterprise data models, reporting marts and business specific data ...

Analytics Engineer at Onmo, you will be the day-to-day owner of the business-ready layer of our Databricks lakehouse: the dimensional models, governed metric definitions and self-serve tools that Finance, Credit Risk, Collections and Operations rely on. You will sit between data engineering and the business … turning credit policy and finance rules into trusted, explainable numbers. RESPONSIBILTIES Build and extend our gold-layer dimensional models, including point-in-time and month-end facts. Work with the Data team and business owners to define and maintain governed metric definitions for credit and finance KPIs (arrears ...

streams and semi-structured sources. Implement change data capture and incremental load, including ordering, deletes, replay and slowly changing dimensions. Build medallion datasets and dimensional models, and deliver them to Snowflake, Microsoft SQL Server and Databricks. Apply data contracts, reconciliation and row-level quarantine before publication. Own the GitHub … client-facing teams into operable pipelines. Requirements 10+ years in data engineering on production systems. Snowflake or Databricks as a primary platform, including modelling, performance tuning and cost management. Python and SQL for pipeline development and testing. Change data capture and event processing, including ordering, replay and schema change. ...