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 an SQL Server Software Developer to join our team. In this role you will primarily work on supporting claims and pricing applications as well as developing other database and data architectural needs.
The 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.
Responsibilities
- Developing database solutions with T-SQL to meet business needs.
- Creating new stored procedures, modify objects, performance tuning.
- 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.
- Working closely with Application Developers, Network Administrators, and other Technical Support team members.
- 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.
- Meet with the business and follow-up during the testing process to listen to performance concerns before deployment.
- Support application of business intelligence and marketing automation solutions.
Qualifications
- 6+ years of experience with SQL Server
- Strong knowledge of SSIS, ETL concepts and TSQL
- Experience in other MS .net programming languages.
- Python and C# is beneficial.
- Requires familiarity with Microsoft SSRS reporting services.
- Mastery of Microsoft SQL Server 2014, 2016, 2017 and 2019 supporting both OLTP and OLAP database types.
- Expertise with performance tuning databases and web applications along with tuning of indexes on large tables.
- Experience with visualization tools like QlikView, Tableau and PowerBI a plus.
- 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 regard to balancing & prioritizing multiple projects & requests, meeting deadlines, and producing accurate results.
- This is a hybrid position working 2 days in the office per week.
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-Hybrid