4 of 4 Dimensional Modelling Jobs in the East of England

ingestion frameworks for integrating multiple source systems into the cloud data platform. Design and govern data transformation frameworks using DBT. Define and enforce data modelling standards including dimensional modelling, star schema, and enterprise data models. Lead architecture reviews and solution design discussions for new data initiatives. Optimize … Platform Strong experience with Amazon Web Services, including: S3 IAM AWS Glue Lambda CloudWatch Data Transformation Strong experience with DBT for enterprise-scale data modelling, testing, and transformation pipelines. Programming/Query Strong expertise in SQL for data transformation and performance optimization Python (preferred) for automation and data engineering ...

decision-making, automation, and future innovation. You'll play a key role in shaping a modern data platform and architecture , working across data engineering, modelling, and integration to deliver scalable, high-quality solutions. The role offers true ownership, allowing you to take projects end-to-end while working with … code tools and code-based approaches (SQL, Python, PySpark), ensuring performance, scalability, and reliability across the data platform. You will take ownership of data modelling and architecture , designing scalable data warehouse and lakehouse structures, including dimensional models and medallion architectures. You'll ensure data is structured effectively ...

global operations. Key Responsibilities Architect, design, develop, and maintain enterprise-level Power BI reports and datasets Build and govern advanced data models (star schema, dimensional modelling, enterprise structures) Optimise datasets, composite models, and DAX performance for scalability Lead ETL/ELT design within Microsoft Fabric Lakehouse architecture Develop … orchestrate data pipelines across ingestion, transformation, and modelling layers Optimise and monitor data workflows using Data Lakes and Logic Apps Write and maintain complex T-SQL queries, stored procedures, and optimised database logic Use Python and PySpark for distributed data processing and large-scale transformation within Fabric and cloud ...

patching, security, and performance tuning. Monitor database and warehouse workloads, diagnosing and resolving performance or integrity issues. Ensure strong standards around data quality, governance, modelling, and security across all datasets and warehouse layers. Work closely with business stakeholders to translate requirements into well structured data models and reporting solutions. … preferred). Proficiency in Python for automation, scripting, and data processing. Practical experience with SQL Server Database Administration tasks. Knowledge of data warehouse architecture, dimensional modelling, and ETL frameworks. Experience with SSIS or similar tools for ETL and data movement. Familiarity with reporting tools such as SSRS ...