Business Intelligence Analyst -Job Ref 196331
3 days ago
Watford
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