Senior Data Engineer

Kemper

. Provide technical leadership to data engineers and set standards for solution design, coding practices, data governance, and quality .

Posted 10/26/2026full-timeUnited StatesSenior💰 $99,000 - $164,800 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates advanced expertise in Snowflake and Data Vault 2.0, with a strong focus on designing scalable data architectures and implementing ELT frameworks. Proven leadership in mentoring teams, optimizing data pipelines, and ensuring data quality and performance in enterprise environments.

Highest-signal resume keywords

Advanced Snowflake ExpertiseData Vault 2.0 ImplementationETL/ELT ProficiencySQL Query OptimizationLeadership in Data Engineering

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

Data EngineeringData ArchitectureDimensional ModelingData GovernanceData Pipeline DesignPerformance TuningCloud-Based Data PlatformsEvent-Driven FrameworksAutomated ELT FrameworksRoot-Cause Analysis

Soft Skills

Excellent CommunicationCollaboration SkillsMentoringFacilitation

Tools & Technologies

SnowflakeInformatica IDMCAWS GlueControl-MAirflowDatadogCloudWatchPython

Certifications & Qualifications

Bachelor’s Degree in Computer ScienceInformation SystemsEngineering

Industry Keywords

P&C InsuranceAuto InsuranceData WarehousingAnalytics EngineeringMetadata-Driven Design

Tech Stack

Tools & technologies

AirflowAWSETLInformaticaPythonSQLVault

About the role

Key responsibilities & impact

Provide technical leadership to data engineers and set standards for solution design, coding practices, data governance, and quality
Define and evolve enterprise data architecture using Snowflake, Data Vault 2.0, event-driven frameworks, and ELT frameworks
Lead architecture reviews, establish engineering best practices, and guide platform modernization
Mentor engineering team members, facilitate code reviews, and promote continuous learning and innovation
Architect and oversee scalable data pipelines, ingestion frameworks, and transformation processes
Design and maintain enterprise data models, including Data Vault 2.0 and dimensional models
Develop and optimize Snowflake platform capabilities, including Snowpipe, Streams, Tasks, File Formats, External Stages, Dynamic Tables, warehouse sizing, performance tuning, and cost optimization
Implement scalable batch, micro-batch, and real-time ingestion solutions
Translate business requirements into technical design specifications and development plans
Partner with product owners, business stakeholders, architects, and analytics teams
Manage technical execution across multiple initiatives and align delivery with enterprise priorities and timelines
Oversee documentation, deployment readiness, testing, and quality assurance for production releases
Ensure reliability, data accuracy, and performance of enterprise data warehouse and analytical environments
Lead root-cause analysis for production issues and implement preventative solutions
Implement monitoring frameworks using Snowflake Resource Monitors, CloudWatch, Datadog, or equivalent platforms
Optimize Snowflake workloads, SQL queries, pipelines, and integrations

Requirements

What you’ll need

8+ years of experience in data engineering
2+ years in a senior, lead, or architect capacity
Advanced hands-on expertise in Snowflake
Strong experience implementing Data Vault 2.0 models and automated ELT frameworks
Proficiency with ETL/ELT and data integration tools such as Informatica IDMC, PowerCenter, Pentaho, AWS Glue, Control-M, and Python-based pipelines
Deep understanding of data warehousing and analytics engineering principles
Deep understanding of dimensional modeling and relational structures
Deep understanding of ELT patterns, CDC frameworks, and metadata-driven design
Experience with orchestration frameworks such as Control-M and Airflow
Strong SQL expertise, including stored procedures, Snowflake Scripting, and complex query optimization
Hands-on experience designing and delivering large-scale AWS-based data platforms
Demonstrated leadership in guiding teams, influencing architecture decisions, and managing technical delivery
Excellent communication and collaboration skills
Experience with P&C Insurance industry, specifically auto insurance, required and strongly preferred
Bachelor’s degree in Computer Science, Information Systems, Engineering, or equivalent relevant experience/certifications
Sponsorship is not accepted for this opportunity

Benefits

Comp & perks

Annual discretionary bonus
Medical benefits
Dental benefits
Vision benefits
Paid time off (PTO)
401(k)
Hybrid work option from a local Kemper office
Remote options with travel for non-local candidates
Opportunity to lead the technical direction of an enterprise-wide data platform
Work with modern cloud-native technologies and shape the organization’s data strategy
Collaborative, growth-oriented environment with strong investment in data modernization