Data Architecture

Job title: Data Architect

• 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

.

About the job:

We are seeking a strategic and detail-oriented Retail Data Architect / Data Modeler to drive the design and governance of scalable, high-performing data models that power retail insights across our global business. This role is critical to enabling data-driven decision-making across domains such as sales, pricing, inventory, POS, eCommerce, promotions, and supply chain.

He/She will collaborate cross-functionally with data engineers, analysts, and global business stakeholders to ensure our data assets are well-structured, governed, and aligned with corporate objectives. You will also be a key contributor to Opella's enterprise data governance strategy — maintaining strong documentation, lineage, and stewardship standards.

Main responsibilities:

Lead the design and standardization of enterprise data models across core retail and CPG domains, including pricing, sales, inventory, promotions, loyalty, POS, and eCommerce — ensuring models are scalable, governed, and aligned with global analytics strategies.

• Define and evolve dimensional, star, and Data Vault schema architectures to support self-service analytics, Retail/CPG KPI tracking, and cross-functional reporting across business units and markets.
• Serve as the data modeling authority for retail and CPG analytics, promoting semantic consistency, harmonized definitions, and reusability across Opella's global functions, affiliates, and syndicated data partners.
• Collaborate with global commercial, supply chain, and finance teams to translate complex business KPIs and performance metrics into formalized data structures, canonical views, and shared metadata.
• Establish and maintain logical and physical data models, reference architectures, and enterprise-wide semantic layers to support consumption by BI tools, data products, and AI/ML applications.
• Contribute to and enforce data governance best practices, including data dictionary maintenance, lineage tracking, model documentation, and coordination with data stewards across regions.
• Oversee model lifecycle management, version control, and change impact analysis for high-priority subject areas within the retail and CPG data landscape.
• Partner with data platform and engineering teams to ensure architectural patterns are implemented with performance, scale, and maintainability in mind — without directly owning pipeline development.
• Act as a strategic advisor on data architecture decisions, guiding alignment across Opella's evolving ecosystem of data products, global platforms, and business initiatives.

About you:

• Must have 6-10 years of experience in data architecture, data modeling, or analytics engineering, ideally in retail or CPG sectors.
• Expertise in building ELT pipelines and semantic layers using DBT and Snowflake.
• Strong foundation in dimensional modeling, data warehousing, and schema design for large-scale analytics.
• Proven experience in implementing and enforcing enterprise data governance frameworks.
• Strong SQL and experience with retail datasets such as sales, pricing, POS, inventory, and loyalty.

• Ability to work with global, cross-functional teams in a matrixed environment.

• Exposure to data mesh, data product thinking, or domain-oriented data architectures.

• Understanding of retailer-syndicated data (IRI, Nielsen, Circana, etc.).

Preferred Education

• Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related field.
• A Master's degree or cloud certifications (e.g., SnowPro, AWS Data Analytics) is 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.