Location: WI Madison
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
Job description provided by American Family Insurance.
View the original posting