2027 Future Talent Program - Business Intelligence - Intern

Merck; Rahway (NJ); Hybrid; USD 40,000 - 111,000; Full time

Job summary

Merck's Future Talent Program offers internships up to 12 weeks with projects in the Research Lab Division. As a Business Intelligence Intern, you will gather, analyze, and visualize data to inform business operations and decisions, collaborating with multiple departments to transform data into insights.

You will model data in Databricks, create reports in Power BI and other BI tools, and assist in building data pipelines while applying data science ideas.

Qualifications

• Pursuing a degree with at least two years completed by start date.
• Familiarity with BI tools such as Power BI, Qlik, Tableau or ThoughtSpot.
• Strong analytical and problem-solving abilities with attention to detail.
• Basic understanding of databases and data structures.
• Able to work independently and in a team, with clear communication.

Responsibilities

• Assist in data product modeling in Databricks using internal/external data.
• Develop reports using BI tools to track KPIs and metrics.
• Collaborate with cross-functional teams to gather requirements.
• Analyze trends and performance metrics to support decisions.
• Help automate reports and build data pipelines, leveraging ML capabilities.
• Present findings to team members and stakeholders.

Skills

BI Tools

Analytical Skills

Data Visualization

Communication

Independent Worker

Education

Pursuing degree with 2+ years completed

Tools

Databricks

Power BI

Qlik

Tableau

ThoughtSpot

Python

SQL

AWS

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