Senior Data Engineer

American Family Insurance

Senior Data Engineer building and integrating big data applications for American Family Insurance. Collaborating with cross-functional teams to enhance analytics applications within the big data platform.

Posted 4/29/2026full-timeMadison • Wisconsin • 🇺🇸 United StatesSenior💰 $99,000 - $167,000 per yearWebsite

Tech Stack

Tools & technologies

AWSAzureCloudDockerETLGoogle Cloud PlatformHadoopJavaJenkinsPythonRDBMSSparkSQLTerraform

About the role

Key responsibilities & impact

Performs exploratory data analysis to determine which questions can be answered effectively with a given dataset and has the ability to analyze new (possibly unstructured) data sources to determine what additional value they may bring.
Designs and develops highly scalable and extensible data pipelines from internal and external sources.
Works on cross-functional teams to design, develop, and deploy data-driven applications and products, particularly within the space of data science.
Prototypes emerging technologies involving data ingestion and transformation, distributed file systems, databases and frameworks.
Designs, builds, and maintains tools to increase the productivity of application development and client facing teams.
Partners with business analyst to define, develop, and automate data quality checks.
Designs and develops big data applications and data visualization tools.

Requirements

What you’ll need

Demonstrated experience providing customer-driven solutions, support or service.
In-depth 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.
Experience with big data batch computing tools (e.g. Hadoop or Spark) and developing distributed data processing solutions.
Experience with cloud computing platforms (e.g. AWS, GCP, Azure)
Good data understanding and business acumen in the data rich industries like insurance or financial.
Solid understanding of data modeling principles (e.g. dimensional modeling and star schemas).
Solid understanding of database internals, such as indexes, binary logging, and transactions.
Solid understanding of Infrastructure as Code (e.g. Docker, CloudFormation, Terraform, etc.)
Solid understanding of with software engineering tools and workflows (i.e. Jenkins, CI/CD, git).

Benefits

Comp & perks

comprehensive medical, dental, vision and wellbeing benefits
401(k) contribution
pension plan
annual incentive
9 paid holidays
paid time off program (23 days accrued annually for full-time employees)
student loan repayment program
paid-family leave

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 & Tools

SQLPythonJavaETLHadoopSparkAWSGCPAzuredata modeling

Soft Skills

customer-driven solutionsbusiness acumencross-functional teamwork