Business Intelligence (BI) Reporting Specialist

Salary: £ 30 - 35,000 per annum depending on experience

Location: Wilkin & Sons Ltd, Tiptree, Colchester

Working Hours: 9.00am to 5.00pm, Monday to Friday

The Wilkin family have been farming at Tiptree, Essex, since 1757, and making quality preserves there since 1885. We grow a wide range of traditional English fruits and use them to make conserves, condiments, and other treats in our nut-free factory by the farm. Our products are made to cherished recipes and are free from artificial colours and flavours. We supply an extensive range of products to over sixty countries across the world, and are available in fine retailers, premium hotels, and quality airlines.

For generations, Wilkin & Sons has been synonymous with quality and tradition, crafting exceptional preserves and fine foods. Now, we’re seeking a talented and driven Business Intelligence (BI) Analyst to join our team at our historic Tiptree site! If you’re passionate about transforming data into actionable insights and empowering our team with impactful reports, we want to hear from you.

About the Role:

As our BI Analyst, you’ll be instrumental in shaping our future by leveraging data to enhance our operations and strategic decision-making. You 'll design, develop, and maintain BI solutions, ensuring data integrity and providing crucial insights to support our continued success. You’ll work with tools like Infor BIRST, Power BI, and SQL, and collaborate with various departments to translate business needs into effective reporting solutions - all within the unique environment of our renowned Tiptree site.

What You’ll Do:

• Reporting & Dashboards: Create visually compelling reports and dashboards using Power BI, Infor BIRST, and Excel, providing clear insights into our business performance.
• Data Management: Write and maintain SQL queries, optimise data models, and ensure data accuracy across our ERP, Microsoft 365, and other systems.
• System Maintenance: Monitor and troubleshoot data issues, manage reporting environments (Dev, UAT, Live), and ensure version control.
• Stakeholder Collaboration: Gather requirements, provide technical guidance, and present data-driven insights to stakeholders across our organisation.
• Data Governance: Ensure compliance with data security protocols, GDPR, and Wilkin & Sons’ internal policies.
• Training & Support: Train end-users on BI tools and provide timely resolution to queries.

What You 'll Do:

• Reporting & Dashboards : Develop visually compelling, accurate, reliable, and insightful reports and dashboards using Power BI, Excel, and Infor BIRST (training available for the right candidate) to support data-driven decision-making across the organisation.
• Data Management: Write and optimise queries, enhance data models, and ensure data accuracy across ERP, Microsoft Dataverse, Microsoft 365 (SharePoint and Lists), and other systems.
• System Maintenance: Monitor and troubleshoot data issues, manage reporting environments (Dev, UAT, Live), and maintain version control.
• Stakeholder Collaboration: Gather reporting requirements, provide technical guidance, and present data-driven insights to business users.
• Data Governance: Ensure compliance with GDPR, data security protocols, and Wilkin & Sons’ internal policies.
• Training & Support: Train end-users on BI tools and provide timely resolution to queries.

What You 'll Bring:

• At least 2 years ’ experience in BI reporting, data analysis , or a similar role.
• Proficiency in data modelling, and reporting tools (SQL, MS Dataverse, Power BI, Excel, and ideally Infor BIRST --but we’re happy to upskill the right person).
• Experience working with ERP systems (e.g., Infor M3) and Microsoft 365 .
• Strong problem-solving, communication, and organisational skills.
• Knowledge of data warehousing, IT security, and compliance standards .
• A proactive attitude and commitment to continuous learning.
• Ability to work on-site at our Tiptree Factory .

Key Skills:

• SQL, ETL, Data Modelling
• Power BI, Infor BIRST, Excel
• Data Quality & Governance
• System Maintenance & Troubleshooting
• Stakeholder Communication

Why Join Wilkin & Sons?

• Be part of a company with a rich heritage and a commitment to quality
• Opportunity to make a real impact on a well-established and respected brand
• Contribute to a company that values data-driven insights and continuous improvement.
• Work in the beautiful surroundings of the Tiptree Factory and Farm
• Annual bonus subject to profitability
• 25 days paid holiday, plus bank holidays
• 25% discount card for our Jam shop and 8 tea rooms
• Westfield Health cash health care plan with 24/7 doctor line, prescriptions, cash back on medical treatments, counselling and legal advice line
• Employee-owned share incentive scheme
• Reduced Gym membership to Atlantis Gym, Tiptree and nationwide gyms
• Employee events and family days
• A friendly and supportive working environment

Ready to Contribute to Our Story?

If you’re a detail-oriented, proactive BI professional with a passion for data and an appreciation for tradition, apply now!

Job Types: Full-time, Permanent

Pay: £30,000.00-£35,000.00 per year

Additional pay:

• Yearly bonus

Benefits:

• Canteen
• Company events
• Company pension
• Employee discount
• Employee stock ownership plan
• Enhanced maternity leave
• Free parking
• Health & wellbeing programme
• On-site parking
• Profit sharing
• Sick pay
• Store discount

Schedule:

• Monday to Friday
• No weekends

Ability to commute/relocate:

• Colchester CO5 0RF: reliably commute or plan to relocate before starting work (required)

Application question(s):

• Please tell us about your familiarity with ERP systems (e.g., Infor M3) and their integration with BI platforms.
• Please explain your understanding of Microsoft 365 and its relationship with BI tools and data management.
• What is your understanding of data warehousing concepts and best practices for data storage and retrieval?
• What is your understanding of IT security, compliance standards, and legal frameworks governing data management?
• What is your exposure to Agile methodologies and IT frameworks?

Experience:

• working with business intelligence tools: 2 years (required)
• supporting reporting solutions in an organisational setting: 2 years (required)
• technical proficiency in SQL: 1 year (required)
• data modelling: 1 year (required)
• managing reporting environments (e.g., Dev, UAT, Live): 1 year (required)
• Infor BIRST: 1 year (required)
• developing reports and dashboards using Power BI, and Excel: 1 year (required)

Work authorisation:

• United Kingdom (required)

Work Location: In person

Application deadline: 28/03/2025