14 of 14 Star Schema Jobs in London

globally connected Case Management System. The solution must support nightly data ingestion with zero disruption to system availability. Key Responsibilities Design and build a star schema data warehouse and associated data marts, including fact and dimension tables (e.g., Fact Cases, FactCaseEvents, Date, Case, Status, User, Organisation) Implement Slowly … data technologies , including: Azure SQL/Synapse Azure Data Factory Power BI (datasets, tabular models, and reporting) Strong experience building data warehouse solutions , including: Star schema design Fact and dimension modelling SCD implementation T-SQL performance tuning Experience working within always-on or mission-critical environments with strict ...

Python skills Solid understanding of Lakehouse architecture and data management principles Hands-on experience with Azure (Data Factory, Databricks, Synapse, Storage, DevOps) Experience designing Star Schema data models for Power BI 5+ years' experience building data platforms in a commercial setting Nice to have: Real-time pipeline experience ...

Python skills Solid understanding of Lakehouse architecture and data management principles Hands-on experience with Azure (Data Factory, Databricks, Synapse, Storage, DevOps) Experience designing Star Schema data models for Power BI 5+ years' experience building data platforms in a commercial setting Nice to have: Real-time pipeline experience ...

business analysis, data analysis and data cataloguing to identify and document data requirements. Proficient use of enterprise data platforms, semantic models and dimensional modelling (star schemas, fact/dimension tables). Proficient in data architecture principles, ETL processes and data pipeline concepts. Experience with data cataloguing tools ...

reporting and analytics. • Partner with stakeholders to understand requirements, validate assumptions and shape how data should be modelled. • Apply strong data modelling practices, including star schemas and Kimball methodologies. • Support the management of the lakehouse, including incremental loads, snapshotting and data quality. • Contribute to the relationship with Databricks ...

best practices across client environments. Provide technical leadership and architectural guidance to engineering teams. Design and optimise data models including 3NF, Data Vault, Star Schema, and OBT approaches. Partner with stakeholders to develop data strategies aligned to business objectives. Collaborate with engineering and data science teams to deliver ...

Skills Working knowledge of SAS (especially in ETL context) Experience in migrating SAS workloads to Informatica ETLs Familiarity with data modelling (dimensional modelling/star schema) Exposure to scheduling tools (e.g., Control-M, Autosys) Understanding of data governance and data quality frameworks ...

Snowflake Innovation: Drive CDC-based incremental processing using Snowflake Streams, Tasks, Snowpipe, Dynamic Tables, and Stored Procedures. Data Modeling: Design robust fact, dimension, and star schema models while focusing on query performance and cost optimization. Collaboration: Partner with Agile cross-functional teams and clearly translate complex data concepts ...

Responsibilities Data Modelling Standards: Establish the enterprise Data Vault, defining star schema patterns, Snowflake object hierarchies, and modelling conventions to serve as the group-wide standard for all data products. Cross-Cloud Orchestration: Design and implement secure, high-throughput data pipelines connecting AWS S3 and Azure APIs ...

Strong interpersonal skills; ability to translate complex data architecture into clear language for Business Analysts and non-technical stakeholders. Duties Data Modelling Standard: defining Star Schema patterns, Snowflake object hierarchies, and modelling conventions that serve as the Group-wide standard for all data products. Cross-Cloud Orchestration : Design ...

Skills Working knowledge of SAS (especially in ETL context) Experience in migrating SAS workloads to Informatica ETLs Familiarity with data modelling (dimensional modelling/star schema) Exposure to scheduling tools (e.g., Control-M, Autosys) Understanding of data governance and data quality frameworks Must have skills Informatica PowerCentre (preferably ...

with the ability to design efficient, scalable queries Experience working with Python within a cloud-based data platform Strong understanding of dimensional modelling and star schema design Exposure to modern lakehouse environments such as Databricks is beneficial Ability to work effectively in ambiguity and contribute in less structured ...

Python in a modern data environment Experience working with cloud-based data platforms such as a lakehouse architecture Understanding of data modelling principles, including star schemas and data transformation Ability to work independently in a fast-moving and evolving environment Comfortable collaborating across teams and reviewing or guiding others ...

requirements in banking. Proficient in BigQuery, Vertex AI, Dataflow, and Pub/Sub. Strong understanding of relational, NoSQL, and analytical data modeling (e.g., Star Schema, Data Vault, etc.). Ability to independently drive the discovery phase, moving from a vague business problem to a structured ...