Senior Data Engineer

Kemper

Senior Data Engineer designing and optimizing data solutions at Kemper. Involved in data integration, transformation, and providing analytics insights across business applications.

Posted 6/3/2026full-timeAtlanta • Alabama, Florida, Illinois, Massachusetts, Ohio • 🇺🇸 United StatesSenior💰 $99,000 - $164,800 per yearWebsite

Tech Stack

Tools & technologies

AWSCloudETLInformaticaOracleSQL

About the role

Key responsibilities & impact

Design and Develop Data Solutions
Build, maintain, and optimize data pipelines and workflows that support reporting, analytics, and business applications using SQL, Informatica, IICS, and Snowflake.
Data Processing and Preparation
Develop and manage data preparation routines for extracts, transformations, and reporting datasets, ensuring reliability and performance.
Data Modeling and Optimization
Create and maintain logical and physical data models following normalization principles and best practices.
Tune queries for optimal performance across Snowflake and Oracle environments.
Integration and Automation
Work with various structured and semi-structured data formats (XML, JSON) and leverage AWS cloud frameworks for scalable data integration and processing.
Data Security and Quality
Ensure compliance with data security policies and implement best practices for data protection, integrity, and confidentiality.
Collaboration and Leadership
Partner with data analysts, developers, and business stakeholders to define data requirements, streamline processes, and improve data accessibility for reporting tools such as Power BI.
Continuous Improvement
Recommend and implement improvements to data architecture, workflows, and governance processes.
Serve as a mentor to junior team members and promote a culture of curiosity and continuous learning.

Requirements

What you’ll need

Bachelor’s degree in Computer Science, Information Systems, or a related field; equivalent work experience considered.
5+ years of experience in data engineering or database development.
Demonstrated expertise in:
SQL development and query tuning
Informatica and IICS for ETL and data integration
Snowflake data warehouse architecture and development
Oracle database systems
Power BI for data visualization and reporting enablement
Data modeling, normalization, and relational design
Handling and transforming XML and JSON data structures
Building data solutions in an AWS cloud environment
Strong problem-solving abilities and the capacity to work independently on complex technical challenges.
Deep understanding of data security, governance, and compliance best practices.
High degree of self-motivation, intellectual curiosity, and commitment to continuous improvement.

Benefits

Comp & perks

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.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLInformaticaIICSSnowflakeOracleData modelingNormalizationETLData integrationData visualization

Soft Skills

Problem-solvingIndependenceCuriosityContinuous improvementCollaborationLeadershipMentoringCommunicationStakeholder engagementProcess improvement