Operations Data & Automation Engineer – Supply Chain & FinanceSQL | Python | Azure | Data Reliability | Workflow Automation
Location: Remote, India
Engagement: Full-time contractor through Opvia
Working Hours: UK business hours
Experience: Typically 2–5 years in data engineering, analytics engineering or BI
Joining Preference: Immediate or up to 30 days’ notice
About the opportunityOpvia is hiring an Operations Data & Automation Engineer to work with a UK-based consumer goods business.
You will maintain reliable data pipelines, improve the accuracy of stock and finance reporting, and automate manual processes across supply chain, month-end reporting and forecasting. You will also help prepare operational data for a move to Snowflake.
This is a hands-on individual contributor role. We are looking for someone who has owned production data jobs, investigated discrepancies and delivered automations that business teams use.
What you will do
- Maintain an Azure SQL reporting database, Python Azure Functions, Google Apps Script jobs and n8n workflows supporting daily operations.
- Monitor scheduled jobs, add failure alerts and data freshness checks, and resolve recurring issues at their root cause.
- Maintain order and stock integrations across inventory systems, Shopify, TikTok Shop, third-party warehouses and EDI partners.
- Support stock reconciliation and month-end reporting, checking system figures against warehouse reports and finance records.
- Load and validate monthly forecast versions, identifying missing rows, incorrect dates and inconsistent inputs.
- Replace repetitive Excel processes with Python, n8n or Office Scripts, with human approval before changes post to stock or finance systems.
- Clean and standardise SKU, customer, region and currency data ahead of the Snowflake migration.
- Keep scripts in GitHub, document deployment steps and runbooks, and manage credentials securely using Azure Key Vault.
- Build simple dashboards and internal tools, working closely with Supply Chain, Finance and data specialists.
What we are looking for
- Robust SQL and Python, used hands-on in a recent role.
- Experience owning scheduled production data jobs, including diagnosing failures, validating outputs and safely rerunning loads.
- Experience reconciling data against a source of truth, such as warehouse stock reports or a finance ledger.
- Evidence of an automation that replaced manual spreadsheet work, with a clear before-and-after result.
- Working knowledge of Azure Functions, App Service, Key Vault, monitoring and alerts.
- Advanced Excel, including Power Query, plus practical experience with Google Sheets and Google Apps Script.
- Experience with APIs, system integrations and n8n or a similar workflow tool.
- Familiarity with Git and GitHub for version control and handover.
- Practical use of Claude Code, Codex, Cursor or similar tools to build and check work, while keeping financial and stock calculations rule-based.
- Careful validation habits: checking that data is complete and reconciles, beyond whether a job ran successfully.
- Clear written English, independent working habits and straightforward documentation.
Good to have
- Operations, supply chain or finance data experience, particularly stock, orders, forecasting and month-end.
- Experience in FMCG, food and drink, consumer goods, retail or D2C.
- Snowflake, dbt or involvement in a cloud data platform migration.
- Unleashed, Xero, Shopify or EDI platforms such as SPS Commerce or Transalis.
- Planning tools and experience supporting a monthly rolling-forecast cycle.
- Office Scripts, VBA, Power BI or Looker.
- Azure or Snowflake certifications and sound security practices.
You do not need every named platform. Hands-on SQL and Python, production job ownership, reconciliation and proven automation delivery are the priorities. Relevant shipped work matters more than a particular degree. Why join?
- Own practical improvements across supply chain and finance operations.
- See the impact of your work through fewer manual tasks, reliable reporting and faster month-end processes.
- Contribute to a Snowflake migration alongside experienced data specialists.
- Work remotely from India with regular collaboration across UK teams.
📌 Operations Data & Automation Engineer – Supply Chain & Finance (India)
🏢 Opvia
📍 India