Data Warehouse Solutions Engineer Intern (AI & ETL)

MIDLAND STATES BANK; St. Louis (MO); On-site; USD 22,000 - 28,000; Full time

Benefits offered by this job

Comprehensive healthcare

Well-being benefits

Paid time off

401K with company match

Employee Stock Purchase Plan

Job summary

Midland States Bank is offering an Intern - Associate Solutions Engineer (Data Warehouse) position in Effingham, IL or St. Louis, MO. The role supports the Data Engineering team with version control, deployment processes, and data/model prep for AI-enabled workflows.

The internship runs Summer 2027, requires 40-hour weeks, and applicants must be local to Effingham or St. Louis. Strong SQL/Python coursework and teamwork, plus Excel/Teams proficiency, are expected.

Qualifications

• Summer 2027 internship (mid-May to early August).
• Need to reside locally to Effingham, IL or St. Louis, MO and report to the assigned office.
• Enrolled in a degree program with courses in CS/IT/Data Analytics, software development, or related field (≥2 years).
• Coursework or experience with SQL.
• Coursework or experience with Python or a similar language.
• Software development coursework.
• Exposure to or interest in generative AI.

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 like PowerShell and Python.
• Use SQL and other technical tools while supporting Data Engineering work.
• Collaborate with Data Engineering and IT teams to interface with business units.

Skills

SQL

Python

Teamwork

Communication

Excel

Education

2+ years completed in Computer Science/IT/Data Analytics or related degree program

Tools

PowerShell

Microsoft Teams

Job description

Midland States Bank is offering an Intern - Associate Solutions Engineer (Data Warehouse) position in Effingham, IL or St. Louis, MO. The role supports the Data Engineering team with version control, deployment processes, and data/model prep for AI-enabled workflows.

The internship runs Summer 2027, requires 40-hour weeks, and applicants must be local to Effingham or St. Louis. Strong SQL/Python coursework and teamwork, plus Excel/Teams proficiency, are expected.