3 of 3 Contract Dimensional Modelling Jobs in Central London

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

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