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.
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., 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.
~ 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.
English : Professional fluency (documentation, meetings, and analysis).
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); Market analysis : market sizing, trends, competitive benchmarking, exclusivity expiration indicators, ex-manufacturer vs. retail price analysis.
Data quality : data dictionaries, update criteria, source traceability.
Python (nice to have) : automating repetitive tasks and generating reports.
Hands-on mindset and strong attention to data quality.
Synthesis skills : ability to turn data into actionable recommendations.
Effective time management and ability to prioritize multiple requests.
High standards of ethics and compliance when working with licensed / confidential data.
Availability for a hybrid work model and occasional travel if needed.
Team Leader • Alcobendas, Area Metropolitana (comarca), España