Senior Analytics Engineer

Opvia; India; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Opvia is hiring a Senior Analytics Engineer in India to design and maintain scalable data pipelines for analytics and reporting. You will work hands-on with Snowflake, dbt, SQL and Python to transform data from multiple sources and deliver reliable insights.

You will collaborate with UK stakeholders across commercial, finance and marketing to optimise data infrastructure, improve decision making and support BI initiatives.

Qualifications

• 5+ years hands-on experience in data engineering or analytics engineering.

Responsibilities

• Design, develop and maintain scalable ETL/ELT pipelines integrating data from multiple sources.
• Build and optimise data transformations using SQL, dbt and Snowflake.
• Develop structured data models, including fact and dimension tables, for analytics and reporting.
• Use Python for data processing, automation, validation and troubleshooting.
• Implement data quality checks, pipeline monitoring and automated testing.
• Optimise warehouse performance, query efficiency and cloud infrastructure costs.
• Support data migrations and modernisation of existing data platforms.
• Develop reliable reporting datasets and support BI dashboards.
• Implement Git‑based development, code reviews and CI/CD practices.
• Work directly with UK stakeholders and independently manage technical delivery.

Skills

SQL

Snowflake

dbt

Python

ETL/ELT pipelines

Data modelling

Data quality

Git

CI/CD

Stakeholder management

Tools

Fivetran

Airbyte

AWS Glue

Azure Data Factory

Airflow

Databricks

Kafka

Job description

SQL | Snowflake | dbt | Python | ETL/ELT | Data Engineering

Location: India

Employment Type: Full-time

Working Hours: Aligned with UK business hours

Experience: 5+ years in data engineering, analytics engineering or related roles

About the opportunity

Opvia is hiring a Senior Analytics Engineer to work closely with a UK wellbeing and ecommerce brand.

We are looking for a hands‑on data professional with strong experience in Snowflake, dbt, SQL and cloud data engineering to build reliable data pipelines, scalable data models and reporting solutions.

You will collaborate with UK stakeholders across commercial, finance, marketing and operations teams to improve data infrastructure and support business decision-making.

What you will do

• Design, develop and maintain scalable ETL/ELT pipelines integrating data from multiple sources.
• Build and optimise data transformations using SQL, dbt and Snowflake.
• Develop structured data models, including fact and dimension tables, for analytics and reporting.
• Use Python for data processing, automation, validation and troubleshooting.
• Implement data quality checks, pipeline monitoring and automated testing.
• Optimise warehouse performance, query efficiency and cloud infrastructure costs.
• Support data migrations and modernisation of existing data platforms.
• Develop reliable reporting datasets and support BI dashboards.
• Implement Git‑based development, code reviews and CI/CD practices.
• Work directly with UK stakeholders and independently manage technical delivery.

What we are looking for

• 5+ years of hands‑on experience in data engineering or analytics engineering.
• Advanced SQL skills, including CTEs, window functions, complex transformations and query optimisation.
• Strong Snowflake experience in data warehousing, modelling and performance optimisation.
• Hands‑on dbt experience with models, tests, documentation and deployment.
• Proven experience building and maintaining production ETL/ELT pipelines.
• Python experience for data processing, automation and integration.
• Strong understanding of dimensional modelling, data architecture and data quality.
• Experience with AWS, Azure or GCP.
• Familiarity with data ingestion tools such as Fivetran, Airbyte, AWS Glue or Azure Data Factory.
• Experience with Git, CI/CD and production deployment practices.
• Exposure to Power BI, Tableau, ThoughtSpot or similar reporting tools.
• Strong problem‑solving, communication and stakeholder management skills.
• Ability to work independently with UK‑based teams.

Good to have

• Experience with PySpark, Databricks or Apache Spark.
• Familiarity with Apache Airflow or other orchestration tools.
• Experience migrating legacy pipelines to modern cloud platforms.
• Exposure to Kafka, CDC, data observability or automated monitoring.
• Experience with ecommerce, retail, commercial analytics or high‑volume transactional data.
• Experience optimising cloud infrastructure and warehouse costs.
• Experience mentoring engineers or leading technical delivery.

You do not need experience with every tool listed. We value strong engineering fundamentals, hands‑on technical expertise, ownership and the ability to learn.

• Work closely with a UK wellbeing and ecommerce brand.
• Own meaningful projects across data engineering, modelling and analytics.
• Work with modern technologies such as Snowflake, dbt and Python.
• Collaborate directly with stakeholders and influence business decisions.
• Help build scalable, reliable and efficient data infrastructure.