Claims Data Analytics Engineer

GEICO is a leading American auto insurance company known for its commitment to quality and innovation. They are seeking a Claims Data Analytics Engineer to join their Claims Innovation team, where the role involves diagnosing complex business challenges and collaborating to drive innovation through advanced data analytics and engineering. The position focuses on building scalable data solutions to support strategic decision-making and improve operational efficiency.

Responsibilities:

• Build, maintain, and optimize Python-based data processing workflows, including ETL/ELT pipelines, automation scripts, and analytical models
• Engineer and optimize data models, views, and warehouse structures in Snowflake to support analytical performance and data governance
• Write advanced, efficient SQL to transform Claims data and implement reusable data patterns
• Design and develop Power BI dashboards, metrics layers, and semantic models to support reporting and business insights
• Apply deep data structure knowledge and strong analytical thinking to translate complex Claims data and customer-driven requirements into clear, actionable analytics and production-ready solutions
• Ensure data integrity, security, and compliance with organizational standards
• Manage workload in a Sprint environment with competing priorities
• Work with Operations customers to structure and translate requirements into data needs with clear pathways and milestones to deliver high-impact products
• Lead cross-functional collaboration across Operations and other engineering groups throughout the engineering lifecycle—from requirements through deployment
• Mentor junior engineers and analysts, sharing best practices for coding, analytical methodology, and solution design
• Consistently contribute to improving engineering processes, documentation, automation, and team standards

Requirements:

• Bachelor's degree in Computer Science, Engineering, Data Science, Mathematics, or related field—or +5 equivalent experience
• Expert-level SQL (query optimization, windowing functions, large dataset operations, query performance tuning)
• Hands-on experience with Snowflake (warehouse configuration, data modeling, SQL, tasks/streams, performance tuning)
• Proficiency in Python for ETL/automation, data transformation, and analytics workflows
• Experience with Power BI, including semantic modeling, DAX, and data visualization
• Strong analytical problem‑solving skills and business curiosity
• Experience with GitHub or similar version control systems
• Working knowledge of ATLAS and other enterprise claims data repositories
• CCC
• Mitchell
• CIQ
• Injury Guide
• AWS
• Experience in P&C/Auto insurance, particularly Operations/Claims
• Background in building scalable distributed systems or data pipelines
• Knowledge of enterprise data governance and metadata management frameworks
• Exposure of machine learning or predictive modeling techniques
• Strong communication skills with the ability to translate technical information for non-technical audiences