Location(s)
Birmingham, Alabama, Jacksonville, Florida, P&C-Butterfield Road-Downers Grove-IL-AAC, P&C-S Buckner Blvd-Dallas-TX, Remote-CT, Remote-FL, Remote-OH, Remote-PA, Remote-TX
**Details**
_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._
Kemper is seeking to add a data engineer to staff the Kemper Auto Data Engineering development team. The role will enhance and maintain analytical environments supporting financial, management and statutory reporting requirements along with enhancing and facilitating Kemper Auto decision making capabilities. Preferred experience with auto insurance and cloud based ETL platforms.
**Position Responsibilities:**
+ Developing solutions using Database technologies - Snowflake, Python, ETL Pipelines, Informatica, and cloud deployment and services.
+ Independently design and develop solutions to support reporting, analytic and warehouse needs using the appropriate platform, tools and programming languages on assorted system requests.
+ Using independent judgment, analyze business requirements and work with client areas to produce specifications used in creation of the reporting and analytical solutions.
+ Maintain existing warehouse, reporting and analytic solutions by providing production support for troubleshooting and regular processing needs.
+ Ensure newly designed systems run as needed, perform validity check on production output.
+ Turn functional and data mappings into reporting, analytic and warehousing solutions.
+ Conduct performance tuning on new and existing systems to insure optimal efficiency.
**Position Qualifications:**
+ 5+ years of experience developing data warehouse solutions preferably within the insurance industry.
+ Hands-on experience with industry standard ETL technologies (IICS, Pentaho, Informatica, Python, AWS Glue)
+ Advanced SQL skills and proficiency with Stored Procedures
+ Experience supporting large scale Enterprise Data Warehouses
+ Prior experience with architecting complex ETL processes.
+ Auto insurance background a plus.
+ Experience with cloud-based database technologies (i.e.: Snowflake, AWS)
+ Requires a bachelor's degree or equivalent certifications in technical system design or equivalent experience.
+ Sound understanding of data warehouse best practices, relational data structures and dimensional data modeling.
+ Strong knowledge of current relational database and big data software and query concepts
+ Ability to analyze and solve complex problems and to work independently on multiple tasks
+ Must be able to communicate effectively verbally and in writing with technical and non-technical associates
+ This position is eligible for remote work in the US.
The range for this position is $86,200 to $143,600. 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.)
_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.
\#LI-AK-1
\#LI-Remote
**Kemper at a Glance**
The Kemper family of companies is one of the nation's leading specialized insurers. With approximately $13 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.8 million policies, is represented by approximately 22,200 agents and brokers, and has approximately 7,500 associates dedicated to meeting the ever-changing needs of its customers. Learn more at Kemper.com .
*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_
**Our employees enjoy great 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 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.