BI Lead Analyst – Pharma & Portfolio Intelligence

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!