onsite
Senior Data Systems Analyst - Kemper
Software Engineer
Lead the design, development, and maintenance of enterprise data systems, leveraging SQL, ETL pipelines, and Python to deliver high‑quality data solutions on AWS. Drive data quality, performance, and scalability for complex insurance analytics.
About the role
Key Responsibilities
- Architect and develop robust ETL processes to ingest, transform, and load large volumes of insurance data into data warehouses.
- Design and maintain scalable data models and schemas that support advanced analytics and reporting.
- Collaborate with data scientists, business analysts, and stakeholders to translate business requirements into technical specifications.
- Optimize SQL queries and data pipelines for performance and reliability on AWS infrastructure.
- Implement data quality checks, monitoring, and documentation to ensure data integrity.
- Mentor junior analysts and provide technical guidance on best practices.
Requirements
- 5+ years of experience in data engineering or data systems analysis.
- Proficient in SQL, Python, and ETL tools (e.g., Informatica, Talend, or AWS Glue).
- Strong knowledge of relational database design and data warehousing concepts.
- Experience with AWS services such as Redshift, S3, and Lambda.
- Excellent problem‑solving skills and ability to work independently in a fast‑paced environment.