Senior Data Engineer
kemperChicago, IL
Senior Data Engineer
L6
Overview:
In this role you guide the design, development, and delivery of enterprise data platforms. You’ll set architectural patterns, mentor teams, and drive strategic data initiatives across analytics, reporting, and BI. You work with modern cloud-native tech to modernize platforms and ensure reliable, scalable data solutions. This is an opportunity to shape Kemper’s data strategy and partner with cross-functional stakeholders to deliver high-impact data products. Compensation / Benefits Medical Dental Vision PTO 401k annual discretionary bonus
Responsibilities:
Provide technical leadership and set standards for solution design, data governance, and quality Define enterprise data architecture using Snowflake, Data Vault 2.0, and ELT/ event-driven frameworks Lead architecture reviews, establish engineering best practices, and guide platform modernization Mentor engineers, conduct code reviews, and foster continuous learning and innovation Architect and oversee scalable data pipelines, ingestion, and transformations using Snowflake, Python, Spark, Informatica IDMC/PowerCenter, AWS Glue Design and maintain enterprise data models (Data Vault 2.0, dimensional models) Develop Snowflake capabilities (Snowpipe, Streams, Tasks, external stages, dynamic tables) and optimize ELT pipelines and performance Translate business requirements into technical designs, partner with product owners and analytics teams Ensure production releases readiness, testing, and quality assurance Maintain operational reliability, data accuracy, and performance of data warehouses and analytics environments Lead root-cause analysis for production issues and implement long-term solutions Implement monitoring with Snowflake Resource Monitors, CloudWatch, Datadog or equivalent Optimize SQL, pipelines, and integrations for performance
Key requirements:
8+ years in data engineering 2+ years in a senior/lead/architect capacity Advanced Snowflake expertise with continuous learning Strong Data Vault 2.0 modelling experience Proficiency with ETL/ELT tools (Informatica IDMC/PowerCenter, Pentaho), AWS Glue, Control M, and Python-based pipelines Deep understanding of data warehousing, dimensional modelling, ELT patterns, CDC, and metadata-driven design Experience with orchestration frameworks (Control-M, Airflow) Strong SQL, stored procedures, Snowflake Scripting, and query optimization Experience delivering large-scale AWS-based data platforms Proven leadership in guiding teams and architecture decisions Excellent communication and cross-functional collaboration skills Bachelor’s degree in Computer Science, Information Systems, Engineering or equivalent Preferred: Snowflake Snowpark, data sharing, MLOps exposure, CI/CD, IaC (Terraform, CloudFormation), data quality/governance tools (Great Expectations, Monte Carlo, Datafold, Soda, Alation, Collibra) Experience with Kafka/Kinesis/MSK for streaming P&C Insurance industry experience preferred Collaborative Strong communication Leadership and mentoring Snowflake (including Snowpipe, Streams, Tasks, RBAC) Data Vault 2.0 modelling (Hubs, Links, Satellites, PIT) Python
Apply now (opens in a new tab)
Level
LeadL6
Location
Chicago, IL
Occupation
Data Warehousing Specialists
Industry
Computer Systems Design Services
Posted
today
To get sharper similar jobs, create your profile using the link below.