Senior Data Engineer at Kemper
Alpharetta, GA
$99,000–$164,800from the description
Jul 23, 2026
Alpharetta, GA
Jul 25, 2026
What this job asks for AI summary
A senior-level data engineering role focused on designing and maintaining enterprise data platforms at an insurance company. The position involves architecting Snowflake-based pipelines, data models (including Data Vault 2.0), and cloud infrastructure on AWS, while also providing technical leadership — setting standards, mentoring engineers, and coordinating delivery across analytics and business intelligence initiatives. Prior insurance industry experience is strongly preferred.
Senior level · 8+ years · Remote · Full-time
“or” means any one of them counts — you don't need all of them.
We read this from the posting text with AI. Skim the description below before ruling yourself out.
How this req sits in the market our data
Roughly 760 people nationally plausibly meet what this posting asks for (database architects). range 200–1,200
Applicant volume Moderate — A normal amount of company. The rare requirements below are what will separate a shortlisted application from the rest.
Most people in this occupation already list these. Still required — just not what gets you shortlisted.
What the occupation pays Median $142,568 (middle half $111,775–$173,013). This posting is about at that midpoint.
Estimated from BLS employment for this occupation and area, per-skill prevalence across our listing corpus, and published wage benchmarks — as of Jul 28, 2026. It is a model, not a headcount.
Why we read it this way (10)
The role is posted across many locations (Alpharetta GA, Birmingham AL, Chicago IL, Dallas TX, Jacksonville FL, Downers Grove IL, and several remote-US states); Chicago IL is used as the primary CBSA since it is the first major metro listed and a named hybrid office location.
The posting lists multiple remote-eligible US states (CT, MD, OH, PA, RI, VA) and explicitly states 'remote options with travel are available' for non-local candidates, so remote=true is appropriate.
A Bachelor's degree in CS/IS/Engineering is listed under Preferred Qualifications with 'or equivalent relevant experience/certifications', so it is not a hard degree gate.
Monitoring tools (CloudWatch, Datadog) appear in the required responsibilities section but are framed as 'such as … or equivalent observability platforms', indicating the specific tools are interchangeable examples rather than hard gates; marked as preferred.
Informatica IDMC and PowerCenter are listed together as interchangeable ETL tools; Pentaho is also listed as an alternative in the same requirement.
Control-M and Airflow are listed as interchangeable orchestration frameworks under required qualifications.
P&C/auto insurance industry experience is described as 'required and is strongly preferred' — contradictory framing; because it is listed under Preferred Qualifications and the 'required' qualifier appears to be rhetorical emphasis rather than a hard gate, it is treated as preferred.
Guidewire platform experience (PolicyCenter, ClaimCenter, BillingCenter) is explicitly listed under Preferred Qualifications.
Snowflake Dynamic Tables, External Stages, File Formats, and warehouse sizing/tuning are called out in the responsibilities narrative rather than a discrete required-skills block; the core Snowflake requirement (the required/preferred flag) covers these capabilities, and specific sub-features (Snowpipe, Streams, Tasks) are captured separately as they are named explicitly in requirements.
The role sits most naturally at 15-1243 (Database Architects) given its primary focus on enterprise data warehouse architecture, Data Vault 2.0 modeling, and ELT platform design; 15-1252 (Software Developers) is a reasonable runner-up given the significant pipeline coding and Python/Spark engineering work.
Read the full posting
The employer publishes the full description on their own site — read it there ↗. Or sign in to read it here — it's free, and it also lets you track this application.