Business Intelligence trainee

7300-Janssen-Cilag S.A. Legal Entity; Madrid; On-site; EUR 10,000 - 15,000; Full time

Benefits offered by this job

Location in Madrid

Job summary

Johnson & Johnson invites applicants for a Career Programs internship in Madrid, focusing on business analytics and market intelligence. You will support dashboards, key metrics, and insights that inform sales and market strategies.

You will learn pharmaceutical market analytics, research design, and cross-functional collaboration while building hands-on BI experience with Power BI and Excel in a leading healthcare company.

Qualifications

• Currently pursuing or recently completed university degree related to business or analytics.
• Strong analytical mindset with data interpretation and insight generation.
• Advanced Microsoft Excel skills; familiarity with Power BI is a plus.

Responsibilities

• Develop, maintain, and enhance dashboards and reports to monitor market performance.
• Evaluate sales force indicators and support field effectiveness analyses.
• Collect, validate, and analyze data from multiple sources for actionable insights.
• Collaborate with BI team on market research design, budgeting, and results.
• Gain understanding of pharmaceutical market and competitive landscape.
• Support competitive intelligence by monitoring market dynamics and launches.
• Partner with Commercial, Medical Affairs, Market Access, Finance, Strategy.
• Assist in forecasting, planning, and performance tracking processes.
• Develop data visualizations using Power BI and Excel.

Skills

Advanced Excel

Data analysis

English communication

Education

Bachelor's or Master's degree in Business/Economics/Data Analytics/Healthcare/Life Sciences

Tools

Power BI

Job description

At Johnson & Johnson,we believe health is everything. Our strength in healthcare innovation empowers us to build aworld where complex diseases are prevented, treated, and cured,where treatments are smarter and less invasive, andsolutions are personal.Through our expertise in Innovative Medicine and MedTech, we are uniquely positioned to innovate across the full spectrum of healthcare solutions today to deliver the breakthroughs of tomorrow,and profoundly impact health for humanity.Learn more at jnj.com. As guided by Our Credo, Johnson & Johnson is responsible to our employees who work with us throughout the world. We provide an inclusive work environment where each person is considered as an individual. At Johnson & Johnson, we respect the diversity and dignity of our employees and recognize their merit.

Job Function: Career Programs Job Sub Function: Non-LDP Intern/Co-Op Job Category: Career Program All Job Posting Locations: Madrid, Spain

Job Description: About Innovative Medicine Our expertise in Innovative Medicine is informed and inspired by patients, whose insights fuel our science-based advancements. Visionaries like you work on teams that save lives by developing the medicines of tomorrow. Join us in developing treatments, finding cures, and pioneering the path from lab to life while championing patients every step of the way. Learn more at https://www.jnj.com/innovative-medicine

Key Responsibilities:

• Support the development, maintenance, and enhancement of business reports and dashboards to monitor market performance, including sales trends, market share, patient analytics, Voice of Customer insights, and other key business metrics.
• Contribute to Field Force Effectiveness analyses by evaluating sales force performance indicators such as targeting, segmentation, customer potential, call activity, coverage, and execution metrics.
• Assist in the collection, validation, and analysis of data from multiple internal and external sources to generate actionable business insights and support decision-making.
• Collaborate with the Business Intelligence team in the design, execution, and interpretation of market research projects, including agency coordination, survey development, budget tracking, and results analysis.
• Develop an understanding of the pharmaceutical market, healthcare ecosystem, competitive landscape, and Johnson & Johnson Innovative Medicine business priorities.
• Support competitive intelligence activities by monitoring market dynamics, product launches, competitor performance, and emerging industry trends.
• Partner with cross-functional teams including Commercial, Medical Affairs, Market Access, Finance, and Strategy to address business questions and analytical needs.
• Participate in forecasting, business planning, and performance tracking processes through data preparation, analysis, and presentation development.
• Gain hands‑on experience with data visualization, reporting, and analytics tools such as PowerBI, Excel, and other business intelligence platforms.
• Ensure compliance with company policies, data privacy requirements, and pharmacovigilance obligations, including the timely reporting of adverse events in accordance with company procedures.

What the Intern Will Learn:

• Pharmaceutical market analytics and business intelligence methodologies.
• Market research design and insight generation.
• Sales Force Effectiveness and commercial excellence principles.
• Data visualization and reporting best practices.
• Forecasting, strategic planning, and performance management.
• Cross‑functional collaboration in a leading healthcare organization.

Requirements:

• Currently pursuing or recently completed a Bachelor's or Master's degree in Business, Economics, Data Analytics, Statistics, Healthcare, Life Sciences, or a related field.
• Fluent English (written and spoken) is required.
• Strong analytical mindset with the ability to interpret data and translate findings into actionable business insights.
• Genuine interest in working with data, reporting, analytics, and business intelligence.
• Advanced knowledge of Microsoft Excel; experience with Power BI or other data visualization tools is an asset.
• Strong problem‑solving skills and attention to detail.Excellent communication and presentation skills.
• Ability to collaborate effectively with multiple departments and cross‑functional teams, including Commercial, Medical Affairs, Market Access, Finance, and Strategy.
• Strong organizational and time‑management skills, with the ability to manage multiple priorities in a fast‑paced environment.
• Proactive, curious, and eager to learn about the pharmaceutical industry, market research, and business performance analytics.
• Team player with the ability to build relationships and work effectively with diverse stakeholders.

We offer:

• Duration of the internship - 1 years
• Start date: January 2027
• Full time
• Location : Madrid

The anticipated pay range and benefits for this position is: Dado que esta posición se publica en un pais sujeto a los requisitos de transparencia salarial de la EU, el equipo de Adquisición de talentos proporcionara información sobre el rango salarial a petición y a los candidatos invitados a una entrevista.

At Johnson & Johnson,we believe health is everything. Our strength in healthcare innovation empowers us to build aworld where complex diseases are prevented, treated, and cured,where treatments are smarter and less invasive, andsolutions are personal.Through our expertise in Innovative Medicine and MedTech, we are uniquely positioned to innovate across the full spectrum of healthcare solutions today to deliver the breakthroughs of tomorrow,and profoundly impact health for humanity.Learn more at https://www.jnj.com/.