Back to search

BI Architect

City of London Temporary £700 - £800 per day View Job Description
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.
  • 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