Software Engineer III

About the Role

Key Responsibilities

• Maintain scalable data pipelines, troubleshoot and resolve related incidents and issues to support CSAA Insurance Group's data-driven processes
• Collaborate with cross-functional teams to support high-quality data solutions that enhance our insurance products and services
• Perform effective production support activities on the ODI platform (Oracle Data Integrator)
• Work in shifts, including weekend on-call rotation and month-end support
• Optimize data storage and retrieval processes to ensure efficient and secure data management, adhering to industry best practices and regulatory requirements
• Implement data governance and data quality measures to ensure the accuracy, consistency, and reliability of data across the organization
• Support and maintain data pipelines and processes to integrate data from various sources, including internal systems and external partners
• Support the deployment and monitoring of data infrastructure, ensuring high availability and performance of data systems
• Participate in the evaluation and adoption of new data technologies and tools to improve data engineering capabilities and efficiency
• Provide technical leadership and mentorship to junior data engineers, fostering a culture of innovation and continuous improvement
• Ensure compliance with data privacy and security standards, protecting sensitive member information and maintaining trust in CSAA Insurance Group's services

Requirements

• A bachelor's degree in computer science, Information Systems, or a similar technical field, or a comparable mix of education and practical experience
• 2-4 years professional experience
• Proven experience in data engineering or a related field
• Strong understanding of data modeling, ETL processes, and data warehousing
• Proficiency in SQL and Cloud Data Platforms like Snowflake or BigQuery
• Experience with big data technologies such as EMR, Glue, Spark, and/or Kafka
• Experience with cloud platforms like AWS, Azure, or Google Cloud (AWS Preferred)
• Knowledge of data governance and data quality principles
• Excellent problem-solving, troubleshooting, and analytical skills
• Effective communication and collaboration abilities
• Ability to manage multiple projects and meet deadlines
• Commitment to continuous learning and professional development

Nice to Have

• Advanced degree in related area
• Experience in one of CSAA IG's business lines
• Experience in writing complex SQL queries
• Willingness to travel as needed for role, including divisional and team meetings

Qualifications

• Must have authorization to work indefinitely in the US

Benefits & Perks

• Total compensation package
• Performance bonus
• 401(k) with a company match
• Opportunity to choose preferred working location: remote, hybrid, or in-person
• Support for inclusion and diversity
• Company-wide annual discretionary bonus of up to 8% of eligible pay