> Markdown version of [/jobs/ext/2457560-bi-architect](https://www.wearedevelopers.com/jobs/ext/2457560-bi-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# BI Architect

- **Company:** Michael Page
- **Location:** London, UK
- **Experience:** Expert
- **Salary:** £182,000.0 - £208,000.0
- **Contract:** Temporary contract
- **Skills:** Microsoft Azure, Business Intelligence Development, Software as a Service, Cloud Database, Continuous Integration, Data Architecture, Data Dictionary, Data Governance, Data Hub, Data Integration, Data Systems, Data Warehousing, Database Queries, Python (Programming Language), Metadata, Meta-Data Management, SQL Azure, Performance Tuning, Power BI, Azure Active Directory, Azure Data Lake, Scripting, Azure Data Factory, Microsoft Fabric, Pyspark, Star Schema, Azure Synapse Analytics, Data Pipelines
- **Published:** August 12, 2026
- **Apply:** https://www.michaelpage.co.uk/job-detail/bi-architect/ref/jn-062026-7047653?ng-src=other-users-applied&ng-jn=job-search

## About the Role

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

## 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, * 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)


## Related Videos

- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata)
- [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)

## Related Articles

- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)