BI Architect

Colart Group
Charing Cross, United Kingdom
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
£ 65K

Job location

Charing Cross, United Kingdom

Tech stack

Agile Methodologies
Power BI
Shopify
SQL Databases
Azure
Microsoft Fabric
Data Lake

Job description

You will design and deliver scalable BI results using Microsoft Fabric, OneLake and Power BI, partnering with teams across Sales, Marketing, Supply Chain, Finance and eCommerce to turn business needs into actionable solutions., Business Engagement & Analysis

  • Partner with stakeholders to understand requirements and translate them into analytical and reporting solutions.
  • Build strong knowledge of Colart's brands and commercial drivers to ensure insights align with business priorities.
  • Document and prioritise BI requirements to support data-driven decision-making.

Data & Platform (Microsoft Fabric)

  • Develop and maintain data pipelines, datasets and semantic models within Microsoft Fabric.
  • Use OneLake to ensure consistent, governed and accessible data across the organisation.
  • Contribute to the migration from legacy BI tools to a modern Fabric-based architecture.
  • Maintain data quality and governance standards throughout all BI assets.

Reporting & Visualisation (Power BI)

  • Build user-friendly, visually engaging Power BI dashboards tailored to different audiences.
  • Optimise reports for performance, scalability and intuitive use.
  • Enable and support self-service BI capabilities across the business.

Collaboration & Delivery

  • Work closely with BI Analysts, Data Engineers, Integration teams (M3, Shopify, PIM/DAM) and Technical Operations.
  • Support agile project delivery and contribute to the BI roadmap.
  • Drive continuous improvement of BI processes, tools and data models.

Requirements

  • Strong experience with Power BI (DAX, modelling, optimisation).
  • Hands-on experience with Microsoft Fabric (preferred) or Azure data tools.
  • Solid understanding of data lake architectures and SQL.
  • Knowledge of data modelling principles.
  • Commercial awareness with ability to link data to business outcomes.
  • Experience working with global, cross-functional teams.
  • Analytical mindset with attention to detail.
  • Previous experience of a manufacturing, supply chain or eCommerce environment would be advantageous.

About the company

At Colart our mission is to "inspire every artist in the world." We take pride in our heritage brands and the passionate people who bring them to life. We have 1000 employees across 13 countries and our products are sold in over 130 countries. Colart Group is the parent company of iconic art brands like Winsor & Newton, Liquitex, Lefranc Bourgeois, Conté à Paris, Charbonnel, Snazaroo and Reeves. We develop innovative products that inspire creativity at all levels, from professionals to hobbyists and students. Proudly B Corp certified, we are committed to sustainability with science-based carbon reduction targets, creating financial, environmental, and social value. Sustainability shapes our culture, reducing environmental impact and enhancing social contributions through community engagement and artist wellbeing. Diversity, Equity, and Inclusion: Many Voices. One Community. We are committed to being a company of choice, creating a workplace where every individual thrives, both professionally and personally.

Apply for this position