Data Analytics & AI Innovation Intern

331 Pfizer S.A. (Columbia); Bogotá; On-site; COP 13,392,000 - 20,088,000; Part time

Job summary

Pfizer Inc in Bogotá, Colombia is seeking a Data Analytics & AI Innovation Intern to support the CEI team. The role focuses on data analytics, dashboarding with Power BI, and AI-enabled solutions in a regulated enterprise environment. You will work with Python/SQL, transform datasets, and contribute to AI-driven projects.

The internship offers hands-on deliverables, exposure to LLMs and machine learning concepts, and opportunities to work with multiple functions in a fast-paced setting.

Qualifications

• Strong foundation in data analytics and dashboards.
• Experience with Power BI, Power Query, Python and/or SQL for data analysis.
• Ability to translate business questions into analytical views and dashboards.

Responsibilities

• Support development, maintenance, and improvement of Power BI dashboards and Power Query processes for commercial decision‑making.
• Analyze datasets to identify data quality issues and improvement opportunities.
• Prepare and transform datasets using Python/SQL and automate recurring analyses.
• Contribute to AI/enhanced analytics initiatives and prototyping in an enterprise setting.
• Collaborate with stakeholders across commercial, data, and digital teams and document results clearly.

Skills

Data analytics

Power BI

Power Query

Python

SQL

Tools

Power BI

Python

SQL

Job description

About the Role

We are looking for a highly motivated Data Analytics & AI Innovation Intern to support the Commercial Excellence & Innovation (CEI) team. This role is ideal for a student with a strong foundation in data analytics, Power BI, Power Query and programming (Python and/or SQL) who is interested in applying data and AI to real commercial business problems in a regulated, enterprise environment. You will contribute to live dashboards, analytics initiatives, and AI-enabled solutions, working closely with multiple stakeholders across commercial, data, and digital teams. This is a hands‑on role with real deliverables — not a shadowing or observational internship.

What You Will Work On

Data Analytics & Visualization

• Support the development, maintenance, and improvement of Power BI dashboards and Power Query Processes used for commercial decision-making
• Analyze datasets to identify data quality issues, inconsistencies, and improvement opportunities
• Translate business questions into analytical views and dashboards, with guidance from CEI

Programming & Data Handling

Use Python and/or SQL to:

• Prepare and transform datasets
• Automate recurring analyses where relevant
• Support analytical prototyping
• Work with structured and semi-structured data in a real enterprise setting

AI & Advanced Analytics Exposure

Contribute to AI- and analytics-driven initiatives, including:

• Understanding and supporting ML or predictive analytics projects
• Assisting in the design or testing of AI- and agent-based solutions
• Gain exposure to LLMs, AI agents, and applied ML concepts, with mentorship and context provided by the team

Stakeholder Interaction & Enablement

Collaborate with team members and stakeholders from different functions

• Support documentation, analysis summaries, and clear communication of results
• Participate in workshops, reviews, or working sessions when relevant

What We’re Looking For (Strong Baseline Required)

Technical Skills (Core)

• Strong foundation in Data Analytics
• Solid working knowledge of Power BI (modeling, visuals, basic DAX preferred)
• Experience with Python and/or SQL for data analysis and transformation
• Comfortable working with datasets

AI / ML Background (Preferred)

• Experience designing, executing, or contributing to machine learning projects (academic or personal projects count)
• Understanding of basic ML concepts (e.g., features, training, evaluation)
• Interest in how ML and LLMs are applied in real business contexts

Interpersonal & Organizational Skills

• Clear, structured communicator — able to explain work and ask good questions
• Comfortable working with multiple stakeholders and changing priorities
• Organized, accountable, and able to manage tasks with guidance but without constant supervision

What Will Help You Succeed in This Role

• Curiosity and willingness to learn in a complex environment
• Comfort navigating ambiguity while maintaining analytical rigorAbility to balance technical depth with practical business needs
• Openness to feedback and continuous improvement

Work Location Assignment: On Premise

EEO (Equal Employment Opportunity) & Employment Eligibility

Pfizer is committed to equal opportunity in the terms and conditions of employment for all employees and job applicants without regard to race, color, religion, sex, sexual orientation, age, gender identity or gender expression, national origin, or disability. To learn more about acceptable and prohibited uses of AI during the recruitment process, please review our candidate AI-use guidelines available on Pfizer Careers.

Support Services

Pfizer careers are like no other. In our culture of individual ownership, we believe in our ability to improve future healthcare, and potential to transform millions of lives. We’re looking for new talent to join our global community, to unearth new innovative therapies that make the world a healthier place.