5 of 5 Dimensional Modelling Jobs in Central London

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

Strong understanding of ETL processes and data validation techniques. - Experience with Azure Data Factory, including understanding pipelines, datasets, and data flows. - Knowledge of data modelling and dimensional modelling concepts. - Solid SQL skills, including writing and analysing complex queries. - Experience using Azure DevOps for test and defect management. ...

retesting, and reporting. Perform back-end data testing, analysing large datasets to identify data quality issues, inconsistencies, and root causes. Validate data models and dimensional models, ensuring data structures, relationships, and business rules are correctly implemented. Use SQL to interrogate databases, read schemas and tables, reconcile data, and verify … skills with the ability to write queries, interrogate databases, read schemas and tables, and perform data reconciliation and validation. Solid understanding of data modelling and dimensional modelling, including testing data relationships, facts, dimensions, and business rules. ISTQB Data Testing certification (or equivalent) and recent, demonstrable experience working ...

experience with DBT, building and maintaining modular, scalable data models that follow best practices Previous experience working on Data Quality engagements Strong understanding of dimensional modelling Strong understanding of Data Quality and how it is measured Desireable: Experience writing complex validation logic using tools like Great Expectations ...

rule definition, thresholding, automated alerting, and root-cause remediation). Craft complex SQL transformations, optimize query performance, handle advanced window functions, and design conformed dimensional models for curated platform layers. Map end-to-end data flows from ingestion to serving, defining upstream/downstream contracts and data ownership boundaries. ...