LiftmyCVLiftmyCV

Summer 2027 Intern - Data Engineer

American Family Mutual Insurance Company, S.I.On-siteMadison, US$52,000–$81,000 per year
AI job summary

Join American Family Insurance as a Data Engineer intern during summer 2027. This internship, lasting 10 to 14 weeks, will involve building and enhancing data pipelines using SQL, Python, and cloud technologies, along with analyzing data issues and supporting troubleshooting. Interns will engage in impactful projects, provide creative solutions, and gain exposure to various business areas. A one-time housing assistance bonus may be available. Ideal candidates are students at accredited colleges, graduating later than August 2027. Benefits include comprehensive medical and 401(k) plans.

Job description

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 to request a reasonable accommodation. #LI-AB1

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.

Job details

Published
October 21, 2026
Experience
Intern
Job source
myworkdayjobs
Workplace
On-site · Madison, US
First seen
October 22, 2026

Skills mentioned in this job

SQLPythonGCPAWS

LiftmyCV exclusive data

American Family Mutual Insurance Company, S.I. hiring intelligence

American Family Mutual Insurance Company, S.I. currently has 2 active jobs tracked by LiftmyCV. 2 new jobs in the past 7 days.

Active openings

2

Currently tracked by LiftmyCV

New in 7 days

2

2 new jobs in the past 30 days

Published salaries

—

Not published by this employer yet

Average opening age

2 days

Across 2 active openings

Workplace breakdown

Remote0%
Hybrid0%
On-site100%

Most in-demand roles

  • • Lead Automation Network Engineer
  • • Sales District Leader - Denver, CO Metro (Primarily Field)

As of November 18, 2026

Hiring insights calculated from active jobs tracked by LiftmyCV.

AI match explained

See how well you match this job

Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.

Sign up to see your matchAlready have an account? Log in

Visa sponsorship insights

Visa sponsorship available

This job posting states that visa sponsorship is available for qualified candidates.

More at American Family Mutual Insurance Company, S.I.

Similar jobs from this company

Across the market

Similar jobs from other companies

Related job searches

Third-party content disclaimer

Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.

LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.

LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.

If you prefer, you may apply directly via the original listing for transparency.