26 to 27 of 27 Star Schema Jobs in the UK

APIs, SaaS platforms (e.g. subscription billing), SQL sources, SharePoint and SFTP using ADF + metadata-driven frameworks . Apply Lakeflow expectations for data quality, schema validation and operational reliability. Curated Data Layers & Modelling Build clean, conformed Silver/Gold models aligned to enterprise business domains (customers, subscriptions, deliveries, finance … credit, logistics, operations). Deliver star schemas, harmonisation logic, SCDs and business marts to power high-performance Power BI datasets . Apply governance, lineage and fine-grained permissions via Unity Catalog . Orchestration & Observability Design and optimise orchestration using Lakeflow Workflows and Azure Data Factory . Implement monitoring, alerting ...

strategies. Handle complex data encoding transformations, such as EBCDIC to UTF-8 and packed decimal conversions, with validation test suites. Utilize migration tooling for schema conversion and downstream analytics (Glue, Athena, Redshift), with infrastructure-as-code (Terraform) and CI/CD (GitLab). Plan and execute cutovers with dual … analytics. Normalization & design: Normalize to 3NF/BCNF for transactional systems; understand when to denormalize for queries; trade-offs between 3NF, Data Vault, and star schemas. Domain-Driven Design: Bounded contexts and subdomains; aggregates and aggregate roots; entities vs. value objects; repository patterns; ubiquitous language. Event-driven architecture: Domain ...