Senior Data Engineer
Kemper Corporation17 days ago
Chicago, IL, USA +3 moreSenior
Base Salary
$99k - $165k/yr
Responsibilities
- Provide technical leadership to data engineers and establish standards for solution design, coding, data governance, and quality.
- Define and evolve enterprise data architecture using Snowflake, Data Vault 2.0, event-driven patterns, and ELT frameworks.
- Architect scalable data pipelines, ingestion frameworks, transformation processes, and enterprise data models.
- Develop and optimize Snowflake capabilities including Snowpipe, Streams, Tasks, file formats, external stages, dynamic tables, warehouse sizing, performance, and cost optimization.
- Implement batch, micro-batch, and real-time ingestion solutions.
- Lead architecture reviews, code reviews, platform modernization, mentoring, and continuous learning.
- Translate business requirements into technical specifications and development plans while coordinating delivery across multiple initiatives.
- Oversee documentation, deployment readiness, testing, quality assurance, and production releases.
- Ensure reliability, data accuracy, and performance of enterprise data warehouse and analytical environments.
- Lead root-cause analysis and preventative solutions for production issues.
- Implement monitoring and observability using Snowflake Resource Monitors, CloudWatch, Datadog, or equivalent tools.
- Optimize Snowflake workloads, SQL queries, pipelines, and integrations.
Requirements
- 8+ years of experience in data engineering.
- 2+ years of experience in a senior, lead, or architect capacity.
- Advanced hands-on Snowflake expertise, including advanced platform features.
- Strong experience implementing Data Vault 2.0 models and automated ELT frameworks.
- Proficiency with Informatica IDMC, PowerCenter, Pentaho, AWS Glue, Control-M, and Python-based pipelines.
- Deep understanding of data warehousing, analytics engineering, dimensional modeling, relational structures, ELT, CDC, metadata-driven design, and orchestration frameworks.
- Strong SQL skills, 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 across technical and business teams.
- Preferred experience with Snowpark, Snowflake warehouses, databases, schemas, RBAC, Snowpipe, Tasks, Streams, stages, file formats, performance tuning, clustering, data sharing, secure data sharing, reader accounts, and AI/ML functions.
- Preferred experience with DataOps, DevOps, CI/CD, infrastructure-as-code, automated data pipeline testing, data quality and governance tools, streaming technologies, ML feature engineering, and MLOps.
- P&C insurance experience, specifically auto insurance experience, is required and strongly preferred.
- Preferred experience with Guidewire PolicyCenter, ClaimCenter, BillingCenter, and Agency Licensing data.
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or equivalent relevant experience/certifications.
Benefits
- Hybrid work is available from local Kemper offices in Chicago, Birmingham, Richardson, or Jacksonville; remote work with travel is available for non-local candidates.
- Eligible for an annual discretionary bonus and Kemper benefits including medical, dental, vision, PTO, and 401(k).
- Opportunity to lead the technical direction of an enterprise-wide data platform and shape the organization’s data strategy.
Tech Stack
Apache AirflowApache KafkaApache SparkAWSDatadogGitHub ActionsGitLab CI/CDJavaPythonScalaSnowflakeSQLTerraform
Categories
Data Engineering
About Kemper Corporation
Kemper Corporation is a U.S. insurer offering auto, home, life, accident and health, and specialty personal lines for individuals and small businesses, primarily under the Kemper Auto and Kemper Life brands. The company distributes policies through independent agents, brokers, and online channels, generating revenue from premiums and investment income. Founded in 1990 and headquartered in Chicago, it is a public company listed on the NYSE.