Finance Analytics Intern: AI Dashboards & Data Viz

Daiichi Sankyo; Basking Ridge (NJ); On-site; USD 20,000 - 27,000; Full time

Job summary

Daiichi Sankyo is seeking a Corporate Finance Intern for Summer 2027. This role focuses on converting an Excel financial model into an automated AI dashboard and building interactive visualizations for global to regional views.

You will work with Finance, FP&A, and IT/Data teams, applying prompt engineering and ChatGPT to automate processes and deliver insights. The internship runs ~37.5 hours per week and provides hands-on experience in analytics.

Qualifications

• Currently pursuing a Bachelor's degree in Finance, Accounting, Business Analytics, Data Science, Economics, or related field.
• Strong Excel skills with experience in formulas, pivot tables, and data modeling.
• Basic to intermediate experience with PowerBI or similar data visualization tools.
• Understanding of prompt engineering and building solutions with ChatGPT.
• Familiarity with financial statements, budgeting, and expense categories.
• Ability to work with large datasets and ensure data accuracy.
• Strong analytical thinking and problem-solving abilities, plus communication skills.

Responsibilities

• Convert the existing Excel financial model into an automated, interactive AI dashboard.
• Learn and apply co-pilot and ChatGPT for dashboard automation.
• Design visualizations showing financial trends (YoY, QoQ), LE changes, and headcount by region.
• Develop drill-down capabilities from global totals to regional expense categories and account-level details.
• Integrate expense and headcount data into a centralized, user-friendly dashboard.
• Ensure data accuracy, source mapping, and alignment with finance reporting standards.
• Collaborate with Finance, FP&A, and IT/Data teams to understand requirements and validate outputs.
• Document data sources, dashboard logic, and user guidance for future enhancements.
• Present progress updates and final deliverables to Finance leadership.

Skills

Excel proficiency

PowerBI

Prompt engineering

Financial statements

Data accuracy

Analytical thinking

Communication (written & verbal)

Data analysis

Education

Bachelor's in Finance

Bachelor's in Accounting

Business Analytics

Data Science

Tools

Power Query

DAX

SQL

Job description

Daiichi Sankyo is seeking a Corporate Finance Intern for Summer 2027. This role focuses on converting an Excel financial model into an automated AI dashboard and building interactive visualizations for global to regional views.

You will work with Finance, FP&A, and IT/Data teams, applying prompt engineering and ChatGPT to automate processes and deliver insights. The internship runs ~37.5 hours per week and provides hands-on experience in analytics.