Data & AI Engineering

1351 Opella Healthcare IN P.Ltd; Hyderabad; On-site; INR 2,500,000 - 4,200,000; Full time

Job summary

Opella seeks a hands‑on Data & AI Engineer to build and deploy enterprise AI capabilities powering internal analytics. You will design scalable data pipelines with Snowflake, implement LLM‑powered features, and create AI services accessed by commercial, finance, and supply chain teams.

You will work with Python, FastAPI, Docker, and Airflow in an engineering‑first environment, focusing on applied AI, prompt engineering, and data modeling rather than traditional model training.

Qualifications

• 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 with practical experience.
• Hands‑on with LLMs (GPT, Claude) and prompt engineering for structured outputs.

Responsibilities

• Design scalable data pipelines and analytics data models.
• Build and deploy AI capabilities powering internal analytics platforms.
• Develop APIs and microservices using Python and FastAPI.
• Implement RAG and embeddings with vector search systems.
• Collaborate with business teams to translate questions into AI services.

Skills

Python

SQL

LLM & Prompt Eng

Data Modeling

Cloud Data Platforms

RAG pipelines

Vector search

Pinecone

FAISS

Airflow

FastAPI

Education

Bachelor’s in CS/DAI/AI

Tools

Snowflake

Docker

Airflow

FastAPI

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 Engineering: 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 e-commerce 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

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.