Data Engineering Intern

American Family Insurance

. Support the Data Engineering - Data Product Services department in building transformation tables for enterprise analytical reporting .

Posted 10/20/2026internshipMadison • Wisconsin • United StatesEntry Level💰 $25 - $39 per hourWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates proficiency in Python programming for ETL workflows and data-driven solutions, with a solid understanding of cloud computing platforms like GCP and AWS. Capable of configuring Infrastructure as Code using Terraform and optimizing SQL queries for various database systems.

Highest-signal resume keywords

Python ProgrammingETL WorkflowsCloud Computing (GCP, AWS)Infrastructure as Code (Terraform)SQL Optimization

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

PythonSQLETLData PipelinesDatabase InternalsUnit TestingIntegration TestingData Quality ChecksCloud ServicesAutomation

Soft Skills

Creative Problem SolvingCollaborationAdaptabilityCommunication

Tools & Technologies

GCPAWSTerraformGitLab CI/CDPytestGoogle BigQueryAmazon RedshiftCloud SQLRDSDocker

Industry Keywords

Data EngineeringData Product ServicesAnalytical ReportingInfrastructure ProvisioningCross-Functional Teams

Tech Stack

Tools & technologies

Amazon RedshiftAWSBigQueryCloudDockerETLGoogle Cloud PlatformPythonSQLTerraform

About the role

Key responsibilities & impact

Support the Data Engineering - Data Product Services department in building transformation tables for enterprise analytical reporting
Develop an understanding of the business, corporate culture and structure
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
Support Python ETL frameworks using cloud services such as GCP and AWS to build efficient data pipelines
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 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
Participate in code reviews and implement feedback
Develop and automate data quality checks
Write and optimize SQL queries for Google BigQuery, Cloud SQL, Amazon Redshift and RDS

Requirements

What you’ll need

Must be in student status at an accredited 4-year college or university during the internship
Must be graduating August 2027 or later
Must be pursuing a Bachelor's or Master's degree
Major/program must align with the internship role
Hands-on programming experience in Python, emphasizing ETL workflows and data-driven solutions
Understanding of database internals, including partitioning, indexes and SQL optimization
Knowledge of cloud computing platforms such as GCP and AWS
Understanding of Infrastructure as Code, such as Docker, CloudFormation and Terraform
Strongly preferred: candidates graduating in August 2028 or later
Up to 10% travel
Work authorization: sponsorship will not be considered; candidates requiring visa sponsorship cannot be considered
Offer contingent on applicable background checks
Offer contingent on signing a non-disclosure agreement

Benefits

Comp & perks

One-time hiring bonus may be available to assist with housing costs, depending upon proximity to an AmFam office location
Networking and coaching opportunities
Comprehensive medical, dental, vision and wellbeing benefits (interns and contingent workers are not eligible)
Competitive 401(k) contribution (interns and contingent workers are not eligible)
Pension plan (interns and contingent workers are not eligible)
Annual incentive (interns and contingent workers are not eligible)
9 paid holidays (interns and contingent workers are not eligible)
Paid time off program: 23 days accrued annually for full-time employees (interns and contingent workers are not eligible)
Student loan repayment program (interns and contingent workers are not eligible)
Paid-family leave (interns and contingent workers are not eligible)
Hybrid work arrangement may be available based on selected candidate's location