Staff Engineer - Data Engineering & Analytics

GEICO; United States; Remote; USD 90,000 - 150,000; Full time

Job summary

An innovative company is seeking a Staff Engineer to lead the design and development of cutting-edge data pipelines and applications. This role involves transforming vast datasets into actionable insights while promoting engineering excellence and best practices. The ideal candidate will have extensive experience in data processing, dimensional modeling, and cloud services, thriving in a dynamic environment. Join a forward-thinking team dedicated to delivering high-quality technology products and services, where your contributions will significantly impact the organization's transformation journey.

Qualifications

• 8+ years in data/analytics/database engineering and big data technologies.
• Experience with Data Warehousing, OLAP, and analytics.

Responsibilities

• Scope, design, and build scalable, resilient distributed systems.
• Utilize programming languages and tools for data processing and reporting.

Skills

Python

SQL

NoSQL

DBT

Apache Spark

Data Warehousing

Dimensional Modeling

Problem-Solving

DevOps Concepts

Education

Bachelor’s degree in Computer Science

Tools

Docker

Kubernetes

Power BI

Apache Superset

SQL Server Integration Services (SSIS)

Azure DevOps

Apache Iceberg

Job description

Position Summary

GEICO is seeking an experienced Engineer with a passion for building high-performance, low-maintenance, zero-downtime platforms and applications. You will help drive our insurance business transformation as we transition from a traditional IT model to a tech organization with engineering excellence as its mission. Within the Data Analytics and Vertical Engineering team, you will lead the design and development of state-of-the-art data pipelines, models, and reports, transforming vast datasets that reach up to multiple terabytes in size, while championing innovation, best practices, and fostering a culture of psychological safety and continuous improvement.

Position Description

Our Staff Engineer is a key member of the engineering team working across the organization to provide a frictionless experience to our customers and maintain the highest standards of protection and availability. Our team thrives and succeeds in delivering high-quality technology products and services in a hyper-growth environment where priorities shift quickly. The ideal candidate has broad and deep technical knowledge, typically ranging from data processing and pipeline development to dimensional data modeling and reporting.

Position Responsibilities

As a Staff Engineer, you will:

1. Scope, design, and build scalable, resilient distributed systems
2. Utilize programming languages like Python, SQL, NoSQL, DBT along with Apache Spark for data processing, container orchestration services such as Docker and Kubernetes, and various Azure tools and services
3. Use SQL Server Integration Services and reporting tools like Power BI and Apache Superset to transform and report on large volumes of enterprise data to gain insights
4. Produce high-quality, accurate data and reports with visualizations to empower business decisions
5. Be responsible for technical aspects of projects at the team level
6. Lead design sessions and code reviews to elevate engineering quality
7. Spearhead the adoption of new features and tools
8. Leverage automation to improve solution quality
9. Build with engineering excellence and drive towards optimal solutions
10. Engage in cross-functional collaboration throughout the software lifecycle
11. Define, create, and support reusable application components and patterns
12. Mentor other engineers
13. Share best practices and improve processes within and across teams

Qualifications

• Advanced programming experience and big data expertise in Python, SQL, DBT, Spark, Kafka, Git, Docker, Kubernetes
• Experience with Data Warehousing, OLAP, dimensional modeling, and analytics
• Knowledge of business intelligence tools (preferably Power BI) and ETL tools (preferably SSIS or DBT)
• Experience with Apache Iceberg is a plus
• Understanding of SQL concepts across different platforms
• Experience designing and supporting ETL and BI systems
• Scripting experience in Python preferred
• Familiarity with enterprise orchestration tools like Airflow preferred
• Ability to manage multiple priorities in a dynamic environment
• Strong understanding of DevOps concepts and Azure DevOps tools
• Knowledge of software development lifecycle tools and monitoring concepts
• Strong problem-solving skills
• Experience with relevant data domains (e.g., Marketing, Sales, Claims) is a plus
• Front-end development skills using REACT/JavaScript are a plus

Experience

• 8+ years in data/analytics/database engineering and big data technologies
• 5+ years in data architecture, data warehousing, and cloud services (AWS, GCP, Azure)
• 4+ years in SQL-based software development and open-source frameworks
• 4+ years with ETL and BI tools
• 3+ years with Spark and Databricks
• 2+ years with Microsoft Fabric/Azure Data Factory (preferred)

Education

• Bachelor’s degree in Computer Science, Information Systems, Data Science, Data Analytics, or equivalent experience