AI-Driven Data Engineering Intern

Midland States Bank; Effingham (IL); On-site; USD 21,000 - 29,000; Full time

Job summary

Midland States Bank seeks an Intern – Associate Solution Engineer – DW to support the Data Engineering team over the Summer 2027 period in Effingham, IL or St. Louis, MO. The role emphasizes version control, deployment processes, and preparing data models for AI-enabled workflows.

You will gain hands-on experience with ETL, SQL, Python, and scripting languages while collaborating with IT and business units. Strong communication and a willingness to learn are essential for success.

Qualifications

• Summer 2027 internship from mid-May to early August.
• Able to work a 40-hour week, Monday–Friday, between 8 a.m. and 5 p.m.
• Must reside local to Effingham, IL or St. Louis, MO and report to the assigned office.
• Enrolled in a degree program with courses in Computer Science, Information Technology, Data Analytics, Software Development, or related field with at least 2 years completed.
• Coursework or experience with SQL.
• Coursework or experience with Python or a similar programming or scripting language.
• Software development coursework.
• Exposure to or interest in generative AI.
• Works well in a team environment.
• Excellent written and oral communication skills.
• Proficient in Microsoft Excel and Teams.
• Demonstrates ability to learn and use new software and programs.

Responsibilities

• Assist with version controlling Data Engineering code to strengthen auditability and deployment processes.
• Support efforts to enable AI processes within the deployment pipeline and improve deployment processes.
• Assist with exposing data models for use by AI models.
• Gain hands-on experience with ETL development and scripting languages such as PowerShell and Python.
• Use SQL and other technical tools while supporting Data Engineering work.
• Support team items that provide opportunities to interface with other IT teams and business units.
• Participate in shadowing opportunities with the Database team and collaborate with Data Engineering team members.
• Develop an understanding of how data flows through the organization and enables downstream reporting and business decision-making.
• Learn how data quality can impact reporting and downstream processes.
• Practice translating technical requirements across upstream and downstream stakeholders.
• Perform other duties as assigned.
• Maintain compliance with all applicable regulations including, but not limited to, the Bank Secrecy Act (BSA).

Skills

SQL

Python

PowerShell

ETL

Data modeling

Education

Computer Science

Information Technology

Data Analytics

Software Development

Tools

Version control

Job description

Midland States Bank seeks an Intern – Associate Solution Engineer – DW to support the Data Engineering team over the Summer 2027 period in Effingham, IL or St. Louis, MO. The role emphasizes version control, deployment processes, and preparing data models for AI-enabled workflows.

You will gain hands-on experience with ETL, SQL, Python, and scripting languages while collaborating with IT and business units. Strong communication and a willingness to learn are essential for success.