BI Lead Analyst – Pharma & Portfolio Intelligence
hace 1 día
Madrid
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!