Job title: Data engineer

Location: Hyderabad

Opella is the self-care challenger with the purest and third-largest portfolio in the Over-The-Counter (OTC) & Vitamins, Minerals & Supplements (VMS) market globally.

Our mission is to bring health in people’s hands by making self-care as simple as it should be. For half a billion consumers worldwide – and counting.

At the core of this mission is our 100 loved brands, our 11,000-strong global team, our 13 best-in-class manufacturing sites and 4 specialized science and innovation development centers. Headquartered in France, Opella is the proud maker of many of the world’s most loved brands, including Allegra, Buscopan, Doliprane, Dulcolax, Enterogermina, Essentiale and Mucosolvan.

B Corp certified in multiple markets, we are active players in the journey towards healthier people and planet. Find out more about our mission at www.opella.com.

Position Overview:

This position will report to the Senior Data Architect within Opella. The Data Engineer will collaborate across multiple business functions and work closely with data scientists, data architects, and data governance teams to implement scalable data pipelines and platforms that support various business needs.

S/he should have strong expertise in Snowflake/Databricks, Python, AWS/Azure, dbt, and Git to join our data engineering team.

The successful candidate will be responsible for designing, building, and optimizing data pipelines to support advanced analytics and business intelligence initiatives.

You will work with cutting-edge cloud technologies to ensure data is accessible, clean, and optimized for use by various teams across the organization.

You will work closely with data architects, AI engineers, analysts, and business stakeholders to ensure data is not just available — but intelligent, trusted, and ready for AI consumption.

This role requires someone who can collaborate effectively with data architects, analysts and business stakeholders to deliver scalable and high-performance data solutions

Key Responsibilities:

The Data Engineer will be responsible for:

Design, develop, and maintain data pipelines using Python and dbt to ingest, transform, and store data in Snowflake/Databricks.
Build and manage Snowflake/Databricks data warehouses and data marts, ensuring efficient and scalable data architectures.
Leverage AWS /Azureservices (e.g., S3, Lambda, Glue, EC2) to develop cloud-based data pipelines and automate data workflows.
Develop ETL/ELT pipelines to load data into Snowflake, ensuring performance, scalability, and reliability.
Optimize data queries and performance within Snowflake, ensuring efficient use of resources and minimizing query costs.
Use dbt for transforming and modeling data in Snowflake, implementing robust testing, documentation, and version control processes.
Support development of AI-ready data platforms by designing high-quality, well-modeled datasets for advanced analytics and machine learning workloads.
Support AI and machine learning workloads by preparing high-quality, analytics-ready datasets.
Implement and manage CI/CD pipelines for data engineering projects using Git to ensure smooth development, testing, and deployment processes.
Ensure data quality, integrity, and consistency through best practices in data governance, documentation, and monitoring.
Troubleshoot and optimize existing data workflows, resolving any issues with data ingestion, processing, or query performance.

About You:

Qualification

7+ years of experience in Data Engineering, with a strong focus on database development, ETL/ELT processes, and cloud platforms.
Strong experience with Snowflake/DataBricks as a data warehouse platform, including data modeling, performance tuning, and optimization.
Proficiency in Python for building data pipelines, automation, and data transformations.
Hands-on experience with AWS cloud services, particularly S3, Lambda, Glue and EC2.Expertise in dbt for managing and transforming data within Snowflake.
Experience with SQL for complex data queries, transformations, and performance optimization.
Familiarity with Git for version control, branching, and collaborating on data engineering projects.
Experience building and maintaining ETL/ELT pipelines in cloud environments. Excellent troubleshooting skills with the ability to optimize and improve existing data processes.
Ability to work independently and in collaboration with cross-functional teams. Strong communication skills to effectively interact with technical and non-technical stakeholders.

Education:

Bachelor’s degree in computer science, Information Technology, Data Engineering, or a related field.

Why us?

At Opella, you will enjoy doing challenging, purposeful work, empowered to develop consumer brands with passion and creativity. This is your chance to grow new skills and be part of a bold, collaborative, and inclusive culture where people can thrive and be at their best every day.

We Are Challengers.

We are dedicated to making self-care as simple as it should be. That starts with our culture. We are challengers by nature, and this is how we do things:

All In Together: We keep each other honest and have each other's backs.

Courageous: We break boundaries and take thoughtful risks with creativity.

Outcome-Obsessed: We are personally accountable, driving sustainable impact and results with integrity.

Radically Simple: We strive to make things simple for us and simple for consumers, as it should be.

Join us on our mission. Health. In your hands.