Controls Automation And Analytics Specialist

Opella; Hyderabad; On-site; INR 900,000 - 1,350,000; Full time

Job summary

Opella seeks a Controls Automation & Analytics Specialist in Hyderabad to enable efficient data analytics, automation, and agentic AI for internal control testing. You will prepare large datasets, build automated tests, and provide data-driven insights to the testing team.

The role sits within IC Testing and Automation and reports to the Director of Internal Control Testing and Automation. Relevant experience with ERP data and BI tools is essential.

Qualifications

• 2–4 years in data analytics, IT audit, forensic analytics, finance analytics, automation, or similar.
• Proficient in SQL and at least one analytics language (Python or R).
• Experience with BI/visualization tools (Power BI/Tableau) and strong Excel skills.
• Exposure to LLM/agentic workflows in a controlled business context is a plus.

Responsibilities

• Define data requirements with testers and stakeholders; extract data from ERP/sub-ledgers/workflow tools.
• Build and maintain automated tests to detect exceptions and anomalies.
• Develop dashboards and exception reporting to support monitoring.
• Governance: ensure audit-ready docs, data lineage, access controls, and re-validation.

Skills

SQL

Python

R

Excel

Power BI

Tableau

Education

Bachelor’s or Master’s degree in Accounting, Finance, Data Analytics, Computer Science, or related field

Tools

SQL

Job description

Job Description

Job title: Controls Automation & Analytics Specialist. 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

The Controls Automation & Analytics Specialist enables efficient, high-quality, and scalable internal control testing through data analytics, automation and agentic AI. The role prepares and validates large transactional datasets, develops repeatable automated tests to identify exceptions, and supports the testing team with data-driven insights and monitoring outputs. The position sits within the Internal Control Testing and Automation organization and reports to the Director, Internal Control Testing and Automation.

Main Responsibilities

Data, Analytics & Automated Testing Delivery

Define data requirements with testers and process stakeholders. Obtain and prepare extracts from source systems (ERP, sub-ledgers, workflow tools). Perform data quality and reconciliation checks (completeness, accuracy, duplicates, cut-off, mapping) and document results. Build and maintain automated tests (SQL/Python/R) to detect exceptions (e.g., duplicate payments, abnormal journals, master data anomalies). Develop dashboards and exception reporting (Power BI/Tableau) to support periodic and continuous monitoring. Operationalize automated tests: scheduling, run-books, exception triage workflow, and handoff to testers/control owners.

Agentic AI Enablement for Testing

Design and maintain agentic AI workflows to support testing activities such as evidence intake/classification, completeness checks, automated follow-ups, exception clustering, and drafting testing narratives for reviewer completion. Define human-in-the-loop checkpoints and ensure reviewer approval before conclusions are finalized. Maintain prompt libraries, agent configurations, and reusable components aligned with testing standards.

Governance, Collaboration & Continuous Improvement

Ensure audit-ready governance for automation and agentic solutions: documented logic/assumptions, data lineage, versioning/change logs, reproducibility, logging, access controls, and periodic re-validation. Collaborate with IC Testing Analysts/Senior Analysts and process teams to translate testing objectives into analytics/agentic use-cases and support root cause analysis and remediation follow-up. Identify opportunities to expand automation/agentic coverage and reduce manual effort. Contribute to the testing automation roadmap and standardization initiatives.

About You Education

Bachelor’s or Master’s degree in Accounting, Finance, Data Analytics, Computer Science, or a related field. Professional certifications (CFA, CPA, ACCA, CIA, CISA, or AI/analytics certifications) are a plus. Bachelor’s or Master’s degree in Data Analytics, Computer Science, Engineering, Finance, Accounting, or related field. Relevant certifications are a plus (data/analytics, CISA, etc.).

Experience

2–4 years in data analytics, IT audit, forensic analytics, finance analytics, automation, or similar. Proven experience working with large transactional datasets in ERP/finance contexts. Hands‑on proficiency in SQL and at least one analytics language (Python or R). Experience with BI/visualization tools (Power BI/Tableau) and strong Excel skills. Experience building automated analytics, exception monitoring, or controls monitoring solutions. Exposure to LLM/agentic workflows in a controlled business context (prompt design, evaluation, logging) is a plus.

Skills

Strong analytical and problem‑solving skills; ability to translate findings into actionable testing insights. Strong documentation discipline and audit trail mindset. Ability to implement human‑in‑the‑loop safeguards and quality checks for agentic outputs. Effective communication skills. Ability to work across time zones.

Nice to Have

Experience with GRC tools (AuditBoard or similar). Exposure to internal controls and end‑to‑end processes (RTR, P2P, O2C). Familiarity with RPA and basic model risk concepts (validation, monitoring, access controls, data privacy).

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.

Our Culture

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