Enterprise Data Solutions Intern - Summer 2026

CCU • Lake Forest, IL

5d • $21 - $23 • Onsite

About The Position

Consumers Credit Union (CCU) is one of the largest, fastest growing credit unions in Illinois! Every year we look for a diverse group of hardworking students to join our IGNITE Intern Program. What does IGNITE mean to us and what can you expect? I nterns G rowing, N etworking, and I nnovating through T ransformational E xperiences. We hire college students because we believe in fresh ideas. These are not paper pushing, copy making internships. We provide real work experience to our Interns. During the Program you will interact with and get exposure to multiple departments and leaders throughout the Credit Union. You'll learn firsthand why we are a certified Great Place to Work and experience our awesome team atmosphere by working with other Interns on projects, volunteering in the community, and participating in events and educational sessions. Our intent is to create a future career path for students who have an interest in the financial services industry. IGNITE is designed to expose you to a variety of opportunities while fostering growth and learning. We are seeking students that are interested in a Summer 2026 internship supporting the Enterprise Data Solutions team . The Enterprise Data Solutions Intern will report to the Senior Data Engineer and work alongside the team to help build our new Enterprise Data Warehouse (EDW) in Snowflake. In this role, you’ll gain hands-on experience designing data architecture, building Extract, Transform, and Load (ETL) processes, creating tables and output datasets, and working with data definitions to make data AI-ready. This internship is a great opportunity to learn modern data engineering, data governance, and analytics architecture while contributing to real projects that will shape how CCU uses data and AI in the future.

Requirements

• Currently attending an accredited college or university.
• Rising juniors and seniors working toward a bachelor's degree in Computer Science, Data Engineering, or a related major. Rising sophomores may be considered.
• Minimum 3.0 GPA.
• Ability to work 32 hours per week for the summer (generally 8:00-5:00 Monday-Thursday) for the duration of the 12-week program (5/26/2026 – 8/13/2026). The schedule will involve onsite days based in Lake Forest, IL. Local candidates only.
• Proficient with Word, PowerPoint, Excel and the wider Microsoft Office suite including email, calendaring, and instant messaging.
• Completed work in data related courses.
• Basic knowledge and experience in a BI tool such as Domo or Power BI, working with EDW development, Snowflake experience preferred.
• Problem solving and critical thinking skills.
• Professional written and verbal communication skills.
• Ability to work independently after receiving work direction.

Nice To Haves

• Snowflake experience preferred.

What This Job Offers

• Job Type: Part-time
• Career Level: Intern
• Number of Employees: 501-1,000 employees