5 of 5 Star Schema Jobs in Central London

dashboards and self-service analytics tools. Qualifications Essential: Competent in SQL and Python for data transformation and analytics. Understanding of data modelling concepts (e.g., star schema, dimensional modelling). Experience (1+ year) working with relational databases and designing optimized schemas. Ability to debug and optimize slow queries ...

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

Version control (Git) Bonus points for: Airflow, Prefect, dbt, or cloud-native orchestration CI/CD and deployment automation Data warehousing fundamentals (star schema, staging patterns) Plus: Ability to explain complex engineering concepts without losing people You genuinely enjoy working with people and get energy from helping others ...

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