Strategic Data Insights Specialist
16 hours ago
Madrid
The role of a Business Intelligence Lead Analyst involves preparing product dossiers, building and maintaining dashboards, integrating data from multiple sources, and providing insights for business case documentation. This position requires a strong command of Qlik Sense, advanced Excel skills, and experience working with pharmaceutical data sources. The ideal candidate will have solid skills in both quantitative and qualitative analysis, ability to translate business requirements into data models, and experience working cross-functionally. • Key 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., • 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)., • 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.