Intern - Data Analyst (Summer 2027)

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

## Intern - Data Analyst (Summer 2027)Apply: Hybrid: MO - Kansas City Downtown/Plaza - Kansas City - KC Downtown Trust Building (922 Walnut) (64106): Full time: Posted Yesterday: 38484**About Working at Commerce**Building a career here is more than just steps on a ladder. It’s about helping people find financial safety and success, helping businesses thrive, and making sure people and their money are taken care of. And our commitment doesn’t stop there. Our culture is about our people, the ones in our communities and the ones that work with us. Here, you’ll find opportunities to grow and learn, to connect with others, and build relationships with the people around you. You’ll have the space and resources to grow into the best version of yourself. Because our number one investment is you.Creating an award-winning culture doesn't come easy. And after 160 years, we know Commerce Bank is only at its best when our people are. If this sounds interesting to you, keep reading and let’s talk. **Compensation Range**Hourly: $22.00 - $22.00 (Amount based on relevant experience, skills, and competencies.)**About This Job** This intern will gain invaluable experience as a data analyst working with best-in-class data analysts in the banking business. Duties of this position include the development of reporting, dashboards, data analysis, and queries utilizing databases and reporting software. The intern also assists with other special projects within the Data Management team. The summer internship session will begin on **Tuesday, May 18, 2027**, and will run for **11 weeks**, ending on **Friday, July 30, 2027**. Internships are **paid, full-time opportunities** with a **Monday through Friday** work schedule. **Essential Functions*** 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. **Work Schedule*** Monday-Friday, 8:00am-5:00pm* Mostly Remote **Knowledge, Skills & Abilities Required*** Motivated to learn and apply data analysis concepts in real-world use cases.* Organized; self-starter with strong attention to detail and the ability to manage multiple priorities.* Inquisitive, agile, and strong team player with excellent written, verbal, and interpersonal communication skills* Ability to remain adaptable and resilient to all situations with an optimistic outlook and cast a positive shadow that is aligned with our culture and Core Values* Basic level proficiency with Microsoft Word, Excel, and Outlook**Education & Experience*** Prefer a sophomore/junior with an Information Systems, Computer Science, Data Analytics, or related major.* PC Skills include Microsoft Office with basic proficiency in Excel.* Basic understanding of SQL is strongly preferred.* Exposure to Python, Microsoft PowerBI, Tableau, or data engineering concepts is a plus. \\*Hybrid Schedule: In office 2 days per week \\*\\*\\*For individuals applying, assigned and/or hired to work in areas with pay transparency requirements, Commerce is required by law to include a reasonable estimate of the compensation range for some roles. This compensation range is for the Intern job. The disclosed range estimate has not been adjusted for any applicable differentials (geographic, bilingual, or shift) that could be associated with the position or where it is filled. A reasonable estimate of the current base pay is $22.00 per hour. #LI-MC2 #LI-Hybrid ***Must be eligible to work in the US without sponsorship now or in the future.*** The candidate selected for this position may be eligible for the following employment benefits: employer sponsored health, dental, and vision insurance, 401(k), life insurance, paid vacation, and paid personal time. In addition, we offer career development, education assistance, and voluntary supplemental benefits. Click here to learn more.Location: 922 WALNUT, KANSAS CITY, Missouri 64106Time Type:Full time