BI Architect

• Hands-on architecture role with real delivery impact
• Work closely with developers on a modern Azure data platform

About Our Client

A well-established UK-based international investment organisation with a global footprint, delivering impactful programmes across multiple regions.

Job 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)

The Successful Applicant

• 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)

What's on Offer

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

Contact

Hannah Kelly

Quote job ref

JN-062026-7047653

Phone number

+44 7989225567

Job summary

• Job function
• Technology

• Subsector
• IT Architecture

• Sector
• Financial Services

• Where
• City of London

• Contract type
• Temporary

• Consultant name
• Hannah Kelly

• Consultant phone
• +44 7989225567

• Job reference
• JN-062026-7047653