| Description: |
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.
 |
