Senior Data Engineer

We are seeking a highly skilled Senior Data Engineer to guide the design, development, and delivery of our enterprise data platforms. This role requires deep technical expertise with Snowflake, Core AWS Services, cloud-based architecture, and modern data engineering frameworks. As a senior 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., 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 reviews,establishengineering best practices, and guide platform modernization efforts.
• Mentor engineering team members,facilitatecode reviews, and promote continuous learning and innovation.

Solution Design & Data Engineering

• 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 documentation,deploymentreadiness, 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., * Opportunity to lead the technical direction of an enterprise-wide data platform.
• Work with modern cloud-native technologies and shape the future of the organization's 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 Jacksonville,FL.

• 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 IDMC,PowerCenter, Pentaho, AWS Glue,Control 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(Terraform,CloudFormation)
• Automated testing frameworks for data pipelines
• Familiarity with data quality and governance tools such as Great Expectations, Monte Carlo,Datafold, 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 experiencerequiredand is strongly preferred.
• Prior experienceon data warehousing with GuidewirePolicyCenter,ClaimCenterorBillingCenterand Agency Licensing datais preferred
• Bachelor's degree in Computer Science, Information Systems, Engineering, or equivalent relevant experience/certifications.

The range for this position is $99,000 to $164,800. When determining candidate 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.), * Qualify for your choice of health and dental plans within your first month.

• Save for your future with robust 401(k) match, Health Spending Accounts and various retirement plans.
• Learn and Grow with our Tuition Assistance Program, paid certifications and continuing education programs.
• Contribute to your community through United Way and volunteer programs.
• Balance your life with generous paid time off and business casual dress.
• Get employee discounts for shopping, dining and travel through Kemper Perks.

Kemper is one of the nation's 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 professional challenge , and a healthy work-life balance can be highly motivating and productive. Kemper's 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 provide an experience to our stakeholders that delivers on our promises., The Kemper family of companies is one of the nation's leading specialized insurers. With approximately $12 billion in assets, Kemper is improving the world of insurance by providing affordable and easy-to-use personalized solutions to individuals, families and businesses through its Kemper Auto and Kemper Life brands. Kemper serves over 4.5 million policies, is represented by approximately 24,000 agents and brokers, and has approximately 7,300 associates dedicated to meeting the ever-changing needs of its customers. *Alliance United Insurance Company is not rated. We value diversity and strive to be an employer of choice. An Equal Opportunity Employer, M/F/D/V