> Markdown version of [/jobs/ext/2466366-automation-integration-specialist](https://www.wearedevelopers.com/jobs/ext/2466366-automation-integration-specialist). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Automation & Integration Specialist

- **Company:** Dhillons Brewery Ltd
- **Location:** Coventry, UK
- **Salary:** £30,000.0 - £35,000.0
- **Contract:** Temporary contract
- **Skills:** JavaScript (Programming Language), Application Programming Interfaces (APIs), Python (Programming Language), Automation of Marketing, Power BI, Scripting, Google Data Studio, Zapier, Nintex, Gsuite, Api Management
- **Published:** August 10, 2026
- **Apply:** https://uk.indeed.com/viewjob?jk=7c92b442dd487c9d

## About the Role

* Proven experience with Square API and/or OpenTable API integrations
 * Strong experience with automation platforms (Zapier, Make.com, n8n) or custom API integration work
 * Experience building financial forecasting tools or models is a strong plus
 * Comfortable working with hospitality/retail POS data
 * Able to translate a rough brief into a working, reliable system
 * Good communicator - able to explain technical setup to a non-technical team
 * Bonus: dashboarding tools (Google Sheets, Looker Studio, Power BI) or scripting (Python/JavaScript)

## Description

Job Title: Automation Consultant / Integration Specialist (Hospitality Reporting & Forecasting) - Contract, We need someone to build an automated daily reporting system pulling data from our Square POS and OpenTable accounts, plus a cash flow forecasting tool that brings together our funding facilities, repayment schedules, and incoming revenue. This starts with a single venue as a pilot, rolling out across our full venue portfolio (5+ sites) once proven.

What you'll be doing

Phase 1 - Reporting automation

 * Connect Square's API to pull daily sales, margin, and product-level data
 * Connect OpenTable to pull booking, covers, and retention data
 * Build automated workflows (Zapier, Make.com, or custom scripts) to combine and process this data
 * Deliver a daily summary report (email/WhatsApp/dashboard - TBD) with key metrics and anomaly flags
 * Document the setup so our team can maintain or extend it

Phase 2 - Rollout & forecasting

 * Extend the reporting system across all venues
 * Build a cash flow forecasting tool covering multiple facilities, repayment schedules, and revenue projections, giving weeks-ahead visibility rather than reactive reporting