2 of 2 Star Schema Jobs in the South East

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 ...

design/implementation - showing a strong understanding of relational database design/entity relationship Data warehouse design/implementation – showing a strong understanding of star schema/Kimball Whilst not essential, skills in SSRS, Power BI, Power Query, C# and DAX would be helpful. This will ...