Senior Analytics Data Engineer

Government Employees Insurance Company; Maryland; Hybrid; USD 74,000 - 141,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 an experienced data engineer to develop and maintain data delivery solutions that support operational reporting.

You will design scalable data models, implement ETL/ELT processes and move SAS workloads to modern platforms like dbt and Power BI, collaborating with cross-functional teams to ensure reliable data assets.

Qualifications

• Proficient developing data pipelines utilizing dbt, GitHub and Airflow.
• Able to work independently and in a team environment.
• Capable of multi-tasking and managing multiple priorities.
• Able to learn and apply large amounts of technical and procedural information.
• Strong written and verbal communication skills.
• 5+ years of Property & Casualty (P&C) data/analytics experience.

Responsibilities

• Develop and maintain data delivery solutions for operational reporting.
• Design scalable data models and data delivery pipelines.
• Implement ETL/ELT processes and migrate SAS solutions to modern tools such as dbt and Power BI.
• Collaborate with cross-functional teams to deliver reliable data assets.
• Perform testing, validation, deployment, and post-implementation support.
• Provide technical guidance and mentorship to junior engineers.

Skills

Communication skills

Team collaboration

Independent work

Multitasking

Problem solving

Tools

dbt

GitHub

Airflow

Job description

Why Join GEICO?

At GEICO, we offer a rewarding career where your ambitions are met with endless possibilities. Every day we honor our iconic brand by offering quality coverage to millions of customers and being there when they need us most. We thrive on relentless innovation to exceed our customers' expectations while making a real impact on local communities nationwide. Founded in 1936, GEICO is a member of the Berkshire Hathaway family of companies and one of the largest auto insurers in the United States. When you join our company, we want you to feel valued, supported, and proud to work here. That's why we offer the GEICO Pledge: Great Company, Great Culture, Great Rewards, and Great Careers.

Overview

This role is responsible for developing and maintaining data delivery solutions that support operational data reporting, including datasets, extracts, reports, and dashboards. This role will contribute to the design, testing, optimization, and support of critical data pipelines across multiple technical environments within various business functions in support of GEICO’s operational data reporting. As a member of an agile team, the incumbent assists with testing, validation, user acceptance testing, deployment, and post-implementation support. This includes writing code that builds datasets, metrics, and data needed for our business partners, while collaborating with peers and stakeholders to deliver reliable, scalable solutions.

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.

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.
• Must have the following experience: 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: This position is a hybrid role. It is required to be on-site 3 days per week at one of the following office locations: Bethesda MD, Lakeland FL, Tampa Fl, Chicago IL, Buffalo NY, Melville NY, New York (Manhattan) NY, Virginia Beach VA.

Annual Salary

The above annual salary range is a general guideline. Multiple factors are taken into consideration to arrive at the final hourly rate/ annual salary to be offered to the selected candidate. Factors include, but are not limited to, the scope and responsibilities of the role, the selected candidate’s work experience, education and training, the work location as well as market and business considerations. At this time, GEICO will not sponsor a new applicant for employment authorization for this position.

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

*Benefits may be different by location. Benefit eligibility requirements vary and may include length of service.

**Coverage begins on the date of hire. Must enroll in New Hire Benefits within 30 days of the date of hire for coverage to take effect.

The equal employment opportunity policy of the GEICO Companies provides for a fair and equal employment opportunity for all associates and job applicants regardless of race, color, religious creed, national origin, ancestry, age, gender, pregnancy, sexual orientation, gender identity, marital status, familial status, disability or genetic information, in compliance with applicable federal, state and local law. GEICO hires and promotes individuals solely based on their qualifications for the job to be filled. GEICO reasonably accommodates qualified individuals with disabilities to enable them to receive equal employment opportunity and/or perform the essential functions of the job, unless the accommodation would impose an undue hardship to the Company. This applies to all applicants and associates. GEICO also provides a work environment in which each associate is able to be productive and work to the best of their ability. We do not condone or tolerate an atmosphere of intimidation or harassment. We expect and require the cooperation of all associates in maintaining an atmosphere free from discrimination and harassment with mutual respect by and for all associates and applicants.

Annual Salary

$73,800.00 - $141,450.00 The above annual salary range is a general guideline. Multiple factors are taken into consideration to arrive at the final hourly rate/ annual salary to be offered to the selected candidate. Factors include, but are not limited to, the scope and responsibilities of the role, the selected candidate’s work experience, education and training, the work location as well as market and business considerations. At this time, GEICO will not sponsor a new applicant for employment authorization for this position.

The GEICO Pledge: Great Company: Protecting customers through life’s twists and turns with innovation and integrity. Great Careers: Personalized development programs, mentorship, and certification assistance. Great Culture: Inclusive and collaborative culture rooted in shared success. Great Rewards: Competitive pay, benefits, and flexibility to support your well-being and future.

The equal employment opportunity policy of the GEICO Companies provides for a fair and equal employment opportunity for all associates and job applicants regardless of race, color, religious creed, national origin, ancestry, age, gender, pregnancy, sexual orientation, gender identity, marital status, familial status, disability or genetic information, in compliance with applicable federal, state and local law. GEICO hires and promotes individuals solely on the basis of their qualifications for the job to be filled. GEICO reasonably accommodates qualified individuals with disabilities to enable them to receive equal employment opportunity and/or perform the essential functions of the job, unless the accommodation would impose an undue hardship to the Company. This applies to all applicants and associates. GEICO also provides a work environment in which each associate is able to be productive and work to the best of their ability. We do not condone or tolerate an atmosphere of intimidation or harassment. We expect and require the cooperation of all associates in maintaining an atmosphere free from discrimination and harassment with mutual respect by and for all associates and applicants.

At GEICO, we offer a rewarding career where your ambitions are met with endless possibilities. Every day we honor our iconic brand by offering quality coverage to millions of customers and being there when they need us most. We thrive on relentless innovation to exceed our customers' expectations while making a real impact on local communities nationwide. Founded in 1936, GEICO is a member of the Berkshire Hathaway family of companies and one of the largest auto insurers in the United States.

Opportunities for Students & Grads

Learn more about GEICO Benefits