Data Engineer – Supply Chain & AutomationLocation: Remote, India
Experience:
2–5 years Compensation: ₹18–24 LPA, depending on experience
Working hours
At least four hours of daily overlap with UK
working hours
Engagement: Full-time through Opvia Joining: As soon as possible; notice period of up to 30 days preferred About the opportunityOpvia is hiring a Data Engineer – Supply Chain & Automation to work with a fast-growing UK wellness and consumer brand with international operations. You’ll own the data jobs, integrations and automations that support supply chain and operational decision-making. This includes keeping stock, order and forecast data accurate, maintaining reliable production pipelines and replacing manual spreadsheet work with practical automated solutions. We’re looking for someone with hands-on SQL and Python experience, experience working with supply chain or operational data, and a track record of owning scheduled data jobs in production. You should also be comfortable using AI coding tools to build, troubleshoot and validate your work. This is an individual contributor role with no direct reports. You’ll work closely with the AI Transformation and Data teams, Supply Chain, Finance, and UK operations colleagues. What you’ll doOwn production data jobs and integrations
• Maintain and improve an Azure SQL reporting database, Python Azure Functions, Google Apps Script jobs and n8n workflows.
• Support order and stock feeds from inventory systems, ecommerce platforms, third-party warehouses and EDI partners.
• Investigate failed jobs, missing records, duplicate transactions and inconsistent data, resolving the underlying cause.
• Implement failure alerts, data freshness checks and validation controls so issues are identified promptly.
• Improve secrets management using Azure Key Vault and maintain appropriate access controls.
• Keep scripts and workflows in GitHub, with clear deployment notes and troubleshooting documentation. Improve supply chain data quality
• Reconcile inventory and operational data against warehouse reports, finance records and other agreed sources of truth.
• Investigate discrepancies across stock movements, orders, production transactions and month-end reporting.
• Clean and standardise master data, including SKUs, customers, regions and currencies.
• Work with Supply Chain and Finance to ensure datasets are complete, accurate and suitable for reporting.
• Maintain data definitions and a transparent, current data dictionary. Support month-end and forecasting
• Build and maintain data workflows supporting stock reconciliation, finance snapshots and month-end reporting.
• Load and validate rolling forecast versions, checking for missing rows, invalid dates and inconsistent values.
• Automate repetitive spreadsheet steps to reduce manual effort and improve reliability.
• Preserve human approval before automated processes post changes to stock or finance systems.
• Help shorten the month-end reporting cycle by improving the data and automation supporting it. Support the move to Snowflake
• Prepare operational datasets for a planned migration to Snowflake.
• Work with the Data Lead and implementation partner to clean, document and validate data.
• Support testing and reconciliation so migrated datasets remain consistent with their source systems.
• Contribute to maintainable data transformations and workflows as the platform develops. Build practical automation and reporting
• Use Python, n8n, Google Apps Script or similar tools to automate operational processes.
• Build useful dashboards and internal tools that help teams identify exceptions and take action.
• Use AI coding tools such as Claude Code, Codex or Cursor to support development, debugging and documentation.
• Validate generated code and keep stock calculations, financial calculations and reconciliation rules deterministic and testable.
• Document processes and communicate changes before modifying reports or workflows that colleagues rely on. Must-have qualifications
• Relevant
experience:
Typically 2–5 years in data engineering, analytics engineering, BI engineering or a similar hands-on data role.
• Supply chain or operations exposure: Experience working with physical inventory, stock, orders, production, fulfilment or forecasting data.
• Strong SQL: Ability to write joins, aggregations and transformations, investigate discrepancies and validate datasets. Experience with SQL Server or Azure SQL is particularly relevant.
• Hands-on Python: Experience building and maintaining data jobs, integration scripts or operational automations.
• Production ownership:
Experience owning scheduled data jobs, monitoring their performance and resolving failures or incorrect outputs.
• Microsoft Azure fundamentals: Working familiarity with Azure Functions, App Service, Key Vault, monitoring and alerts.
• Advanced Excel: Practical experience with Power Query and spreadsheet-based data cleaning, analysis and reconciliation.
• Google Sheets and Apps Script: Experience maintaining or building scripts that automate data processing and reporting.
• APIs and integrations: Experience moving data between business systems and troubleshooting incomplete or inconsistent transfers.
• Workflow automation: Experience with n8n or a comparable automation platform.
• Git and GitHub: Experience versioning code and maintaining documentation that allows others to run and support your work.
• Practical AI coding
experience:
Use of Claude Code, Codex, Cursor or similar tools to build or troubleshoot real work, with checks to verify accuracy.
• Communication and ownership: Clear written English, independent problem-solving and confidence working with Supply Chain, Finance and technical colleagues.
• Availability for at least four hours of daily overlap with UK
working hours
. Preferred qualifications
• Experience in FMCG, food and beverage, consumer goods, retail or D2C.
• Experience with Snowflake, dbt or a cloud data platform migration.
• Familiarity with Unleashed, Xero, Shopify or TikTok Shop.
• Experience with EDI platforms, such as SPS Commerce or Transalis.
• Experience working with third-party warehouses, logistics providers or manufacturing partners.
• Experience with Power BI or Looker.
• Familiarity with demand planning tools and monthly forecasting cycles.
• Experience using Office Scripts or VBA.
• Exposure to MCP or AI-assisted internal tools.
• Relevant Azure or Snowflake certifications.
• A degree in Computer Science, Engineering, Mathematics, Statistics or a related field is welcome but not essential. What success looks like
• Scheduled data jobs have reliable failure alerts and freshness checks.
• Stock, order and forecast data reconcile accurately with source records.
• Month-end and forecasting processes require fewer manual steps.
• Operational data is clean and documented for the Snowflake migration.
• Scripts and automations are version-controlled, documented and easy to support.
• Improvements deliver measurable reductions in manual effort and recurring errors.
📌 Data Engineer – Supply Chain (India)
🏢 Opvia
📍 India