2027 Future Talent Program - Business Intelligence - Intern

MSD Malaysia; Northern (KY); Hybrid; USD 40,000 - 111,000; Full time

Job summary

Merck & Co., Inc. in Rahway, NJ is offering a Future Talent Program internship in the Research Lab Division.

As a Business Intelligence Intern, you will support the BI team in gathering, analyzing, and visualizing data to help improve operations and decision-making. You will work with Databricks, Power BI, and other BI tools, building dashboards, pipelines, and data products; collaborate with departments; and present insights to stakeholders.

Qualifications

• Pursuing a degree in Business Analytics, Data Science, CS, Information Systems, or Engineering.
• Familiar with BI tools (Power BI, Qlik, Tableau, ThoughtSpot).
• Strong analytical and problem-solving skills.
• Basic understanding of databases and data structures.

Responsibilities

• Assist in data product modeling in Databricks from internal/external sources.
• Develop reports using BI tools to track KPIs.
• Collaborate with cross-functional teams to identify business needs.
• Analyze trends and performance metrics to support decisions.
• Help automate reports and build data pipelines with LLM capabilities.
• Present findings to team members and stakeholders.

Skills

Analytical skills

Communication skills

Team collaboration

Independent work

Education

Pursuing degree in Business Analytics or related field

Tools

Power BI

Qlik

Tableau

ThoughtSpot

Databricks

Python

SQL

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 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.

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.

Merck & Co., Inc., Rahway, NJ, USA, also known as Merck Sharp & Dohme LLC, Rahway, NJ, USA, does not accept unsolicited assistance from search firms for employment opportunities. All CVs / resumes submitted by search firms to any employee at our company without a valid written search agreement in place for this position will be deemed the sole property of our company. No fee will be paid in the event a candidate is hired by our company as a result of an agency referral where no pre-existing agreement is in place. Where agency agreements are in place, introductions are position specific. Please, no phone calls or emails.

Our company is a global health care leader with a diversified portfolio of prescription medicines, vaccines and animal health products. The difference between potential and achievement lies in the spark that fuels innovation and inventiveness; this is the space where we have codified our legacy for over a century. Our success is backed by ethical integrity, forward momentum, and an inspiring mission to achieve new milestones in global healthcare.