Senior Analytics Data Engineer (Hybrid) - dbt, Airflow

GEICO; Getzville (NY); Hybrid; USD 74,000 - 141,000; Full time

Benefits offered by this job

Medical Insurance

Dental & Vision

401(k) Plan

Tuition Reimbursement

Paid Training

Job summary

GEICO is hiring for a data delivery engineer who will develop and maintain data pipelines, datasets, extracts, and dashboards to support operational reporting across multiple environments. You’ll join an agile team, contribute to testing, deployment, and post-implementation support, and write code to build datasets and metrics for business partners.

You’ll design scalable data models, apply strong SQL, and help migrate SAS solutions to modern GEICO tools like dbt and Power BI, with on-site

Qualifications

• Must be proficient developing data pipelines utilizing dbt, GitHub and Airflow, or similar technologies
• Must be able to work both independently and in a team environment
• Must be able to multi-task
• Must be able to learn and apply large amounts of technical and procedural information
• Must be able to communicate effectively verbally and in writing
• Relevant work experience of 5+ years required
• Property & Casualty (P&C) claims data/analytics experience or any P&C insurance industry experience
• Hybrid work requirement: location specific

Responsibilities

• Demonstrate a strong foundation in modern data architecture concepts such as data warehouses, data marts, data lakes, lakehouses, and related data delivery patterns.
• Design efficient, scalable data models and data 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.
• Proficiently execute all phases of development for automated data delivery processes supporting reporting and dashboards using ETL/ELT tools such as dbt, Azure Data Factory, or related technologies.
• Apply advanced SQL skills to write, debug, optimize, and maintain queries and data pipelines.
• Use strong quantitative, analytical, problem-solving, organizational, communication, and interpersonal skills to deliver high-quality outcomes.
• Support the migration of existing SAS solutions to technologies used widely at GEICO, such as dbt and Power BI.
• Work closely with cross-functional teams to design, develop, and implement data models and architectures that support client projects and initiatives.
• Perform and automate daily maintenance processes.
• Assist with data and database migrations, testing, and validation.
• Contribute to team-level development standards and best practices, including documentation, modularization, testing, and code review expectations.
• Promote a culture of continuous refinement of capabilities and processes.
• Assist with project and time management, including estimates, status reporting, and coordination with stakeholders.
• 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.

Skills

dbt

GitHub

Airflow

SQL

Data modeling

Tools

Power BI

Azure Data Factory

SAS

Job description

GEICO is hiring for a data delivery engineer who will develop and maintain data pipelines, datasets, extracts, and dashboards to support operational reporting across multiple environments. You’ll join an agile team, contribute to testing, deployment, and post-implementation support, and write code to build datasets and metrics for business partners.

You’ll design scalable data models, apply strong SQL, and help migrate SAS solutions to modern GEICO tools like dbt and Power BI, with on-site