Senior Data Engineer

Kemper is one of the nations leading specialized insurers. Our success is a direct reflection of the talented and diverse people who make a positive difference in the lives of our customers every day. We believe a high-performing culture valuable opportunities for personal development and professionalchallenge and a healthy work-life balance can be highly motivating and productive. Kempers products and services are making a real difference to our customers who have unique and evolving needs. By joining our team you are helping to providean experiencetoour stakeholders that delivers on our promises.

Position Summary:

We areseekinga highly skilledSenior Data Engineerto guide the design development and delivery of our enterprise data platforms. This role requires deep technicalexpertisewith SnowflakeCore AWS Services cloud-based architecture and modern data engineering frameworks. As asenior engineer you will define architectural patterns mentor engineering teams and ensure the successful execution of strategic data initiatives that support analytics reporting and business intelligence efforts across the organization.

PositionResponsibilities:

Technical Leadership & Architecture

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

• Define and evolve the enterprise data architectureleveragingSnowflake Data Vault 2.0 and modernevent driven andELT frameworks.

• Lead architecture reviewsestablishengineering best practices and guide platform modernization efforts.

• Mentor engineering team membersfacilitatecode reviews and promote continuous learning and innovation.

Solution Design &DataEngineering

• Architect and oversee the delivery of scalable data pipelines ingestion frameworks and transformation processes using Snowflake Python Spark Informatica (PowerCenter/IDMC) AWS Glue and cloud-native tooling.

• Design andmaintainenterprise data models including Data Vault 2.0 (Hubs Links Satellites PIT Bridge structures) and dimensional models.

• Develop andoptimizeSnowflake platform capabilities including:

• Snowpipe Streams Tasks File Formats External Stages

• Dynamic Tables and ELT pipeline automation

• Warehouse sizing performance tuning and cost optimization

• Implement scalable batch micro-batch and real-time ingestion solutions following best practices.

Stakeholder Engagement & Delivery Ownership

• Translate complex business requirements into technical design specifications and actionable development plans.

• Partner with product owners business stakeholders architects and analytics teams to deliver high-impact data solutions.

• Manage technical execution across multiple initiatives ensuring alignment with enterprise priorities data strategies and delivery timelines.

• Oversee documentationdeploymentreadiness testing processes and quality assurance for production releases.

Operational Excellence & Production Support

• Ensure operational reliability data accuracy and performance of enterprise data warehouse and analytical environments.

• Lead root-cause analysis for production issues and drive implementation of long-term preventative solutions.

• Implement robust monitoring frameworks using tools such as Snowflake Resource Monitors CloudWatch Datadog or equivalent observability platforms.

• Conduct performance optimization on Snowflake workloads SQL queries pipelines and integrations.

PositionQualifications:

• 8 years of experience in data engineering with 2 years ina senior lead or architect capacity.

• Advanced hands-onexpertisein Snowflake including constant learning on advanced new features.

• Strong experience implementing Data Vault 2.0 models and automated ELT frameworks.

• Proficiencywith ETL/ELT and data integration tools such as Informatica IDMCPowerCenterPentaho AWS GlueControl Mand 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 SQLexpertisewith 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.

Preferred Qualifications:

• Experience with advanced Snowflake features:

• Snowpark (Python/Java/Scala)

• Snowflake Warehouses Databases Schemas RBAC

• Snowpipe Tasks Streams Stages File Formats

• Performance tuning warehouse optimization clustering

• Data sharing secure data sharing reader accounts

• AI/ML Function

• Experience with modernDataOps DevOps and automation frameworks:

• CI/CD (GitHub Actions GitLab CI Azure DevOps)

• Infrastructure-as-Code(TerraformCloudFormation)

• Automated testing frameworks for data pipelines

• Familiarity with data quality and governance tools such as Great Expectations Monte CarloDatafold Soda Alation or Collibra.

• Experience with streaming technologies such as Kafka Kinesis or MSK.

• Exposure to ML feature engineering pipelines orMLOpspractices.

• P& C Insurance industry experience specifically auto insurance experienceand is strongly preferred.

• Prior experienceon data warehousing with GuidewirePolicyCenterClaimCenterorBillingCenterand Agency Licensing datais preferred

• Bachelors degree in Computer Science Information Systems Engineering or equivalent relevant experience/certifications.

Why Join Us

• Opportunity to lead the technical direction of an enterprise-wide data platform.

• Work with modern cloud-native technologies and shape the future of the organizations data strategy.

• Collaborative growth-oriented environment with strong investment in data modernization.

• Sponsorship is not accepted for this opportunity.

• This position can be worked hybrid out of a local Kemper office including Chicago IL Birmingham AL Richardson TX or JacksonvilleFL. For non-local candidates remote options with travel are available.

The range for this position is $99000 to $164800. Whendeterminingcandidate offers we consider experience skills education certifications and geographic location among other factors. This job is eligible for an annual discretionary bonus and Kemper benefits (Medical Dental Vision PTO 401k etc.)

Kemper is proud to be an equal opportunity employer. All applicants will be considered for employment without attention to race color religion sex sexual orientation gender identity national origin veteran disabilitystatusor any other status protected by the laws or regulations in the locations where weoperate. We are committed to supporting diversity and equality across ourorganizationand we work diligently to maintain a workplace free from discrimination.

Kemper does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property ofKemperand Kemper will not beobligatedto pay a placement fee.

Kemper will never request personal information such as your social security number or banking information via text or Kemper does not use external messaging applications like WireApp or Skype to communicate with you receive such a messagedeleteit.

#LI-JO1

#LI-Hybrid