Operations Data & Automation Engineer – Supply Chain & Finance

Opvia; India; Remote; INR 1,000,000 - 1,600,000; Full time

Job summary

Opvia is hiring an Operations Data & Automation Engineer to support a UK consumer goods partner. You will manage data pipelines, enhance stock and finance reporting, and automate manual tasks across supply chain and month-end processes.

The role focuses on preparing data for a Snowflake migration and improving data reliability. This hands-on IC role requires ownership of production data jobs, investigations of discrepancies, and successful delivery of operational automations used by business

Qualifications

• Hands-on SQL and Python in a recent role.
• Experience owning scheduled production data jobs.
• Data reconciliation with a source of truth (warehouse/ledger).
• Automation delivered that replaced manual spreadsheet work.
• Knowledge of Azure Functions, App Service, Key Vault, monitoring and alerts.
• Advanced Excel (Power Query) plus Google Sheets & Apps Script.
• APIs, system integrations and n8n or similar workflow tools.
• Git/GitHub for version control and handover.

Responsibilities

• Maintain an Azure SQL reporting database and automation workflows (Python Azure Functions, Google Apps Script, n8n).
• Monitor jobs, add failure alerts and data freshness checks, resolve root causes.
• Maintain stock and order integrations with Shopify, TikTok Shop, warehouses and EDI partners.
• Support stock reconciliation and month-end reporting against warehouse and finance records.
• Load and validate monthly forecast versions; identify missing rows and date issues.
• Replace repetitive Excel processes with Python, n8n or Office Scripts with human review.
• Clean and standardise SKU, customer, region and currency data before Snowflake migration.
• Document deployment steps, keep scripts in GitHub and manage credentials securely.
• Build simple dashboards and internal tools with Supply Chain and Finance teams.

Skills

Strong SQL

Python

Azure Functions

Data pipelines

n8n

Git/GitHub

Excel/Power Query

APIs

Tools

Azure SQL

Google Apps Script

Snowflake

dbt

Office Scripts

Job description

Operations Data & Automation Engineer – Supply Chain & Finance

SQL | 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 opportunity

Opvia 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

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