4 of 4 Permanent Star Schema Jobs in London

exactly-once processing Dead-letter queues (DLQs) and failure recovery Implement CDC pipelines from Aurora PostgreSQL into Kafka and the lakehouse. Event Contracts & Schema Management Define and govern event contracts using Avro or Protobuf . Manage schema evolution through Schema Registry , including: Compatibility rules Versioning strategies Backward … modeling (ER diagrams, normalization up to 3NF/BCNF) Physical data modeling: Partitioning strategies Indexing SCD types Strong understanding of: Transactional vs analytical schemas Star schema, Data Vault, and 3NF trade-offs Practical experience with: CQRS and event sourcing Event-driven architecture Domain-driven design (bounded contexts, aggregates ...

analytics roles. Experience working within a Medallion Architecture, ideally with direct responsibility for Gold layer curation. Expertise in Power BI, including: Intermediate DAX Star schema modelling and semantic model design Report UX/UI best practices Performance optimisation Hands-on experience with Microsoft Fabric features such as Lakehouse ...

Required skills: Should have strong experience in AWS Data stack like S3/Lambda/Glue/Redshift etc., Should be able to do Schema Management Good experience in Payment platform and ISO 20022. Strong experience on streaming and EDA tools like KAFKA and AWS MSK/Kinesis etc. … Logical and physical data modelling, normalisation, and design. Should have good understanding when to denormalize for queries; trade-offs between 3NF, Data Vault, and star schemas. Should do Command Query responsibility segregation. Good understanding of observability tools like Prometheus/Grafana/CloudWatch. Good hands-on experience with Scala ...

Confluent) and AWS MSK/Kinesis/Kinesis Firehose; outbox, ordering, replay, exactly/at-least-once semantics. EventBridge for event routing and filtering. Schema management: Avro/Protobuf + Schema Registry (compatibility, subject strategy, evolution). AWS data stack: S3/Glue/Athena, Redshift, Step Functions … vs. analytics. Normalization & design: Normalize to 3NF/BCNF for OLTP; understand when to denormalize for queries; trade-offs between 3NF, Data Vault, and star schemas. - CQRS (Command Query Responsibility Segregation):Separate read/write models; event sourcing and state reconstruction; eventual consistency patterns; when CQRS is justified vs. ...