Senior Analytics Data Engineer

GEICO • Bethesda, MD

8d • Hybrid

About The Position

GEICO is hiring a Senior Analytics Data Engineer to develop and maintain data delivery solutions for operational reporting, including datasets, extracts, reports, and dashboards. The role contributes to the design, testing, optimization, and support of critical data pipelines across technical environments and business functions. As part of an agile team, the engineer assists with testing, validation, user acceptance testing, deployment, and post-implementation support, and writes code to build datasets, metrics, and other data used by business partners.

This is a hybrid position requiring onsite work three days per week at a designated office in Bethesda, Maryland; Lakeland or Tampa, Florida; Chicago, Illinois; Buffalo, Melville, or Manhattan, New York; or Virginia Beach, Virginia. GEICO lists an annual salary range of $91,225 to $189,625. The final offer may depend on factors including experience, education, training, location, and business considerations.

Requirements

• At least 5 years of relevant work experience.
• Experience with Property & Casualty (P&C) claims data or analytics, or experience in the P&C insurance industry.
• Proficiency developing data pipelines using dbt, GitHub, and Airflow, or similar technologies.
• Ability to work independently and as part of a team.
• Ability to multitask.
• Ability to learn and apply substantial technical and procedural information.
• Effective verbal and written communication skills.
• Strong foundation in modern data architecture concepts, including data warehouses, data marts, data lakes, lakehouses, and related data delivery patterns.
• Advanced SQL skills.
• Strong quantitative, analytical, problem-solving, organizational, communication, and interpersonal skills.

Responsibilities

• Design efficient, scalable data models and delivery solutions for complex projects, with guidance from architecture and leadership teams as needed.
• Recommend practical data delivery technologies and approaches that improve maintainability, performance, and usability.
• Execute development phases for automated data delivery processes supporting reporting and dashboards using ETL/ELT tools such as dbt, Azure Data Factory, or related technologies.
• Use advanced SQL to write, debug, optimize, and maintain queries and data pipelines.
• Support migration of existing SAS solutions to technologies used at GEICO, such as dbt and Power BI.
• Collaborate with cross-functional teams to design, develop, and implement data models and architectures for client projects and initiatives.
• Perform and automate daily maintenance processes.
• Assist with data and database migrations, testing, and validation.
• Contribute to team development standards and best practices, including documentation, modularization, testing, and code reviews.
• Promote continuous refinement of team capabilities and processes.
• Assist with project and time management, including estimates, status reporting, and stakeholder coordination.
• Conduct root cause analysis and performance tuning for data pipelines, queries, and reporting datasets.
• Provide technical guidance and mentorship to junior engineers and other team members as needed.
• Support testing, validation, user acceptance testing, deployment, and post-implementation activities.

Benefits

• Premier medical, dental, and vision insurance with no waiting period.
• Paid vacation, sick, and parental leave.
• 401(k) plan.
• Tuition reimbursement.
• Paid training and licensures.
• Personalized development programs, mentorship, and certification assistance.
• Competitive pay, benefits, and flexibility to support well-being and future needs.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed