About the role#
This internship offers hands-on experience building and optimizing cloud-native data pipelines. You will work with modern big data technologies and AI workflows at our headquarters in Monroe, Wisconsin. The program runs from May through August 2027.
What you'll do#
- Design, develop, test, and deploy scalable data pipelines and cloud solutions on AWS.
- Build and maintain ETL/ELT workflows using Python, Spark, and PySpark to process large-scale datasets.
- Collaborate with cross-functional teams to design data models using PostgreSQL and Amazon Redshift.
- Ingest, transform, and distribute data from multiple sources.
- Write and optimize complex SQL queries to support analytics and reporting.
- Assist with data quality monitoring, governance, and observability practices.
- Prepare data for machine learning models and integrate AI-powered automation.
- Utilize AWS AI services such as Amazon Kiro, Amazon Quick, and Amazon Q.
What you'll need#
- Currently pursuing a degree in Software Engineering, Computer Science, Data Science, MIS, Mathematics, or a related field.
- Junior or Senior standing, though recent graduates may be considered.
- Cumulative GPA of 2.80 or higher.
- Proficiency in Python and SQL.
- Ability to troubleshoot pipeline issues and debug code independently.
- Strong communication skills for both technical and non-technical audiences.
- Experience with Spark, PySpark, or distributed data processing is a plus.
- Familiarity with AWS services like S3, Redshift, Glue, Lambda, and EMR is helpful.
- Understanding of columnar database architectures and ETL/ELT workflows is beneficial.
- Exposure to AI/ML concepts or generative AI tools is a plus.
Location & details#
- This is a paid, full-time, on-site internship located in Monroe, Wisconsin.
- We do not offer immigration sponsorship for this position.
About Colony Brands, Inc.
Colony Brands, Inc. is a direct marketing company based in Monroe, Wisconsin. Founded in 1926, the firm operates as a multi-channel business with a portfolio that includes food, apparel, and kitchen appliances. It employs between 1,001 and 5,000 people. The company manages various brands such as Ashro, Beauty Boutique, and Country Door.
How to get in at Colony Brands, Inc.
Applying to Colony Brands early is your best strategy for getting noticed before the applicant pool grows too large. Intern Insider sends an instant alert the moment a role matching your target is published, which helps you stay ahead of the competition. Securing a spot in that initial batch of resumes often makes the difference in getting a recruiter to look at your application. You can improve your response rate by reaching out to the people actually managing the hiring process. Intern Insider surfaces the recruiters behind the company roles so you can contact them directly. A brief, professional message to the right person is often more effective than waiting for a response from a general portal.
