Cefetra Ltd
AI, Data & Automation Intern
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
AI, Data & Automation Intern
The Organisation
Part of Cefetra Group, Cefetra Limited is one of the major traders of grains and animal feed raw materials in the UK and Ireland. With long-term arrangements at strategically selected import facilities with a specialised network of suppliers, objective market analysis and a trusted approach to quality and sustainability, it is ideally positioned to meet customer requirements whilst reducing risk and increasing efficiency.
With 700,000 tonnes of storage capacity supported by state-of-the-art processing technology, the business dispatches between 85,000 – 90,000 tonnes of raw materials to industry partners every week and delivers up to 600 lorry loads per day. Its products are used for animal feed and throughout the food and drink sector, supplying product to some of the largest food producers in sectors such as dairy, beef, lamb, poultry, pork, salmon, beer, bread, biscuits, breakfast cereals, and pet food.
Parent organisation ‘Cefetra Group’ delivers more than 25 million tonnes of agri-feed per annum and is Europe’s largest agri-service and trading business, serving customers from its 29 offices in 19 different countries, with revenues of over €4 billion.
The Opportunity
We are looking for two part-time AI, Data & Automation Interns to support work across data, reporting, automation, AI-assisted solution delivery, and internal business systems.
This role is ideal for students, recent graduates, or early-career candidates who are curious, technically minded, organised, and comfortable using AI tools to solve practical business problems. We are looking for a commitment of 20 hrs per week.
You will support a busy data and automation function that works across reporting, Power BI, SQL, Power Platform, business process improvement, system integrations, AI prototypes, documentation, and production support.
We do not expect candidates to be experts in every area. One successful candidate may be stronger in data, BI, reporting, and automation, while another may be stronger in AI-assisted prototyping, coding, testing, and solution delivery. Both roles require good judgement, clear communication, careful documentation, and a willingness to learn quickly.
A key part of the role will involve helping colleagues take ideas or AI-generated prototypes — for example, solutions built with Claude, Codex, ChatGPT, Copilot, or similar tools — and support their journey toward reliable, maintainable, production-ready solutions under appropriate supervision.
About the Role
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Depending on your skills and the needs of the team, responsibilities may include:
- Supporting colleagues who are experimenting with AI-assisted tools, prototypes, automations, or scripts.
- Helping turn rough ideas, prompts, and prototypes into clearer requirements and practical next steps.
- Reviewing AI-generated or AI-assisted outputs critically, rather than accepting them at face value.
- Testing small apps, scripts, workflows, reports, or automations before they are used more widely.
- Identifying gaps, edge cases, assumptions, bugs, risks, or missing documentation in early-stage solutions.
- Supporting the movement of suitable prototypes toward production under supervision.
- Creating documentation, runbooks, support notes, test plans, and handover materials.
- Supporting SQL-based reporting, data checks, and simple analysis.
- Helping maintain, test, and improve Power BI reports and dashboards.
- Assisting with Power Automate, Power Apps, workflow, or integration improvements.
- Investigating data quality issues and summarising findings clearly.
- Mapping data sources, report ownership, refresh schedules, dependencies, and known issues.
- Helping organise backlog items, tickets, technical notes, and small delivery tasks.
- Reviewing manual processes and identifying opportunities for automation or AI-assisted improvement.
Role & Responsibilities – Key Outputs
Data, BI & Automation Support
This area may include:
- Writing or updating basic SQL queries.
- Checking data quality and investigating mismatched figures.
- Supporting Power BI reports and dashboards.
- Documenting data sources, report logic, refresh schedules, and dependencies.
- Helping with Power Automate or Power Apps changes.
- Creating process maps, support notes, and operational runbooks.
- Helping clean up backlogs of reporting, data, or automation requests.
- Supporting recurring reporting or data validation tasks.
AI-Assisted Solution Delivery
This area may include:
- Reviewing prototypes created with Claude, Codex, ChatGPT, Copilot, or similar tools.
- Helping colleagues clarify what problem a prototype is meant to solve.
- Testing AI-generated code, scripts, apps, workflows, or automations.
- Checking whether an AI-generated solution is reliable, secure, maintainable, and fit for purpose.
- Improving documentation around AI-assisted solutions.
- Helping create test cases, acceptance criteria, and deployment notes.
- Supporting handover from prototype into normal support and maintenance processes.
- Helping colleagues use AI tools more effectively and responsibly.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Example Tasks
You might be asked to:
- Review a prototype created by a colleague using Claude or Codex and summarise what needs fixing before it can be used more widely.
- Turn a rough AI-generated solution into a clearer backlog item with requirements, risks, assumptions, and next steps.
- Test whether an automation works across realistic scenarios and document the results.
- Add basic validation, logging, comments, or error handling to a small script or workflow.
- Document how a Power BI report is built and where its data comes from.
- Write a SQL query to compare source data against reporting outputs.
- Investigate why numbers differ between two reports.
- Create a runbook for a recurring data, reporting, or automation process.
- Map a manual business process and suggest where automation or AI could help.
- Prepare simple documentation or a demo for an internal AI-assisted workflow.
Knowledge and Skills
A strong candidate will be able to:
- Use AI tools confidently but not blindly.
- Break down vague business requests into clear tasks.
- Spot when a prototype is fragile, incomplete, insecure, or poorly documented.
- Communicate clearly with both technical and non-technical colleagues.
- Test their work properly before handing it over.
- Document work so that someone else can understand and maintain it.
- Escalate risks, uncertainty, or production concerns rather than guessing.
- Balance curiosity and experimentation with care, structure, and reliability.
Experience with any of the following would be helpful:
- AI Tools: ChatGPT, Claude, Codex, GitHub Copilot, or other AI tools.
- Prompting: Prompting AI tools effectively.
- Databases: SQL.
- Programming: Python, JavaScript or TypeScript.
- Business Intelligence: Power BI, Excel.
- Power Platform: Power Automate, Power Apps.
- DevOps: Azure DevOps, Git or GitHub.
- Integrations: APIs and integrations.
- Quality Assurance: Testing and debugging.
- Data Modelling: Data modelling basics.
You do not need to have all these skills. We are more interested in evidence that you can learn quickly, work carefully, and use technology thoughtfully to solve real problems.
Working Arrangement
- Number of roles: 2
- Hours: Approximately 20 hours per week
- Location: Glasgow/Hybrid
- Duration: 3 months / 6 months / 1 to 2 years/possible perm roles
- Reporting to: Data Engineer
To Apply
Email your CV to careers@cefetra.co.uk
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills