Enterprise Data Intern

American Family Insurance • Madison, WI

10d • $25 - $39

About The Position

The Enterprise Data - Enablement, Service & Support intern performs exploratory data analysis, develops scalable and extensible data pipelines, and works on cross-functional teams to develop and deploy data-driven applications and products. The intern assists with prototyping emerging technologies, builds and maintains tools that increase productivity, develops and automates data quality checks, and creates big data applications and data visualization tools. The position reports to the Senior Manager, Engineering.

This is a summer 2027 internship within American Family Insurance’s 10-to-14-week summer student program, which starts in mid-to-late May and ends in August. Interns work on impactful projects, gain exposure to different areas of the business, and have opportunities for networking and coaching. The work location is Madison, Wisconsin; the position may be full-time in-office or hybrid depending on the selected candidate’s location. Interns are not eligible for American Family Insurance Group benefits.

Requirements

• Must be a student at an accredited four-year college or university during the internship and graduating August 2027 or later.
• Must be pursuing a bachelor’s, master’s, or Ph.D.
• Major or program must align with the internship role.
• Knowledge of SQL and experience using a variety of data stores, such as RDBMS, analytic databases, and scalable document stores.
• Hands-on programming experience in Python or Java, with an emphasis on 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 such as AWS, GCP, or Azure.
• Understanding of Infrastructure as Code, such as Docker, CloudFormation, or Terraform.
• Candidates who may require visa sponsorship cannot be considered.

Responsibilities

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

Benefits

• Interns may be eligible for a one-time hiring bonus to assist with housing costs, depending on proximity to an American Family office location.
• Interns and contingent workers are not eligible for American Family Insurance Group benefits. Listed employee benefits include medical, dental, vision, and wellbeing benefits; a 401(k) contribution; a pension plan; an annual incentive; nine paid holidays; paid time off; a student loan repayment program; and paid family leave.

What This Job Offers

• Job Type: Full-time
• Career Level: Intern