We''re hiring a hands-on Data Architect/ BI Consultant to support the evolution of a cloud-based data platform, with a strong focus on data warehousing, analytics, and reporting. You''ll work closely with BI Developers to design, build, and optimise end-to-end data solutions across the Azure stack. Client Details A well-established UK-based international investment organisation with a global footprint, delivering impactful programmes across multiple regions. Description Design and enhance Enterprise Data Warehouse and data hub architectures Build and support end-to-end data pipelines (ingestion transformation reporting) using Azure services Work hands-on with tools including ADF, Synapse, ADLS and Microsoft Fabric Develop and optimise dimensional data models (Kimball / star schema) for analytics and reporting Provide technical guidance and support to BI Developers during delivery (non-managerial) Contribute to Power BI / semantic layer design to support enterprise reporting Support integration of data from multiple SaaS and third-party systems Ensure best practices across data quality, governance, metadata, and performance optimisation Maintain documentation including data models, data dictionaries, and architecture diagrams Assist with CI/CD pipelines and deployment processes (Azure DevOps) Profile Proven experience as a hands-on Data Architect and strong Azure expertise across: Azure Data Factory (ADF) Azure Synapse / Azure SQL Azure Data Lake (ADLS) ..... full job details .....