Summer 2027 Intern - Data Engineer

Posted Yesterday
Be an Early Applicant
Madison, WI, USA
Hybrid
25K-39K Hourly
Internship
Insurance
The Role
Supports the development and enhancement of data pipelines using SQL, Python, and cloud technologies. Analyzes data issues, performs quality checks, troubleshoots problems, documents solutions, and collaborates with engineering and business teams to deliver reliable data for analytics and reporting.
Summary Generated by Built In
As a Data Engineer intern for American Family Insurance, you will assist in building and enhancing data pipelines using SQL, Python and cloud technologies; analyze data issues, perform quality checks and support troubleshooting and resolution; work with engineering and business teams to document solutions and deliver reliable data for analytics and reporting.
An internship with American Family Insurance is a great opportunity to build your skillset and explore your career interests. Our summer student internship is a 10 to 14 week program that starts in mid to late May and ends in August.
During your internship, you'll work on impactful projects that make a difference at our company, with our customers, and in our communities. You'll also gain exposure to different areas of our business and have numerous opportunities for networking and coaching.
Interns may be eligible for a one-time hiring bonus to assist with housing costs depending upon proximity to an AmFam office location.

Compensation Minimum: $25.00
Compensation Maximum: $39.00

Responsibilities:


  • Develop an understanding of our business, corporate culture and structure to support your work. 
  • Contribute creative ideas and strategic approaches in response to changing situations. 
  • Build and enhance data pipelines using SQL, Python, and cloud technologies like GCP, AWS.
  • Analyze data issues, perform quality checks, and support troubleshooting and resolution.
  • Work with engineering and business teams to document solutions and deliver reliable data for analytics and reporting.
    Specialized Knowledge & Skills Requirements

  • Must be in student status at an accredited 4-year college or university during the internship, graduating August 2027 or later. 
  • Must be pursuing a Bachelors, Masters, or PhD. 
  • Major/program must align with internship role. 
  • Strongly prefer candidates graduating in August 2027, December 2027 or May 2028.August 
  • SQL, Python and cloud technologies like GCP or AWS.
    Licenses
    • Not applicable.
    Travel Requirements
    • Up to 10%.
    Physical Requirements
    • Work that primarily involves sitting/standing.
    Working Conditions
    • Not applicable.

Additional Information
  • To ensure a strong start, all employees participate in our New Employee Orientation during their first week.  This experience is held in person at our Madison, WI Headquarters or one of our AmFam core locations to help you connect with our mission, meet key team members and build relationships that support your growth.  At times, sessions may be delivered virtually based on scheduling and availability. 
  • Offer to selected candidate will be made contingent on the results of applicable background checks
  • Offer to selected candidate is contingent on signing a non-disclosure agreement for proprietary information, trade secrets, and inventions
  • Sponsorship will not be considered for this position unless specified in the posting

Due to the nature of this role, we are unable to consider candidates who may require visa sponsorship.

Work Location:

This role may be considered for a Full-Time in Office or Hybrid work arrangement based on the selected candidate's location. Work locations for this role include Madison, WI.


#LI-Hybrid


We provide benefits that support your physical, emotional, and financial wellbeing. You will have access to comprehensive medical, dental, vision and wellbeing benefits that enable you to take care of your health. We also offer a competitive 401(k) contribution, a pension plan, an annual incentive, 9 paid holidays and a paid time off program (23 days accrued annually for full-time employees). In addition, our student loan repayment program and paid-family leave are available to support our employees and their families. Interns and contingent workers are not eligible for American Family Insurance Group benefits.

We are an equal opportunity employer. It is our policy to comply with all applicable federal, state and local laws pertaining to non-discrimination, non-harassment and equal opportunity. We also consider qualified applicants with criminal histories, consistent with applicable federal, state and local law.

American Family Insurance is committed to the full inclusion of all qualified individuals. If a reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please email [email protected] to request a reasonable accommodation.

#LI-AB1

Skills Required

  • Must maintain student status at an accredited four-year college or university during the internship.
  • Must graduate in August 2027 or later.
  • Must be pursuing a bachelor's, master's, or PhD degree.
  • Major or academic program must align with the internship role.
  • Knowledge of SQL, Python, and cloud technologies such as GCP or AWS.
  • Graduation in August 2027, December 2027, or May 2028 is strongly preferred.

American Family Insurance Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about American Family Insurance and has not been reviewed or approved by American Family Insurance.

  • Pay Growth & Progression — Compensation has seen multiple increases, including a higher internal minimum hourly wage effective 2025 for many customer‑facing and claims roles. These moves indicate continued investment to raise the pay floor and improve total rewards competitiveness.
  • Retirement Support — The total package includes a 401(k) with company match alongside a company‑funded cash‑balance pension, strengthening long‑term financial security. This combination is positioned as a standout element within the overall benefits mix.
  • Parental & Family Support — Paid parental leave was expanded in 2025 for birthing parents and for all parents, including adoptive and foster. Caregiver leave adds further family support within the leave portfolio.

American Family Insurance Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Madison, WI
16,528 Employees
Year Founded: 1927

What We Do

For more than 85 years, American Family Insurance has built its reputation on sound principles. We strive to provide you industry-leading service, exceptional claims experience and products that build long-term relationships. This is accomplished by treating policyholders fairly in a helpful and caring way and making it easy and convenient to work with us. We know our customers like family. American Family Insurance thrives by conducting its business in accordance with the highest ethical standards and the law at all times. Integrity is part of our culture and always has been. The reputation we enjoy and trust-based relationships we have built with our customers are determined by the example set by management and the character and good judgment exercised at all levels of our organization. It’s a way of doing business that our customers have come to expect from us and a standard that we continue to live up to.

Similar Jobs

Hilton Logo Hilton

Sales Manager

Events • Food • Travel • Hospitality • Hotels & Resorts
In-Office or Remote
2 Locations
500000 Employees
40K-100K Annually

MongoDB Logo MongoDB

Senior Software Engineer

Big Data • Cloud • Software • Database
Easy Apply
Remote or Hybrid
United States
5550 Employees
101K-273K Annually

MongoDB Logo MongoDB

Senior Forward Deployment Engineer

Big Data • Cloud • Software • Database
Easy Apply
Remote or Hybrid
13 Locations
5550 Employees
0-0 Annually

CrowdStrike Logo CrowdStrike

Sales Engineer

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
2 Locations
11000 Employees
75K-115K Annually

Similar Companies Hiring

MassMutual India Thumbnail
Big Data • Fintech • Information Technology • Insurance • Financial Services
Hyderabad, Telangana
Granted Thumbnail
Artificial Intelligence • Healthtech • Insurance • Mobile • Financial Services
New York, New York
23 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account