Overview
At Suanfarma, we are looking for a BI Lead Analyst to join our team in HQ.
Suanfarma is a global leader in the development, manufacturing, and distribution of active pharmaceutical ingredients (APIs). With over 30 years of experience, we are committed to innovation, sustainability, and delivering high-quality products that improve health and well-being around the world.
Responsibilities
* Prepare product / API dossiers including market sizing, pricing / ASP, competition, exclusivity expiration indicators, regulatory status, and suppliers.
* Build and maintain dashboards in Qlik Sense and recurring reports for Business Development, Commercial, and R&D teams.
* Integrate, clean, and reconcile data from multiple internal and external sources, ensuring data quality and traceability.
* Manage and prioritize incoming analysis requests, track progress, and consolidate deliverables.
* Provide insights and visualizations for business case documentation in collaboration with BD and R&D.
Requirements
* Bachelor’s or Master’s degree in Engineering (Industrial, Computer Science, Telecommunications, Data Science), Mathematics, Statistics, Physics, Economics, Life Sciences (Pharmacy, Chemistry), or related fields.
* 2–4 years of experience as a Data Analyst or similar role, ideally in the pharmaceutical industry or consultancy with pharma clients.
* Strong command of Qlik Sense : data modeling, dashboard creation, version control, and publication.
* Advanced Excel : pivot tables, Power Query, data cleaning, and consolidation.
* Experience working with pharmaceutical data sources (e.g., IQVIA, Cortellis / Clarivate); ability to understand coverage, limitations, and use cases.
* Ability to support strategic analysis and initiative selection for portfolio expansion.
* Solid skills in both quantitative and qualitative analysis to support portfolio selection and new product development.
* Ability to translate business requirements into data models that support strategic decision-making.
* Experience working cross-functionally to ensure analytical robustness and business relevance.
* Professional proficiency in English; legal residency and work permit in Spain.
* Python for light automation (pandas, reporting) – nice to have, not mandatory.
* Basic knowledge of exclusivity expiration indicators (patents, SPCs, regulatory) and their commercial implications.
* Familiarity with Power BI (limited use) and collaborative tools (Teams, SharePoint).
* Experience standardizing templates / SOPs and implementing quality review workflows.
Languages
* English : Professional fluency (documentation, meetings, and analysis).
Key Skills & Knowledge
* Qlik Sense : data modeling, reloads, advanced expressions, visualizations.
* Excel & Power Query : data transformation, joins, normalization, version control.
* Pharma data sources : understanding IQVIA (units, channels, volumes, limitations); basic knowledge of Cortellis / Clarivate.
* Market analysis : market sizing, trends, competitive benchmarking, exclusivity expiration indicators, ex-manufacturer vs. retail price analysis.
* Product development understanding : from API R&D to FDF commercialization .
* Visualization & storytelling : creation of clear graphics, executive summaries, methodological annexes.
* Data quality : data dictionaries, update criteria, source traceability.
* Documentation : experience developing templates, style guides, review checklists.
* Python (nice to have) : automating repetitive tasks and generating reports.
Personal Attributes
* Hands-on mindset and strong attention to data quality.
* Structured thinking and great attention to detail.
* Synthesis skills : ability to turn data into actionable recommendations.
* Effective time management and ability to prioritize multiple requests.
* Cross-functional collaboration and clear communication.
* Curiosity about the API / generics market and commitment to continuous learning.
* High standards of ethics and compliance when working with licensed / confidential data.
* Availability for a hybrid work model and occasional travel if needed.
Interested?
If this sounds like your next challenge, send us your CV at We look forward to hearing from you!
#J-18808-Ljbffr