Senior Data Engineer - People & Finance Technology (REMOTE)

GEICO is seeking an experienced Senior Data Engineer with a passion for transforming existing technology to new Open Source technologies. 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, while co-creating the culture of psychological safety and continuous improvement.

Our Senior Data Engineer is a key member of the engineering staff working across the organization to provide a friction-less experience to our customers and maintain the exit 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 is an experienced Data Engineer with background in ETL or ELT processing with SQL/NoSQL databases, a background in transforming existing tech to new open source technologies (ideally Postgres) as well as a strong development background in Spark, Scala, Java and/or Python.

Position Responsibilities

As a Senior Data Engineer, you will:

• Design and implement a data ingestion platform

• Scope, design, and build scalable, resilient distributed systems

• Build product definition and leverage your technical skills to drive towards the right solution

• Engage in cross-functional collaboration throughout the entire software lifecycle

• Lead in design sessions and code reviews with peers to elevate the quality of engineering across the organization

• Define, create, and support reusable application components/patterns from a business and technology perspective

• Build the processes required for optimal extraction, transformation, and loading of data

• Work with other teams to design, develop, test, implement, and support technical solutions in full-stack development tools and technologies

• Perform unit tests and conduct reviews with other team members to make sure code is rigorously designed, elegantly coded, and effectively tuned for performance

• Share your passion for staying on top of tech trends, experimenting with, and learning recent technologies, participating in internal and external technology communities, and mentoring other members of the engineering community

• Mentor other engineers

• Consistently share best practices and improve processes within and across teams

Qualifications

• Experience developing new and enhancing existing data processing (Data Ingest, Data Transformation, Data Store, Data Management, Data Quality) components

• Advanced programming experience and big data experience

• Understanding of data warehouse concepts including data modeling and OLAP

• Experience working with cloud data solutions (Delta Lake, Iceberg, Hudi, Snowflake, Redshift or equivalent)

• Experience with data formats such as Parquet, Avro, ORC, XML, JSON

• Experience with designing, developing, implementing, and maintaining solutions for data ingestion and transformation projects

• Experience working streaming applications (Spark Streaming, Flink, Kafka or equivalent)

• Data processing/data transformation using ETL/ELT tools such as DBT (Data Build Tool), or Databricks

• Experience programming languages like Python, Scala, Spark, Java

• Experience with container orchestration services including Docker and Kubernetes

• Strong working knowledge of SQL and the ability to write, debug and optimize SQL queries and ETL jobs to reduce the execution window or reduce resource utilization

• Experience with cloud computing (AWS, Microsoft Azure, Google Cloud)

• Exposure to messaging such as Kafka, ActiveMQ, RabbitMQ or similar messaging technologies.

• Experience with REST, Microservices is a big plus

• Experience with developing systems that are scalable, resilient, and highly available

• Experience with Infrastructure as Code

• Experience with CI/CD deployment and test automation. ADO, Jenkins, Gradle, Artifactory or equivalents

• Experience with containerization (examples include Docker and Kubernetes)

• Experience with version control systems such as GIT

• Experience with load testing and load testing tools

• Advanced understanding of monitoring concepts and tooling

• Experience with Elastic Search, Dynatrace, Thousand Eyes, Influx, Prometheus, Grafana or equivalents

• Experience architecting and designing new and current systems

• Advanced understanding of DevOps c