Intern - Data Engineering

American Family Insurance • Madison, WI

5d • $25 - $39 • Hybrid

About The Position

As a Data Engineer intern supporting the Data Engineering - Data Product Services department, you will help build transformation tables for enterprise analytical reporting. The internship is a 10- to 14-week summer program that 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. A one-time hiring bonus to assist with housing costs may be available depending on proximity to an American Family Insurance office location.

The role involves supporting data-driven applications and products, building and testing cloud-based ETL pipelines, provisioning infrastructure, automating deployment, documenting technical implementations, and improving data quality. The position may be full-time in-office or hybrid, depending on the selected candidate's location. The listed work location is Madison, Wisconsin. Interns and contingent workers 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 graduate in August 2027 or later.
• Must be pursuing a bachelor's or master's degree in a major or program aligned with the internship role.
• Hands-on Python programming experience, particularly building ETL workflows and data-driven solutions.
• Understanding of database internals, including partitioning, indexes, and SQL optimization.
• Knowledge of cloud computing platforms such as GCP or AWS.
• Understanding of Infrastructure as Code tools or approaches such as Docker, CloudFormation, or Terraform.

Nice To Haves

• Preference for candidates graduating in August 2028 or later.

Responsibilities

• Develop an understanding of the company's business, culture, and structure to support work.
• Contribute creative ideas and strategic approaches in response to changing situations.
• Work on cross-functional teams to develop and deploy data-driven applications and products, particularly in data engineering.
• Support Python ETL frameworks using cloud services such as GCP or AWS to build pipelines that process and transform data from multiple sources.
• Develop pytest test suites, including unit tests for transformation logic and integration tests for end-to-end workflows.
• Configure and maintain Terraform modules for infrastructure provisioning, including reusable components for database resources, compute instances, and IAM permissions.
• Use GitLab CI/CD pipelines to automate testing, building, and deployment of ETL processes with environment segregation.
• Document technical implementations with architecture diagrams and runbooks for operational handoffs.
• Contribute to code reviews and implement feedback to maintain high code quality standards.
• Develop and automate data quality checks.
• Write and optimize SQL queries for Google BigQuery, Cloud SQL (PostgreSQL/MySQL), Amazon Redshift, and RDS.

Benefits

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

What This Job Offers

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