Senior Analytics Data Engineer - Hybrid, dbt & Pipelines

GEICO; Chicago (IL); Hybrid; USD 91,000 - 190,000; Full time

Benefits offered by this job

Premier Medical, Dental and Vision

Paid Vacation, Sick and Parental Leave

401(k) Plan

Tuition Reimbursement

Paid Training and Licensures

Job summary

GEICO is seeking a data engineer to develop and maintain data delivery solutions that support operational reporting and dashboards across multiple environments. You will build datasets and metrics, test and deploy pipelines, and collaborate with partners to deliver scalable, reliable data products.

The role involves migrating SAS solutions to modern GEICO tools, writing complex SQL, and partnering with teams to meet business needs.

Qualifications

• 5+ years of relevant work experience in data engineering/analytics.
• P&C claims data analytics experience or insurance industry experience preferred.
• Hybrid work arrangement: location-specific requirement.

Responsibilities

• Demonstrate strong data architecture knowledge (data warehouses, data lakes, data marts).
• Design scalable data models and delivery solutions for complex projects.
• Execute ETL/ELT processes and maintain data pipelines.
• Tune and optimize queries and pipelines for performance.
• Support migration of SAS solutions to GEICO technologies (dbt, Power BI).
• Collaborate with cross-functional teams to deliver reliable data products.

Skills

Communication skills

Problem-solving

Multi-tasking

Tools

dbt

GitHub

Airflow

Job description

GEICO is seeking a data engineer to develop and maintain data delivery solutions that support operational reporting and dashboards across multiple environments. You will build datasets and metrics, test and deploy pipelines, and collaborate with partners to deliver scalable, reliable data products.

The role involves migrating SAS solutions to modern GEICO tools, writing complex SQL, and partnering with teams to meet business needs.