6 of 6 Dimensional Modelling Jobs in the North of England

scalability. Validate ETL processes, including during source system software upgrades, to ensure continuity and data integrity. Design and maintain the reporting layer, including dimensional modelling, to support efficient and reusable analytics. Apply expert T-SQL and SQL Server skills for query optimisation and advanced data manipulation. Support … processes that embed data quality monitoring within routine reporting and governance structures. Contribute to the implementation of advanced analytics methods such as predictive analytics, modelling including AI, Python, and R, to help drive innovation. The postholder will be line managed by the Principal BI Developer and will work closely ...

Data Warehouse Engineer, or similar. Strong hands-on knowledge of Microsoft Fabric and related services. End-to-end DWH development knowledge, from ingestion to modelling and consumption. Strong background in data modelling, including star schema, dimensional modelling and semantic modelling. Ability to orchestrate, monitoring and optimise ...

operational reporting. Key Responsibilities: Build, maintain and optimise scalable, secure and well-governed data pipelines. Develop and maintain data models (Data Vault and Dimensional). Ensure data quality, lineage, governance and security standards are embedded in all pipelines. Troubleshoot and resolve data pipeline issues, performing root cause analysis … distributed environments (DBT, Snowflake, SQL Server Stack; experience with Kafka, MySQL, Azure or AWS is a plus). Strong expertise in Data Vault and Dimensional modelling is essential. Experience embedding data governance, quality, monitoring and alerting into pipelines. Knowledge of Agile delivery and CI/CD principles. Excellent ...

business goals Design logical and physical data models optimised for reporting, analytics, and self-service BI Establish and govern architectural patterns (e.g. medallion architecture, dimensional modelling, data vault) Design cloud-based data platform architectures (AWS preferred), including data storage, processing, and consumption layers Technology Leadership Evaluate and recommend … cloud-native services Lead proofs-of-concept and technical assessments for new technologies Ensure the data architecture remains modern, performant, and future-proof Data Modelling & Governance Define standard business entities, metrics, and KPIs for consistent reporting Review and approve complex data models created by BI Engineers Design and embed ...

Agile. The Essentials Pipeline Tech: 5+ years of experience with Kafka, Spark, Hadoop, and DBT . Modern Modeling: Expert skills in Data Vault and Dimensional modeling. Cloud & DevOps: Strong AWS experience with a focus on CI/CD and writing secure code. Data Governance: Proven ability to embed quality ...

Required experience Proven experience (3+ years) developing complex reports and composite models. Strong SQL skills for querying data warehouses and creating views. Knowledge of Dimensional Modeling (Star Schema). Ability to translate technical data concepts for non-technical legal and business stakeholders. Experience in working with Snowflake is desirable. ...