Senior Data Engineer

Locations Atlanta, Georgia, Birmingham, Alabama, Boston, Massachusetts, Chicago, Illinois, Cincinnati, Ohio, Columbus, Ohio, Jacksonville, Florida, P&C-Butterfield Road-Downers Grove-IL-AAC Position Summary Kemper is seeking a Data Engineer 4 to design, develop, and optimize enterprise data solutions that enable robust analytics, reporting, and business insights. This role provides technical leadership across data integration, transformation, and delivery processes. The ideal candidate is a self‑motivated problem solver with strong intellectual curiosity, excellent data management skills, and a deep understanding of data security and governance principles. Position Responsibilities 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. Position Qualifications – Required 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. 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. Position Qualifications – Preferred Experience with PowerShell or Python for automation and data scripting. Familiarity with IDMC (Informatica Intelligent Data Management Cloud). Experience with Azure data storage, compute, and integration services. Knowledge of Git for version control and collaboration. Exposure to end‑to‑end data flow, ingestion, and orchestration processes across hybrid or multi‑cloud environments. Sponsorship is not accepted for this opportunity. This position can be worked hybrid out of a local Kemper office, including Chicago or Downers Grove, IL. Remote working arrangements may be available to non‑local candidates. Benefits 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 a 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 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, disability status, or any other status protected by the laws or regulations in the locations where we operate. We are committed to supporting diversity and equality across our organization and 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 of Kemper and Kemper will not be obligated to pay a placement fee. Kemper will never request personal information, such as your social security number or banking information, via text or email. Additionally, Kemper does not use external messaging applications like WireApp or Skype to communicate with candidates. If you receive such a message, delete it. #J-18808-Ljbffr