Data & AI Engineering

Opella; Hyderabad; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

Opella, Hyderabad-based self-care leader, is seeking a hands-on Data & AI Engineer to build enterprise-grade AI capabilities powering internal analytics platforms. The role focuses on scalable data pipelines, LLM-powered services, and semantic layers to enable business teams to derive insights.

You will design AI services, prompt frameworks, and RAG knowledge systems, deploying via cloud-native architectures and tools like Snowflake, FastAPI, and Docker.

Qualifications

• 4–8 years of AI/Data Engineering or applied AI systems experience.
• Strong Python programming and SQL/data modeling skills.
• Hands-on with LLMs and prompt engineering for structured outputs.
• Experience building RAG pipelines and vector search systems.
• Familiarity with FastAPI/Docker and cloud deployments.
• Exposure to LangChain or Autogen and agent frameworks.

Responsibilities

• Design and build scalable data pipelines using Snowflake and cloud data platforms.
• Develop analytics-ready data models and semantic layers.
• Design and implement LLM-powered capabilities and prompt frameworks.
• Build and optimize RAG pipelines and embedding-based retrieval systems.
• Develop APIs and microservices for AI workflows; deployment and monitoring.

Skills

Python

SQL

Data Modeling

LLM & Prompt Engineering

RAG pipelines

Semantic layers

API design

Docker

Airflow

CI/CD

Education

Bachelor’s degree in Computer Science or related field

Advanced certifications (AWS, Snowflake, Databricks, GCP)

Tools

Snowflake

Pinecone

Elastic

FAISS

LangChain

Autogen

OpenAI

AWS Bedrock

Docker

FastAPI

Airflow

Job description

Job title: Data & AI Engineering 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.

About the job: We are looking for a hands‑on AI & Data Engineer to build and deploy enterprise‑grade AI capabilities powering Opella’s internal analytics platforms. This is an engineering‑first role, focused on building scalable data + AI systems using LLMs, semantic layers, and cloud data platforms. The role emphasizes applied AI, prompt engineering, and data modeling rather than traditional ML model development. You will design standardized AI services that enable business teams across commercial, finance, supply chain, and digital functions to interact with data, generate insights, and make faster, smarter decisions.

• Data Engineering & Platform Integration Design and build scalable data pipelines using Snowflake / cloud data platforms Proficient with DBT and Airflow framework. Develop analytics-ready data models (facts, dimensions, semantic layers) Ensure data quality, consistency, and performance across AI workflows
• Applied AI, LLM & Prompt Engineering Design and implement LLM-powered capabilities such as: Natural language → SQL/query generation KPI reasoning and insight generation Metadata extraction and entity resolution Semantic search and contextual retrieval Build and optimize prompt engineering frameworks, including: Structured prompting for SQL, JSON, and analytical outputs Few-shot / instruction tuning strategies Guardrails to ensure accuracy, consistency, and business alignment Prompt evaluation and iterative improvement Integrate LLMs via platforms like AWS Bedrock, OpenAI, Anthropic
• RAG & Knowledge Systems Engineer RAG pipelines and embedding-based retrieval systems Design vector search strategies (indexing, chunking, ranking, grounding) Combine structured (data warehouse) and unstructured (docs, PPTs, metadata) sources into unified knowledge layers
• AI Services & Engineering Architecture Develop APIs and microservices using Python, FastAPI, Docker Build orchestration layers for multi-step AI workflows and agent-based systems Implement inference services, caching layers, and reusable AI components Deploy scalable AI services using cloud-native architectures
• Semantic Layer & Business Alignment Integrate AI systems with governed semantic layers and metadata Ensure outputs align with defined KPIs, business rules, and data standards Translate business questions into reusable AI-powered analytics services
• Productionization & Governance Establish standards for prompt versioning, monitoring, and evaluation Implement logging, performance tracking, and reliability checks Ensure secure, privacy-safe AI usage aligned with enterprise policies Support CI/CD, testing, and robust deployment practices

About You:Core Experience 4–8 years of experience in AI/Data Engineering or Applied AI systems Strong programming skills in Python Strong SQL and data modeling experience (Snowflake preferred) AI / LLM & Prompt Engineering Hands-on experience with: LLMs (GPT, Claude, etc.) Prompt engineering for structured outputs (SQL, JSON, insights) Few-shot prompting and instruction design Prompt evaluation and optimization Experience building: RAG pipelines and embeddings Vector search systems (Pinecone, Elastic, FAISS) Engineering & Platform Skills Experience with FastAPI / Flask, Docker, cloud deployments Familiarity with orchestration tools (Airflow, etc.) Strong software engineering practices (CI/CD, testing, version control) Data & Analytics Understanding Strong understanding of: Data warehouse concepts (facts, dimensions, grain) Semantic layers and KPI modeling Business-facing analytics use cases Experience in CPG, retail or ecommerce is a plus Must Have Exposure to agent frameworks (LangChain, Autogen) Experience with prompt + metadata-driven systems Familiarity with Streamlit or user-facing data apps Education Bachelor’s degree in Computer Science, Data Engineering, AI, or related field Advanced certifications (AWS, Snowflake, Databricks, GCP) are a plus 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. www.opella.com/en/careers