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 centres 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