Data Architect/ BI Consultant

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) Exposure to Microsoft Fabric (highly desirable) Strong background in data warehousing and BI environments Excellent dimensional modelling (Kimball) experience Experience working closely with BI / reporting teams (Power BI, semantic models, DAX) Confident working across end-to-end data pipelines and integration patterns Strong SQL skills with experience optimising queries and datasets Comfortable guiding and supporting developers without formal leadership responsibility Exposure to metadata management, data governance, and data quality frameworks Experience with CI/CD (Azure DevOps, Gi t) and ideally scripting (Python / PySpark) Job Offer £700-£800 per day (Inside IR35) Hybrid working (2-3 days in London) Initial 6-month contract with extension potential