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.
About the Role:
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.
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 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.
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 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
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
Benefits:
- 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
Ability to commute/relocate:
- Colchester CO5 0RF: reliably commute or plan to relocate before starting work (required)
Application question(s):
- How many years of experience do you have building reports and dashboards using Power BI (or a comparable tool) in a business environment?
- Do you have hands-on experience working with ERP systems (e.g. SAP, Microsoft Dynamics, Infor)?
- Briefly describe a data-related challenge you have solved using SQL or a similar query language.
- How do you approach working with imperfect or incomplete data to ensure accuracy and consistency in reporting?
- How do you manage stakeholder expectations when delivering reports or data insights?
- Describe a scenario where you used data to drive or support a business decision.
- In one sentence, why do you believe you are a strong fit for this role?
- Do you currently require, or will you in the future require, sponsorship to work in the UK? Yes/No
Work Location: In person
