Intern - Data Engineering

American Family Insurance; Madison (WI); Ibrido; USD 34.000 - 54.000; Tempo pieno

Vantaggi offerti da questo lavoro

Housing bonus eligibility

Networking & coaching opportunities

Descrizione del lavoro

American Family Insurance is seeking a Data Engineer intern for the Data Product Services team in Madison, WI. The role focuses on building transformation tables for enterprise analytics and supporting Python ETL workflows across cloud environments.

You will work on cross-functional teams, gain exposure to multiple business areas, and contribute to data-driven applications while developing your skills through coaching and networking opportunities.

Competenze

• Must be enrolled in an accredited 4-year college, graduating August 2027 or later.
• Pursuing a Bachelor's or Master's degree aligned with internship role.
• Hands-on Python programming focused on ETL workflows.

Mansioni

• Support ETL development and data transformation pipelines.
• Contribute to cross-functional teams on data-driven applications.
• Create and maintain pytest test suites for pipelines.
• Document architectures and runbooks for handoffs.
• Review code and implement feedback to improve quality.
• Build SQL queries for BigQuery, Cloud SQL, Redshift, and RDS.

Conoscenze

Python

ETL workflows

SQL

Cloud platforms

Infrastructure as Code

Formazione

Pursuing Bachelor's/Master's

Graduating Aug 2027 or later

Strumenti

Terraform

Docker

CloudFormation

GitLab CI/CD

BigQuery

Descrizione del lavoro

As a Data Engineer intern supporting the Data Engineering - Data Product Services department you will support the team building transformation tables for enterprise analytical reporting.

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

Responsibilities:

• Develop an understanding of our business, corporate culture and structure to support your work.
• Contribute creative ideas and strategic approaches in response to changing situations.
• Works on cross-functional teams to develop and deploy data-driven applications and products, particularly within the space of data engineering.
• Support Python ETL frameworks using Cloud (e.g. GCP, AWS) Services to build data pipelines that efficiently process and transform data from multiple sources
• Develop comprehensive pytest test suites to ensure data pipeline reliability, including unit tests for transformation logic and integration tests for end-to-end workflows.
• Configure and maintain Terraform modules for infrastructure provisioning, focusing on creating reusable components for database resources, compute instances, and IAM permissions
• Utilize GitLab CI/CD pipelines to automate testing, building, and deployment of ETL processes with proper environment segregation
• Document technical implementations with clear architecture diagrams and runbooks to support operational handoffs
• Contribute to code reviews and implement feedback to maintain high code quality standards across ETL codebase
• Develops and automates data quality checks.
• Write and optimize SQL queries for various data platforms including Google BigQuery, Cloud SQL (PostgreSQL/MySQL), Amazon Redshift, and RDS

Specialized Knowledge & Skills 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. Major/program must align with internship role.
• Hands‑on programming experience in Python, with an emphasis towards building ETL workflows and data-driven solutions.
• Understanding of database internals, such as partitioning, indexes and SQL optimization.
• Knowledge of cloud computing platforms (e.g. GCP, AWS).
• Understanding of Infrastructure as Code (e.g. Docker, CloudFormation, Terraform, etc.)
• Strongly prefer candidates graduating in August 2028 or later.

Licenses

• Licenses Not applicable.

Travel Requirements

• Up to 10%.

Physical Requirements

• Work that primarily involves sitting/standing.

Working Conditions

• Not applicable.

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.

Work locations for this role include Madison, WI.

Benefits:

• 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
• a paid time off program (23 days accrued annually for full-time employees)
• our student loan repayment program
• paid-family leave
• Interns and contingent workers are not eligible for American Family Insurance Group benefits.

We also consider qualified applicants with criminal histories, consistent with applicable federal, state and local law.

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. 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.

#LI-AB1 American Family Insurance, based in Madison, Wis., has been serving customers since 1927. We inspire, protect and restore dreams through our insurance products, exceptional service from our agency owners and employees, community investments and creative partnerships.

American Family Insurance is the nation’s 12th-largest property/casualty insurance company, ranking No. 202 on the Fortune 500 list.

American Family has a current ‘a+’ credit rating through AM Best, and has distinction as a “Standing the Test of Time” company, which is represented by having an AM Best financial strength rating of ‘A’ or better for at least 75 years. The company offers American Family‑brand products through a network of exclusive agency owners as well as nationwide through key strategic partnerships.

American Family Insurance also includes Homesite and Main Street America Insurance. The company has approximately 10,500 employees nationwide.

Join our Talent Community