BI Architect

We're hiring a hands-on BI Architect 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 or Senior Data Engineer operating at architecture level - 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