Operations Data & Automation Engineer

SQL | Python | Azure | Data Engineering | Automation

Location: Remote (India)

Working Hours: Minimum 4 hours overlap with UK business hours

Experience: Typically 2–5 years in data engineering, analytics engineering or BI

About the opportunity

Opvia is hiring an Operations Data & Automation Engineer to work closely with a UK-based consumer goods business. You will help maintain reliable data pipelines, improve reporting accuracy and automate manual processes across operations, supply chain and finance. This is a hands-on role combining data engineering, system integrations and practical business problem-solving.

What you will do

- Build, maintain and improve data pipelines using SQL, Python and Azure services.
- Manage scheduled data jobs, monitor failures and implement data quality checks and alerts.
- Integrate data from inventory systems, ecommerce platforms, warehouses and external APIs.
- Automate manual reporting, stock reconciliation and forecasting workflows using Python, Excel, Google Apps Script or n8n.
- Support month-end reporting, inventory reconciliation and data validation across business systems.
- Clean and standardise operational data for reporting and cloud data warehouse platforms such as Snowflake.
- Develop straightforward dashboards, reporting datasets and internal automation tools.
- Maintain code in GitHub, document workflows and troubleshoot production issues.
- Work with Operations, Supply Chain and Finance stakeholders to deliver reliable data solutions.

What we are looking for

- 2–5 years of experience in data engineering, analytics engineering, BI or a related role.
- Strong SQL skills, including complex queries,



CTEs, joins and query optimisation.
- Hands-on Python experience for data processing, automation and API integrations.
- Experience with Azure SQL or SQL Server and Azure services such as Functions, App Service or Key Vault.
- Advanced Excel skills, including Power Query, and experience with Google Sheets and Apps Script.
- Familiarity with REST APIs, webhooks and workflow automation tools such as n8n.
- Experience maintaining production data pipelines, troubleshooting failures and validating data accuracy.
- Familiarity with Git, GitHub and AI-assisted development tools such as Claude Code, Codex or Cursor.
- Strong attention to detail, clear English communication and the ability to work independently.
- Availability for at least four hours of daily overlap with UK business hours.

Good to have

- Experience with Snowflake, BigQuery, dbt or cloud data warehouse migrations.
- Familiarity with Shopify, Unleashed, Xero or EDI integrations.
- Experience in ecommerce, FMCG, retail, supply chain or inventory management.
- Exposure to Power BI, Looker, forecasting or financial reporting.
- Knowledge of cloud security, secrets management or advanced spreadsheet automation.
- You do not need experience with every tool listed. We value strong SQL and Python fundamentals, ownership of production workflows and the ability to learn new systems.

Why join?

- Work closely with a UK business on meaningful data and automation projects.
- Take ownership of data pipelines, integrations and operational reporting.
- Help modernise data infrastructure and reduce manual processes.
- Collaborate directly with stakeholders and see the impact of your work.

📌 Operations Data & Automation Engineer (India)
🏢 Opvia
📍 India