Data Lead

Opvia; India; Remote; INR 1,200,000 - 3,200,000; Full time

Job summary

Opvia is hiring a hands-on Data Lead to own the data architecture, quality, governance and reporting for a wellness brand operating across the UK and US. You will build and lead a small team, manage data pipelines across e-commerce, retail and finance, and enable AI-powered analysis with trusted data.

You will implement a Snowflake warehouse, dbt transformations and robust governance, while driving measurable improvements in data availability, reporting accuracy and business decision-making.

Qualifications

• Five or more years in data engineering or analytics with team leadership.
• Hands-on Snowflake production experience.
• Strong dbt experience across modelling, testing and deployment.
• Advanced SQL and practical Python for pipelines.
• Experience building integrations (Fivetran, Airbyte or custom connectors).
• Experience with retail EPOS or syndicated market data preferred.
• Track record of building and managing data teams.
• Experience in data governance, access controls and metrics definitions.

Responsibilities

• Own data quality, definitions and availability across the business.
• Establish core metric definitions (revenue, margin, CAC, retention).
• Set governance and access controls to protect sensitive data.
• Implement testing and reconciliation between reporting and source/Finance.
• Develop reliable self-service reporting for recurring questions.
• Lead Snowflake warehouse implementation with partners.
• Design raw, cleaned and modeled data layers for reporting and planning.
• Own dbt transformation layer including model development and deployment.
• Build pipelines across e-commerce, retail, CRM, finance and ops.
• Monitor pipeline reliability, freshness and cost; resolve data issues.
• Leverage AI coding tools with human review for speed and quality.
• Consolidate UK/US retailer data and syndicated market data.
• Collaborate with retailer portals (Circana, NielsenIQ, SPINS, Numerator).
• Move reporting from spreadsheets to warehouse-backed dashboards.
• Train teams to query data and use reporting tools.

Skills

Snowflake

dbt

SQL

Python

Fivetran

Airbyte

AI tools (Claude/Copilot)

Data governance

Data modelling

Data warehousing

Tools

Snowflake

dbt

SQL

Python

Fivetran

Airbyte

BigQuery

Google Cloud

Power BI

Looker

Job description

Scope: UK and US markets, across all business functions

Preference: Candidates with experience supporting UK businesses or working with UK market data.

About the Role

Data Lead

Employment Type: Full-time

Reporting to: Head of AI Transformation

Scope: UK and US markets, across all business functions

Preference: Candidates with experience supporting UK businesses or working with UK market data.

About the Role

We are hiring a hands-on Data Lead for a fast-growing wellness beverage brand operating across the UK and US.

You will take ownership of the company’s data architecture, quality, governance and reporting, bringing information from sales, marketing, retail, finance and supply chain systems into a reliable central warehouse.

This is a build-and-lead role. You will work directly on architecture, pipelines and data models while building and managing a small team, including offshore data engineers. You will help establish consistent business metrics and enable teams to use trusted data for reporting, planning and AI-powered analysis.

Key Responsibilities

Data Ownership and Governance

• Own data quality, definitions and availability across the business.
• Establish consistent definitions for core metrics, including revenue, contribution margin, customer acquisition cost and retention.
• Set access controls and governance standards to protect sensitive business and customer information.
• Implement testing and reconciliation processes to ensure reporting matches source systems and Finance.
• Turn recurring business questions into reliable, self-service reporting.

Data Architecture and Engineering

• Lead the implementation of a Snowflake warehouse alongside implementation partners.
• Design raw, cleaned and modelled data layers that support reporting, planning and analysis.
• Own the dbt transformation layer, including model development, testing, documentation and deployment.
• Build and maintain pipelines connecting e-commerce, marketplace, advertising, CRM, finance and operations systems.
• Assess existing BigQuery infrastructure and plan its migration or integration with Snowflake.
• Monitor pipeline reliability, freshness and cost, resolving the root causes of data issues.
• Use AI coding tools to accelerate development, testing and documentation, with appropriate human review.

Retail and Commercial Analytics

• Consolidate UK and US retailer sales, EPOS, distribution and syndicated market data.
• Work with retailer portals and data providers such as Circana, NielsenIQ, SPINS and Numerator.
• Automate manual data imports wherever source systems and permissions allow.
• Combine retail, DTC and marketplace data to provide a clear view of performance by product, channel and market.
• Enable reporting on rate of sale, distribution, promotions and market share.
• Support analysis of how marketing activity influences retail sales.

Team and Partner Management

• Hire, manage and develop a small data team, including remote or offshore engineers.
• Establish standards for code reviews, documentation, testing and delivery.
• Maintain a prioritised roadmap based on business impact.
• Manage implementation partners and data vendors against clear deliverables.

Business Reporting and AI Enablement

• Move recurring reporting from manual spreadsheets to warehouse-backed dashboards and reports.
• Work closely with Digital, Finance, Commercial and Supply Chain teams to understand their needs.
• Prepare clean, documented data models that people and authorised AI tools can query reliably.
• Present findings clearly to non-technical stakeholders.
• Train teams to use reporting tools and answer their own business questions.

Required Skills and Experience

• Typically five or more years of experience in data engineering, analytics engineering or related roles, including team leadership.
• Hands-on production experience with Snowflake.
• Strong dbt experience, covering modelling, testing, documentation and deployment.
• Advanced SQL and practical Python skills for pipelines and automation.
• Experience building integrations using Fivetran, Airbyte or custom connectors.
• Experience working with retail EPOS, retailer portal or syndicated market data.
• A track record of building and managing data teams.
• Experience implementing data governance, access controls and consistent metric definitions.
• Regular use of AI development tools such as Claude, Cursor or GitHub Copilot, with the ability to validate their output.
• Strong attention to detail and a disciplined approach to checking and reconciling numbers.
• Clear communication skills and confidence working with technical and non-technical stakeholders.
• Experience working with UK businesses, UK retail data or UK consumer markets is preferred.

Good to Have

• Experience in e-commerce, DTC, FMCG, food, beverages or wellness.
• Familiarity with Shopify, Amazon, TikTok Shop and advertising platform data.
• Experience with BigQuery, Google Cloud or warehouse migrations.
• Experience managing offshore or remote data engineers.
• Experience connecting warehouses to planning, forecasting or finance tools.
• Experience connecting AI assistants or LLMs to company data.
• Familiarity with Power BI, Looker or similar BI platforms.
• Exposure to US retail and marketplace data.

You do not need experience with every tool listed. We are interested in what you have built, how you lead and how you solve business problems using data.