Job Description

Location(s)

P&C-Butterfield Road-Downers Grove-IL-AAC

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 a Senior SQL Server Software Developer to join our team. In this role you will work on supporting claims and pricing applications. The senior SQL Developer is responsible for creating, managing, and coding database solutions as well as defining functionality, creating concepts, and brainstorming the technology that is best suited to the project at hand. The senior developer will lead database projects and provides mentoring to less experienced team members on the project.

Position Responsibilities

• Developing database solutions with T-SQL to meet business needs
• Providing hands-on development, unit testing, system testing and support for SQL processes, including bug fixes.
• Support in designing, developing and tuning current SQL Server databases.
• Designing, developing, automating and supporting ETL processes for data staging, extraction, transformation, and data cleansing, and loading of fact tables.
• Excellent communicator with the business owners.
• Strong interpersonal skills.
• Working closely with Application Developers, Network Administrators and other Technical Support team members.
• Must work well with other developers in a team setting to create database solutions in a timely manner, but also on their own with minimal supervision.
• Must be able to interpret the business need and deliver a clear vision of the result and effort needed to complete that need.
• Coach junior developers in coding and specifying which codes run more efficiently in different circumstances.
• Must be able to solve complex issues independently by not only following the business direction but also providing solutions outside of the box.
• Must be able to lead the business to better solutions.
• Must be able to help coach junior developers in coding and specifying which codes run more efficiently in different circumstances.
• Must be proficient with database storage needs and know how to scale different database scenarios as necessary.
• Must be able to meet with the business and follow-up during the testing process to listen to performance concerns before deployment.
• Invest additional time and effort into the success of a project, the team and the company.
• Approachable and always willing to help.
• Knows when to ask for help or escalate to management.

Position Qualifications

• 6 plus years of experience with SQL Server
• Experience in other MS .net programming languages.
• Python and C# is beneficial.
• Requires familiarity with Microsoft SSRS reporting services.
• Mastery of Microsoft SQL Server 2017 and 2019, SSIS, ETL concepts and TSQL supporting both OLTP and OLAP database types.
• Expertise with performance tuning databases and web applications along with tuning of indexes on large tables.
• Skilled in trouble shooting.
• Strong interpersonal skills.
• Excellent communicator with the business owners.
• Proficiency with database storage needs and how to scale different database scenarios as necessary.
• Well-developed analytical skills and the ability to analyze situations, challenge assumptions, develop analytical methodologies, present/defend conclusions and recommend action plans.
• Intellectual curiosity and a willingness to dive into a problem and uncover/understand the root cause.
• Time management skills in regards to balancing & prioritizing multiple projects & requests, meeting deadlines, and producing accurate results.
• Sponsorship is not offered for this position.
• The range for this position is $89,000 to $148,100.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.)
• This is a hybrid position will be located at Kemper's Downers Grove office.

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 is focused on expanding our Diversity, Equity and Inclusion efforts to align with our vision, mission, and guiding principles. 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-HYBRID

#L-JO1