Role Overview
We’re looking for a highly analytical and detail-oriented Business Analyst to transform complex commercial and operational data into clear, actionable insights. In this role, you’ll work hands-on with data, leveraging advanced Excel skills to perform calculations, build models, and support strategic decision-making.
The ideal candidate is comfortable navigating large datasets, designing quantitative analyses, and communicating key findings effectively. Flexibility to work within European CET business hours is preferable.
Key Responsibilities
•Perform detailed quantitative analyses on large datasets (e.g., sales, performance, operational or market data) using advanced Excel techniques.
•Build, maintain, and enhance Excel models and calculators (e.g., forecasting tools, performance trackers, scenario and sensitivity models, ROI calculators).
•Clean, validate, and reconcile data from multiple sources, ensuring the accuracy, consistency, and traceability of all numbers and formulas.
•Design clear tables, charts, and summary views in Excel and PowerPoint to communicate analytical findings and key metrics to internal stakeholders.
•Document calculation logic, key assumptions, and data sources so that models are transparent, auditable, and easy to reuse.
•Run ad-hoc analyses on short timelines, structuring problems, selecting appropriate methods, and delivering concise numeric answers.
•Continuously improve existing files by optimizing formulas, simplifying structures, improving performance, and standardizing formats and naming conventions.
• This role will support Europe counterparts and may need to observe European time zone (mid shift) from time to time.
Skills and Experience
•Strong analytical and numerical skills, with substantial hands-on experience working with large datasets in Excel on a daily basis.
•Proficiency with advanced Excel features, including nested formulas, lookup/indexing functions, pivot tables, conditional logic, error handling, and what-if or scenario analysis; basic VBA/macro skills are a plus.
•Proven experience in a data-driven role (e.g., business analyst, data analyst, financial analyst or commercial analyst), ideally in a data-rich environment such as healthcare, pharmaceuticals, FMCG, or technology.
•High attention to detail, with a rigorous approach to checking formulas, reconciling numbers, and documenting changes.
•Ability to translate business questions into structured analytical approaches and to clearly explain model logic and conclusions to non-technical colleagues.
Education and Tools
•Bachelor’s degree in a quantitative, business, or related field (e.g., economics, engineering, mathematics, mathematics, statistics, business administration).
•Advanced Excel skills required; familiarity with additional analytical tools (e.g., Power BI/Tableau, SQL, or statistical tools) is an advantage but not the primary focus of the role.
Personal Attributes
•Structured and methodical working style with a strong sense of ownership for the quality of numbers and files produced.
•Curious, solution-oriented mindset with a willingness to dive deep into data and iterate models when new questions arise.
•Comfortable working both independently and as part of a small analytical team, managing multiple parallel tasks and deadlines.
Skills Required
- Advanced Excel skills (nested formulas, lookups/indexing, pivot tables, scenario analysis)
- Proven experience in a data-driven role (business analyst, data analyst, financial/commercial analyst)
- Hands-on experience working with large datasets and rigorous data reconciliation
- Bachelor's degree in a quantitative, business, or related field
- High attention to detail and rigorous approach to checking formulas and documenting changes
- Ability to translate business questions into structured analyses and explain conclusions to non-technical colleagues
- Basic VBA / macro skills
- Familiarity with Power BI / Tableau, SQL, or other statistical tools
- Flexibility to work within European CET business hours
What We Do
iNova Pharmaceuticals is leading the way to better health by constantly searching for new, practical solutions that improve the everyday health and wellbeing of people around the world. Our portfolio of market-leading consumer health brands and prescription medicines are backed by science and span across the key therapeutic areas of throat, cough, cold & flu, skin care, sun care, pain management, wound care, weight management, natural health supplements among many others. Headquartered in Singapore, today our products are distributed in over 75 markets across Asia, Australia, New Zealand, Middle East & Africa and Europe. At iNova pharmaceuticals, we do things differently. iNova believes that if you can imagine it, you make it happen. Every employee has the opportunity to make a real and immediate impact. Be part of a passionate team, focused on delivering innovative healthcare solutions that improve the lives of people around the world. Discover why people love working at iNova Pharmaceuticals. We offer an award-winning culture and industry-leading benefits. iNova Pharmaceuticals is an Equal Opportunity employer. We strongly believe that inclusion and diversity is critical to our success and our people reflect the diversity of the global markets we serve.







