Data And AI Engineering

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

Job summary

Opella is hiring a hands-on Data & AI Engineer to build enterprise-grade AI capabilities powering internal analytics platforms. You will work with scalable data + AI systems using LLMs, semantic layers, and cloud data platforms, focusing on applied AI, prompt engineering, and data modeling rather than traditional ML.

You will design standardized AI services that enable business teams to interact with data, generate insights, and make faster, smarter decisions, while ensuring governance and data

Qualifications

• 4–8 years of experience in AI/Data Engineering or applied AI systems.
• Strong programming in Python and SQL, with data modeling experience.
• Hands-on with LLMs, prompt engineering, and AI service design.
• Experience building RAG pipelines, embeddings, and vector search.

Responsibilities

• Design and build scalable data pipelines on cloud data platforms.
• Develop analytics-ready data models and semantic layers.
• Create LLM-powered capabilities for SQL/JSON generation and KPI insights.
• Implement RAG pipelines and embedding-based retrieval systems.
• Architect AI services and APIs using FastAPI, Docker, and cloud tooling.
• Ensure governance, monitoring, and production readiness of AI workflows.

Skills

Python

SQL

LLM & Prompt Engg

RAG pipelines

Vector search

Data modeling

Cloud data platforms

API design

Education

Bachelor's in CS/Data Eng/AI

Tools

Snowflake

Airflow

DBT

FastAPI

Docker

Pinecone/Elastic/FAISS

Job description

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.

Main Responsibilities:

• 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