🚀 Bi Lead Analyst

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

• Education: 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.

Key Skills & Knowledge

• Qlik Sense: data modeling, reloads, advanced expressions, visualisations.
• Excel & Power Query: data transformation, joins, normalisation, 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 prioritise 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 & Application

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.