2 months ago
Chicago, IL, USA +4 moreSenior
Base Salary
$74k - $141k/yr
Responsibilities
- Design and maintain data delivery solutions, datasets, extracts, reports, dashboards, and operational reporting pipelines.
- Develop efficient and scalable data models and data delivery solutions using modern data architecture patterns.
- Build, automate, test, debug, optimize, and maintain ETL/ELT processes and data pipelines.
- Use advanced SQL for query development, troubleshooting, optimization, and pipeline maintenance.
- Support migration of SAS solutions to dbt and Power BI.
- Collaborate with cross-functional teams to design and implement data models and architectures.
- Perform daily maintenance, database migrations, testing, validation, root cause analysis, and performance tuning.
- Contribute to documentation, modularization, testing, code review standards, and continuous process improvement.
- Assist with project estimates, status reporting, time management, and stakeholder coordination.
- Provide technical guidance and mentorship to junior engineers and other team members.
Requirements
- 5+ years of relevant work experience required.
- Proficiency developing data pipelines with dbt, GitHub, Airflow, or similar technologies.
- Experience with P&C claims data and analytics or experience in the P&C insurance industry.
- Strong foundation in data warehouses, data marts, data lakes, lakehouses, and related data delivery patterns.
- Advanced SQL skills and experience with ETL/ELT tools such as dbt or Azure Data Factory.
- Ability to work independently and collaboratively, multitask, learn technical and procedural information, and communicate effectively.
- Ability to work onsite three days per week at a listed GEICO office location.
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.
- Hybrid work arrangement requiring three days onsite weekly at a specified office location.
- Benefits begin on the date of hire, subject to enrollment and location-specific eligibility requirements.
Tech Stack
Categories
Data Engineering
About GEICO
GEICO sells auto and other personal lines insurance to U.S. consumers through a primarily direct-to-consumer model via web, mobile, and phone, with some local agents. Its products include car, motorcycle, RV, boat, homeowners, renters, condo, umbrella, and commercial auto coverage, plus roadside assistance. Founded in 1936 and headquartered in Bethesda, Maryland, GEICO is a subsidiary of Berkshire Hathaway and is among the largest auto insurers in the United States.