Senior Analytics Data Engineer

GEICO•Tampa, FL

1d•$91,225 - $189,625•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 helps with testing, validation, user acceptance testing, deployment, and post-implementation support, and writes code to build datasets, metrics, and other data for business partners. The role collaborates with peers and stakeholders to deliver reliable, scalable solutions. This is a hybrid position requiring on-site work three days per week at one of the listed GEICO offices: Bethesda, Maryland; Lakeland or Tampa, Florida; Chicago, Illinois; Buffalo, Melville, or Manhattan, New York; or Virginia Beach, Virginia. The listed annual salary range is $91,225 to $189,625. The posting includes conflicting statements about employment authorization sponsorship: one says GEICO will not sponsor a new applicant, while another says it will consider sponsoring a qualified applicant.

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 and learn and apply large amounts of 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 and maintain data delivery solutions for operational reporting, including datasets, extracts, reports, and dashboards.
Design efficient, scalable data models and delivery solutions for complex projects, with guidance from architecture and leadership teams as needed.
Recommend data delivery technologies and approaches that improve maintainability, performance, and usability.
Develop and operate automated data delivery processes for reporting and dashboards using ETL/ELT tools such as dbt and Azure Data Factory, or related technologies.
Write, debug, optimize, and maintain SQL 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 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.
Participate in testing, validation, user acceptance testing, deployment, and post-implementation support.