1 day ago
Chicago, IL, USA +6 moreSenior
Base Salary
$91k - $190k/yr
Responsibilities
- Design scalable data models and data delivery solutions for complex operational reporting projects.
- Develop, test, optimize, deploy, and maintain automated data pipelines, datasets, metrics, reports, and dashboards.
- Use dbt, Azure Data Factory, or related ETL/ELT technologies to support data delivery processes.
- Write, debug, optimize, and maintain advanced SQL queries and data pipelines.
- Support migration of SAS solutions to dbt and Power BI.
- Perform daily maintenance, database migrations, testing, validation, root-cause analysis, and performance tuning.
- Collaborate with architecture, leadership, business partners, and cross-functional teams.
- Contribute to documentation, modularization, testing, code reviews, development standards, and best practices.
- 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.
- Experience with P&C claims data, analytics, or the P&C insurance industry.
- Proficiency developing data pipelines with dbt, GitHub, Airflow, or similar technologies.
- Strong foundation in data warehouses, data marts, data lakes, lakehouses, and related data delivery patterns.
- Advanced SQL skills and experience with data modeling, pipeline development, testing, validation, and optimization.
- Ability to work independently and collaboratively, multitask, learn substantial technical and procedural information, and communicate effectively.
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.
- Personalized development programs, mentorship, and certification assistance.
- Hybrid work arrangement requiring on-site work three days per week at a listed GEICO office location.
- Benefits begin on the date of hire, subject to location and 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.