Michael Page
BI Architect
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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)
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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, Git) and ideally scripting (Python / PySpark)
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Job Offer
- £700-£800 per day (Inside IR35)
- Hybrid working (2-3 days in London)
- Initial 6-month contract with extension potential
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills