Data Analyst/Junior Etl Developer

Location(s)

Alpharetta GA, Birmingham AL, Chicago IL, Jacksonville FL

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 Data Analyst/Junior ETL Developer to the Enterprise Data Services team to assist in data analysis and ETL development. This is a great position to move your data career ahead, learn new ETL tools and cloud software!

Responsibilities

Work with the technical project team to ensure technical requirements are documented, communicated, and implemented. Work with technology and business partners to design, develop, and implement ETL solutions. In this position you will:

• Perform ETL design and development
• Document data mapping and research data related inquiries
• Communicate and discuss requirements and data with various project stakeholders.
• Work with databases and run queries using SQL
• Conduct data analysis and requirements documentation

Qualifications

• Knowledge or experience of the following preferred:
• Cloud/AWS/Snowflake/Data Vault
• Data Warehouses/ Data Lakes
• Experience with data mapping, modelling, lineage, governance and management a plus
• Effective, clear and concise verbal and written communication skills
• Experience with ETL tools, IICS/Informatica PowerCenter is a plus.
• IT Business/Technical Systems Analyst experience preferred
• Sponsorship is not offered for this position.
• This position will be located in Jacksonville, FL, Chicago, IL, Alpharetta, GA or Birmingham, AL (Hybrid schedule – one day in the office per week).
• Education equivalent to a college degree in information technology or technical related discipline, or the equivalent in related work experience
• Good organizational skills
• Working knowledge of SQL (TSQL/PL SQL)
• 2+ of technical data analyst experience
• ETL patterns and tools
• Business Intelligence

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. If you receive such a message, delete it

#LI-AK1

#LI-Hybrid