Enterprise Data Intern

American Family Insurance Agency Staff; Madison (WI); Hybrid; USD 34,000 - 54,000; Full time

Benefits offered by this job

Housing assistance (bonus)

Job summary

American Family Insurance is offering a Summer 2027 Intern position in Enterprise Data - Enablement, Service & Support in Madison, WI. The 10–14 week program starts mid to late May and provides hands-on experience with data pipelines, data-driven apps, and cross-functional collaboration.

You will perform exploratory data analysis, prototype emerging technologies, build scalable data workflows, and contribute to data quality checks while reporting to the Senior Manager, Engineering.

Qualifications

• Must be enrolled as a student at an accredited 4-year college or university.
• Graduating August 2027 or later.
• Major aligned with internship role.
• Knowledge of SQL and experience using data stores (RDBMS, analytic databases, etc.).
• Hands-on programming experience in Python or Java, focusing on ETL workflows.

Responsibilities

• Develop understanding of the business, culture, and structure to support your work.
• Contribute ideas in response to changing situations.
• Perform exploratory data analysis to answer questions from datasets.
• Develop scalable data pipelines from internal and external sources.
• Work on cross-functional teams to deploy data-driven applications and products.
• Prototype emerging technologies in data ingestion and transformation.
• Build and maintain tools to boost productivity for developers and clients.
• Develop and automate data quality checks.
• Create big data applications and data visualization tools.

Skills

SQL knowledge

Python or Java programming

Linux scripting

Database internals

Cloud platforms

Infrastructure as Code

Education

Pursuing Bachelor/Master/PhD

Tools

Docker

CloudFormation

Terraform

AWS

GCP

Azure

Job description

Description

Summer 2027 Intern - Enterprise Data - Enablement, Service & Support

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

The Enterprise Data - Enablement, Service & Support intern will perform exploratory data analysis, develop scalable and extensible data pipelines, work on cross-functional teams to develop and deploy data-driven applications and products, assist with prototyping emerging technologies, build and maintain tools to increase the productivity, develop and automate data quality checks, and develop big data applications and data visualization tools. You will report to the Senior Manager, Engineering.

Responsibilities

• You will develop an understanding of our business, corporate culture and structure to support your work.
• You will contribute creative ideas and strategic approaches in response to changing situations.
• You will perform exploratory data analysis to determine which questions can be answered effectively with a given dataset.
• You will develop highly scalable and extensible data pipelines from internal and external sources.
• You will work on cross-functional teams to develop and deploy data-driven applications and products, particularly within the space of data science.
• You will assist with prototyping emerging technologies involving data ingestion and transformation, distributed file systems, databases and frameworks.
• You will build and maintain tools to increase the productivity of application development and client facing teams.
• You will develop and automate data quality checks.
• You will develop big data applications and data visualization tools.

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.
• Knowledge of SQL and experience using a variety of data stores (e.g. RDBMS, analytic database, scalable document stores).
• Hands-on programming experience in Python or java, with an emphasis towards building ETL workflows and data-driven solutions.
• Working familiarity with Linux scripting to automate workflows.
• Understanding of database internals, such as indexes, binary logging, and transactions.
• Knowledge of cloud computing platforms (e.g. AWS, GCP, Azure).
• Understanding of Infrastructure as Code (e.g. Docker, CloudFormation, Terraform, etc.)

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. The work locations for this role is Madison, WI.

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 [e-mail] to request a reasonable accommodation.