Senior Data Engineer: Hybrid Role (Snowflake/AWS)

Kemper Corporation; United States; Hybrid; USD 99,000 - 165,000; Full time

Benefits offered by this job

Annual discretionary bonus

Kemper benefits

Job summary

Kemper Corporation in Chicago, IL is seeking a Senior Data Engineer to guide the design, development, and delivery of our enterprise data platforms. You will leverage Snowflake, AWS, Python, Spark, and ELT frameworks to support analytics, reporting, and business intelligence initiatives across the organization.

The role emphasizes technical leadership, architecture reviews, and mentoring junior engineers. A hybrid work model is available from multiple Kemper offices with occasional travel as

Qualifications

• 8+ years of experience in data engineering, with 2+ years in a senior, lead, or architect capacity.
• Advanced hands-on expertise in Snowflake, including constant learning on advanced new features.
• 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; Dimensional modeling and relational structures; ELT patterns, CDC frameworks, and metadata-driven design; Orchestration frameworks (Control-M, Airflow).
• Strong SQL expertise with experience in 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 with the ability to partner across technical and business teams.

Responsibilities

• Architect and oversee the delivery of scalable data pipelines, ingestion frameworks, and transformation processes using Snowflake, Python, Spark, Informatica IDMC/PowerCenter, AWS Glue, and cloud-native tooling.
• Design and maintain enterprise data models, including Data Vault 2.0 and dimensional models.
• Develop and optimize Snowflake platform capabilities, including Snowpipe, Streams, Tasks, and performance tuning.
• Translate complex business requirements into technical design specifications and actionable development plans.
• Partner with product owners, stakeholders, architects, and analytics teams to deliver high-impact data solutions.
• Oversee documentation, deployment readiness, testing processes, and quality assurance for production releases.
• Lead root-cause analysis for production issues and drive long-term preventative solutions.

Skills

Snowflake

Data Vault 2.0

ETL/ELT

SQL expertise

Leadership

Python

AWS

Data modeling

Education

B.S. in CS/IS/Engineering

Tools

Informatica IDMC

PowerCenter

Pentaho

AWS Glue

Control-M

Job description

Kemper Corporation in Chicago, IL is seeking a Senior Data Engineer to guide the design, development, and delivery of our enterprise data platforms. You will leverage Snowflake, AWS, Python, Spark, and ELT frameworks to support analytics, reporting, and business intelligence initiatives across the organization.

The role emphasizes technical leadership, architecture reviews, and mentoring junior engineers. A hybrid work model is available from multiple Kemper offices with occasional travel as