Data Analyst/Junior ETL Developer

Job description


Alpharetta GA, Birmingham AL, Chicago IL, Jacksonville FL


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!


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:

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


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

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

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.