2027 Future Talent Program - Business Intelligence - Intern

Merck; North Wales (Montgomery County); Hybrid; USD 40,000 - 111,000; Part time

Benefits offered by this job

Hybrid work arrangement

Internship/Co-op

Job summary

Merck is offering a Future Talent Program BI Internship in its Research Lab division. You will help gather, analyze, and visualize data to improve business operations and decision-making. You will work with cross-functional teams, build reports in Power BI, and contribute to data pipelines using Databricks and LLM capabilities.

The role emphasizes collaboration, strong analytical skills, and the ability to present complex data succinctly. Hybrid work arrangements and a 12-week program are noted.

Qualifications

• Pursuing a degree in Business Analytics, Data Science, CS, Information Systems, Engineering, or related field; must have completed at least 2 years by start of internship.
• Familiarity with BI tools (Power BI, Qlik, Tableau, ThoughtSpot or others).
• Strong analytical and problem-solving skills with attention to detail.
• Basic understanding of database management and data structures.

Responsibilities

• Assist in data product modeling in Databricks using data from multiple sources.
• Develop reports and dashboards with BI tools to track KPIs and metrics.
• Collaborate with cross-functional teams to identify business needs and requirements.
• Support data-driven decision-making by analyzing trends and performance metrics.
• Assist in automating reports and building data pipelines leveraging LLM capabilities.
• Present findings to team members and stakeholders.

Skills

Analytical thinking

Problem-solving

Communication

Teamwork

Education

Enrolled in Business Analytics/Data Science/CS/IS/Engineering

Tools

Power BI

Qlik

Tableau

ThoughtSpot

SQL

Python

Databricks

AWS

Google Cloud

Job description

Job Description

The Future Talent Program features internships that last up to 12 weeks and will include one or more projects. These opportunities in our

The Future Talent Program features internships that last up to 12 weeks and will include one or more projects. These opportunities in our Research Lab Division can provide you with great development and a chance to see if we are the right company for your long-term goals.

As a Business Intelligence Intern, you will support the BI team in gathering, analyzing, and visualizing data to help improve business operations and decision-making processes. You will work closely with various departments, utilizing your analytical skills to turn data into actionable insights.

Key Responsibilities

• Assist in data product modeling in Databricks using the business data collected from various internal and external sources.
• Develop reports and solutions using BI tools (e.g., Power BI and Power Automate) to track key performance indicators (KPIs) and metrics.
• Collaborate with cross-functional teams to identify business needs and gather requirements.
• Support data-driven decision-making by analyzing trends, patterns, and performance metrics.
• Assist in automating reports and building data pipelines leveraging LLM capabilities.
• Present findings and insights to team members and stakeholders.

Requirements

• Currently pursuing a degree in Business Analytics, Data Science, Computer Science, Information Systems, Engineering, or a related field (must have completed at least 2 years of college coursework by the start of the internship).
• Familiarity with BI tool(s) (e.g., Power BI, Qlik, Tableau, ThoughtSpot, or others).
• Strong analytical and problem-solving skills, with attention to detail.
• Basic understanding of database management and data structures.
• Ability to work independently and in a team environment.
• Strong communication skills and the ability to present complex data in a clear and concise manner.

Preferred Qualifications

• Experience working with large datasets and data visualization tools.
• Coding experience (SQL, Python) is advantageous.
• Familiarity with cloud platforms (e.g., Databricks, AWS, Google Cloud) is a plus.
• Knowledge of statistical analysis or machine learning techniques is advantageous.

Please note that this position may be closed before the posted end date or may remain open longer, at the discretion of the company.

Salary Range

The salary range for this role is $39,908 - $111,111 USD

FTP2027

RL2027

Employee Status

Intern/Co-op (Fixed Term)

Relocation

No relocation

VISA Sponsorship

No

Travel Requirements

No Travel Required

Flexible Work Arrangements

Hybrid

Shift

Not Indicated

Valid Driving License

No

Hazardous Material(s)

n/a

Job Posting End Date

10/9/2026

• A job posting is effective until 11:59:59PM on the day BEFORE the listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.

Requisition ID:R412411