Business Intelligence Analyst -Job Ref 196331 NEW

Watford, Hertfordshire
Forsyth Barnes

Business Intelligence Analyst – Job Ref (phone number removed)
Watford – 3/4 days per week

Salary – 50k – 60k

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.

Job Description

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.

Other

• 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.