Business Intelligence Analyst -Job Ref 196331

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