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

\n
• Design and enhance Enterprise Data Warehouse and data hub architectures
\n
• Build and support end-to-end data pipelines (ingestion transformation reporting) using Azure services
\n
• Work hands-on with tools including ADF, Synapse, ADLS and Microsoft Fabric
\n
• Develop and optimise dimensional data models (Kimball / star schema) for analytics and reporting
\n
• Provide technical guidance and support to BI Developers during delivery (non-managerial)
\n
• Contribute to Power BI / semantic layer design to support enterprise reporting
\n
• Support integration of data from multiple SaaS and third-party systems
\n
• Ensure best practices across data quality, governance, metadata, and performance optimisation
\n
• Maintain documentation including data models, data dictionaries, and architecture diagrams
\n
• Assist with CI/CD pipelines and deployment processes (Azure DevOps)
\n

Profile

\n
• Proven experience as a hands-on Data Architect or Senior Data Engineer operating at architecture level - strong Azure expertise across:
\n

\n
• Azure Data Factory (ADF)
\n
• Azure Synapse / Azure SQL
\n
• Azure Data Lake (ADLS)
\n
• Exposure to Microsoft Fabric (highly desirable)
\n

\n
• Strong background in data warehousing and BI environments
\n
• Excellent dimensional modelling (Kimball) experience
\n
• Experience working closely with BI / reporting teams (Power BI, semantic models, DAX)
\n
• Confident working across end-to-end data pipelines and integration patterns
\n
• Strong SQL skills with experience optimising queries and datasets
\n
• Comfortable guiding and supporting developers without formal leadership responsibility
\n
• Exposure to metadata management, data governance, and data quality frameworks
\n
• Experience with CI/CD (Azure DevOps, Gi t) and ideally scripting (Python / PySpark)
\n

Job Offer

\n
• £700-£800 per day (Inside IR35)
\n
• Hybrid working (2-3 days in London)
\n
• Initial 6-month contract with extension potential
\n