Enterprise Data Intern: Build Pipelines & Apps

American Family Insurance; Madison (WI); On-site; USD 34,000 - 54,000; Full time

Benefits offered by this job

Housing cost bonus consideration

Networking and coaching opportunities

Paid holidays and employee benefits

Job summary

American Family Insurance invites applications for the Summer 2027 Intern – Enterprise Data, Enablement, Service & Support. The internship spans 10–14 weeks, starting mid to late May and ending in August, with a potential housing cost bonus depending on proximity to an AmFam office.

Compensation ranges from $25.00 to $39.00 per hour. The intern will analyze data, build scalable data pipelines, prototype technologies, and contribute to data-driven applications under the Senior Manager,

Qualifications

• 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 (AWS, GCP, Azure).
• Understanding of Infrastructure as Code (Docker, CloudFormation, Terraform, etc.)

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.

Skills

SQL knowledge

Python or Java programming

Linux scripting

Database internals understanding

Cloud computing (AWS, GCP, Azure)

Education

Student status in accredited 4-year college or university

Tools

Docker

CloudFormation

Terraform

Job description

American Family Insurance invites applications for the Summer 2027 Intern – Enterprise Data, Enablement, Service & Support. The internship spans 10–14 weeks, starting mid to late May and ending in August, with a potential housing cost bonus depending on proximity to an AmFam office.

Compensation ranges from $25.00 to $39.00 per hour. The intern will analyze data, build scalable data pipelines, prototype technologies, and contribute to data-driven applications under the Senior Manager,