Business Intelligence; BI Developer & Data Analyst

Business Intelligence (BI) Developer & Data Analyst

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) Developer & Data 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.

As our Business Intelligence (BI) Developer & Data 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.

• 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.

• At least 1 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.

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

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

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

• Canteen
• Casual dress
• Company events
• Company pension
• Employee discount
• Employee stock ownership plan
• Enhanced maternity leave
• Enhanced paternity leave
• Free parking
• Gym membership
• Health & wellbeing programme
• On‑site parking
• Profit sharing
• Sick pay
• Store discount

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

In person