5 of 5 Dimensional Modelling Jobs in the East of England

behind every report and every operational data feed at ECP, continue the migration of our data warehouse and data lake to a modern dimensional model, finish the rollout of a principle-of-least-privilege security model across a multi-server SQL estate, and continue the migration of our reporting … will include: · Setting and personally delivering target architecture for the ECP data estate — the data warehouse, data hub, data lake, raw/ODS layers, dimensional model, audit and schema-change tracking, and the load schedules that tie them together. · Hands-on T-SQL, stored procedure, ETL framework and PowerShell ...

monitoring. Advanced knowledge of Databricks , including Lakehouse architecture, Delta Lake, and large-scale data engineering practices. Expertise in conceptual, logical, and physical data modelling, including dimensional modelling, relational modelling, and modern warehouse/lakehouse design. Strong understanding of the SCOR (Supply Chain Operations Reference) model, particularly ...

data platform and global business goals. Design the Data-to-AI Interface: Establish how enterprise data is structurally modelled (using star schemas, semantic layers, dimensional modelling, and knowledge ontologies) to ensure autonomous AI agents can search, retrieve, and reason over data reliably without hallucinating. Build AI services: Lead … deployment, monitoring and retraining. Responsible AI frameworks (ISO/IEC 42001, NIST AI RMF, EU AI Act).DesirableEnterprise data architecture, data warehousing or semantic modelling (star schemas, dimensional models).Microsoft Fabric, Azure data services or Databricks. Why RES A genuinely global remit: You will set the architecture ...

unique ingredients we’re interested in: An experienced analyst with advanced Power BI, SQL, DAX and Power Query capability, together with strong relational and dimensional modelling knowledge. Confident working with senior stakeholders, challenging assumptions and turning complex or ambiguous questions into high-value analytical outcomes. Experienced in owning ...

governance patterns. 7+ years strong hands-on experience with Azure-based data platforms, including Azure Data Factory, Databricks, data lake architectures, SQL, and dimensional data modeling, with the ability to build practical end-to-end solution designs. Proven ability to own solution architecture end to end: shape target designs … Relevant Microsoft certifications in Azure, Power BI, data, or AI architecture. Core Technology Stack Data platform : Azure Data Factory, Databricks, Azure data lake, SQL, dimensional modeling, ETL/ELT, orchestration. AI platform : Azure OpenAI, Azure AI Foundry, Azure AI Search, Copilot Studio, Semantic Kernel, Prompt Flow. Analytics : Power ...