Business Intelligence Analyst -Job Ref 196331 in London

Our client is undergoing a strategic transformation to unify an enterprise‑wide data and analytics ecosystem. As a leading player in the foods sector, this organization is integrating multiple ERP platforms into a single, scalable Azure‑based data platform, designed to deliver real‑time insights and data‑driven decision making across Commercial, Supply Chain, Finance and Operations. The BI & AI Solutions function is central to delivering high‑value reporting, analytics, and modern data capabilities that propel revenue growth, margin optimisation, inventory control, and operational excellence. This is a unique opportunity to contribute to a mature data strategy within a dynamic, consumer‑focused manufacturing environment.

We are seeking a seasoned Business Intelligence & Systems Analyst to join our client in Watford, operating in a hybrid model with four days in the office. The role centers on designing, building and refining BI reporting and analytics on a modern Azure data platform. You will translate business needs into scalable data solutions, optimise data models, and deliver dashboards that empower cross‑functional teams. In addition, you will mentor junior analysts and help uplift data modelling, reporting standards, and development practices across the BI team. This role is outcome‑focused, with a strong emphasis on driving revenue, margins and operational efficiency through data‑driven insights.

Key Responsibilities

• Design, develop, and maintain Power BI dashboards used across Commercial, Supply Chain, Finance, and Operations.
• Build and optimise data models using SQL, Power Query, and DAX.
• Transform, clean, and validate datasets to ensure high data quality and reliability.
• Deliver reporting solutions that provide clear insights into sales performance, margin, stock, and operational metrics.
• Identify and implement opportunities to automate reporting and manual processes.
• Develop and maintain Power Automate workflows to improve business efficiency.
• Document data logic, business rules, and reporting methodologies to ensure consistency and scalability.

Requirements

• 4+ years of BI or Data Analytics experience.
• Proficiency in SQL (joins, aggregations, ETL logic, stored procedures).
• Expertise in Power BI (modeling, DAX, visuals, Power Query).
• Strong data modelling concepts (facts/dimensions, relationships).
• Advanced Excel skills (formulas, pivots).
• Solid understanding of data warehousing and data flows.
• Experience mentoring junior team members.
• Analytical mindset with meticulous attention to detail.
• Excellent communication with both technical and non‑technical stakeholders.

Benefits

• Competitive compensation package with bonus potential.
• Comprehensive health and wellbeing benefits.
• Hybrid work model with four days in the Watford office and remote options.
• Clear career progression with mentoring and leadership development.
• Training and professional development opportunities.
• Inclusive, collaborative culture that values data‑driven decision making.

As part of a major ERP consolidation project and Azure‑based data ecosystem transformation, you will help drive a data‑centric culture across the organisation, enabling real‑time insights and informed decision making.