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.
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)
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, Gi t) and ideally scripting (Python / PySpark)
Job Offer
- £700-£800 per day (Inside IR35)
- Hybrid working (2-3 days in London)
- Initial 6-month contract with extension potential
#J-18808-Ljbffr
BI Architect in London employer: Energy Jobline ZR
Energy Jobline ZR is an excellent employer for Structural Engineers, offering a vibrant work culture in the heart of Shoreditch. With a focus on innovation and collaboration, employees benefit from competitive salaries, professional development opportunities, and the chance to work on exciting projects from concept to completion within a supportive team environment.
