Data Analytics Intern — Summer 2027 (Hybrid, Paid)

Mercantil Commerce Bank; Kansas City, Northern (MO, KY); Hybrid; USD 25,000 - 36,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

401(k)

Paid vacation

Paid personal time

Career development

Education assistance

Voluntary benefits

Job summary

Mercantil Commerce Bank is seeking an Intern - Data Analyst for Summer 2027 in Kansas City, MO. The role offers hands-on experience with data analysis, reporting, and dashboard development in a banking setting.

The internship runs from May 18, 2027, for 11 weeks, with a hybrid schedule and mostly remote work. Students should be motivated, organized, and able to learn quickly, with basic SQL and Excel skills and exposure to PowerBI/Tableau.

Qualifications

• Sophomore or junior pursuing IS, CS, data analytics or related major.
• Basic proficiency with Excel and Microsoft Office.
• Basic understanding of SQL; exposure to Python, PowerBI, Tableau or data engineering is a plus.

Responsibilities

• Write efficient data queries to varied types of products and customer analysis.
• Develop dashboards and analysis to support consumer lines of business requests.
• Compile data analysis and reporting for data analysts.
• Present data analysis summary results to team members and business line leadership.
• Perform other duties as assigned.

Skills

Data analysis concepts

SQL basics

Excel proficiency

PowerBI

Tableau

Education

Sophomore/Junior in Information Systems, Computer Science, Data Analytics or related major

Tools

SQL

PowerBI

Tableau

Job description

Mercantil Commerce Bank is seeking an Intern - Data Analyst for Summer 2027 in Kansas City, MO. The role offers hands-on experience with data analysis, reporting, and dashboard development in a banking setting.

The internship runs from May 18, 2027, for 11 weeks, with a hybrid schedule and mostly remote work. Students should be motivated, organized, and able to learn quickly, with basic SQL and Excel skills and exposure to PowerBI/Tableau.