This role at GEICO focuses on developing and maintaining data delivery solutions that support operational data reporting. The incumbent will work within an agile team to design, test, and optimize data pipelines across various technical environments. The position requires collaboration with peers and stakeholders to deliver reliable and scalable solutions. The role also involves providing technical guidance and mentorship to junior engineers.

• Must have 5+ years of relevant work experience.
• Experience in Property & Casualty (P&C) claims data or analytics is required.
• Proficiency in developing data pipelines utilizing dbt, GitHub, and Airflow or similar technologies is necessary.
• Ability to work independently and in a team environment is essential.
• Strong communication skills, both verbal and written, are required.

• Demonstrate a strong foundation in modern data architecture concepts.
• Design efficient and scalable data models for complex projects.
• Recommend practical data delivery technologies to improve performance and usability.
• Execute all phases of development for automated data delivery processes using ETL/ELT tools.
• Apply advanced SQL skills to write, debug, optimize, and maintain queries and data pipelines.
• Support the migration of existing SAS solutions to widely used technologies at GEICO.
• Collaborate with cross-functional teams to implement data models and architectures.
• Perform and automate daily maintenance processes.
• Assist with data and database migrations, testing, and validation.
• Conduct root cause analysis and performance tuning for data pipelines.