Data Warehouse Solutions Engineer Intern

Midland States Bancorp, Inc.; Effingham, Northern (IL, KY); Híbrido; USD 36.000 - 42.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Healthcare benefits

Paid time off

Employee Stock Purchase Plan

401K with company match

Well-being benefits

Paid family leave

Descripción de la vacante

Midland States Bank in Effingham, IL, invites applications for an Intern – Associate Solution Engineer – DW. The role supports the Data Engineering team with version control, deployment processes, and preparing data models for AI-enabled workflows.

You will gain hands-on experience with SQL, Python, ETL, and scripting in PowerShell, collaborate across IT and business units, and learn how data flows drive reporting and decisions. This paid internship runs Summer 2027, Monday–Friday.

Formación

• 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 and Python.
• Exposure to or interest in generative AI.
• Proficient in Microsoft Excel and Teams.
• Works well in a team environment.
• Excellent written and oral communication skills.

Responsabilidades

• 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.

Conocimientos

SQL

Python

ETL scripting

Generative AI

Teamwork

Educación

Progress toward CS/IT/Data Analytics degree

Herramientas

PowerShell

Git

Excel

Descripción del empleo

Midland States Bank in Effingham, IL, invites applications for an Intern – Associate Solution Engineer – DW. The role supports the Data Engineering team with version control, deployment processes, and preparing data models for AI-enabled workflows.

You will gain hands-on experience with SQL, Python, ETL, and scripting in PowerShell, collaborate across IT and business units, and learn how data flows drive reporting and decisions. This paid internship runs Summer 2027, Monday–Friday.