Intern - Data Analyst (Summer 2027)

Commerce Bank; Walnut (AR); Hybrid; USD 45,000 - 52,000; Full time

Benefits offered by this job

Hybrid schedule

Paid internship

Health insurance (benefits)

Job summary

Commerce Bank in Kansas City, Missouri, is offering a paid 11-week data analyst internship. You will develop reporting, dashboards, and queries, working with seasoned data analysts to transform data into actionable insights.

The role includes a hybrid schedule (in-office 2 days/week), 40-hour weeks from May 18 to July 30, 2027, with a Monday–Friday work pattern. Prior exposure to SQL, PowerBI/Tableau is a plus.

Qualifications

• Sophomore or junior pursuing IS/CS/Data Analytics or related major.
• Basic SQL and data analysis exposure.
• Experience with BI tools like PowerBI/Tableau a plus.

Responsibilities

• Write efficient data queries to analyze products and customers.
• Develop dashboards and analyses to support business requests.
• Compile data analyses and reporting for the team.
• Present results to team and leadership.
• Perform additional duties as needed.

Skills

Data analysis concepts

Attention to detail

Communication skills

Team collaboration

Education

Sophomore/Junior in IS/CS/Data Analytics or related major

Tools

SQL

PowerBI

Tableau

Excel

Job description

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.

Location: 922 WALNUT, KANSAS CITY, Missouri 64106

Time Type

Full time