Engineer II – Data Engineer at Geico in Palo Alto, CA

Engineer II – Data Engineer Location: Palo Alto, CA 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 through relentless innovation to exceed our customers’ expectations while making a real impact for our company through our shared purpose. 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. Qualifications Position Summary : GEICO is looking for an experienced engineer who enjoys building fast, reliable platforms and applications that are easy to operate and designed for continuous availability. In this role, you will help advance our insurance business as we evolve into a technology organization grounded in engineering excellence. This role supports our Finance Data Warehouse. Position Description : As an Engineer II, you will be an important part of our FinTech organization, to uphold strong standards for data protection, reliability, and availability. Our team succeeds by shipping high-quality technology products and services in a high-growth setting where priorities can change quickly. We are looking for someone with broad technical depth, comfortable across the stack from user-facing experiences through backend and data systems and the integrations that connect them. Position Responsibilities: As an Engineer II - Data Engineer, you will: Scope, design, and build scalable, resilient data pipelines (orchestration, transformation, delivery) that support analytics and downstream products. Use modern developer tooling effectively, including AI-assisted coding (e.g., Cursor, GitHub Copilot) to accelerate delivery while maintaining code review, testing, and governance (no secrets in prompts or code, repo-aligned patterns). Engage in cross-functional collaboration across the full data lifecycle with analysts, platform engineers, and product partners from requirements through production support. Participate in design sessions and code reviews with peers to improve correctness, performance, security, and operability of data systems. Define, create, and support reusable pipeline patterns and standards (e.g., layering, testing, incremental design, naming, documentation) from both business and technology perspectives. Leverage AI models to create SQL and Python, dbt (models, tests, macros, incremental strategies), Apache Airflow (DAGs, dependencies, backfill/retry patterns), cloud data warehouse platforms (e.g., Snowflake), and related integration patterns; then leverage their expertise to review and improve code quality. Execute delivery using an Agile methodology, continuous integration/continuous delivery, Infrastructure as Code where applicable, scripting for automation, platform consoles for warehouse and orchestration, and observability tooling (logging, metrics, alerting—for example dashboards and APM where used). Build pipeline definitions and apply strong technical judgment to choose and implement solutions that balance latency, cost, freshness, and reliability. Share best practices and improve processes within and across teams. Qualifications: Strong hands-on experience with SQL, dbt and Python for data transformation and pipeline automation. Proven understanding of data pipeline architecture (batch workflows, idempotency, data quality, error handling, backfills) and how pipelines interface with a warehouse-centric analytics stack. Experience contributing to the architecture and design of data systems (layering, modeling patterns, reliability, scaling, cost awareness). Working knowledge of structured data interchange (e.g., JSON, XML/CSV as sources), APIs, and file-based ingestion patterns as used in analytics pipelines. Solid grounding in computer science fundamentals (e.g., complexity, joins, partitioning concepts) applied to data processing. Experience with Git tools and standard branching/review workflows. Familiarity with cloud data and orchestration services (e.g., Snowflake and managed Airflow or equivalent). Experience with continuous delivery and Infrastructure as Code for pipeline repos or supporting infrastructure. Strong oral and written communication skills. Strong problem-solving and debugging skills across SQL, logs, and orchestration failures. Practical experience working in an Agile environment. Ability to deliver in a fast-paced, priority-driven setting. Knowledge of developer tooling across the SDLC (task management, source control, build/deploy, operations, collaboration tools) including AI-assisted IDEs used responsibly alongside dbt and Airflow workflows. Experience: 2+ years of non-internship professional experience in data engineering, software engineering with a data focus, or equivalent. 2+ years contributing to design and architecture of data pipelines or analytics data products (models, DAGs, warehouse objects). 2+ years building and operating ETL/ELT or transformation-heavy systems using SQL-centric tooling (required: dbt or equivalent transform discipline; Airflow or comparable orchestration). 2+ years with AWS, GCP, Azure, or comparable cloud platforms in a data or backend context. Education: Bachelor’s degree in Computer Science, Information Systems, or equivalent education or work experience Annual Salary $75,000.00 - $260,000.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. GEICO will consider sponsoring a new qualified applicant for employment authorization for this position. The GEICO Pledge: Great Company: At GEICO, we help our customers through life’s twists and turns. Our mission is to protect people when they need it most and we’re constantly evolving to stay ahead of their needs. We’re an iconic brand that thrives on innovation, exceeding our customers’ expectations and enabling our collective success. From day one, you’ll take on exciting challenges that help you grow and collaborate with dynamic teams who want to make a positive impact on people’s lives. Great Careers: We offer a career where you can learn, grow, and thrive through personalized development programs, created with your career – and your potential – in mind.  You’ll have access to industry leading training, certification assistance, career mentorship and coaching with supportive leaders at all levels. Great Culture: We foster an inclusive culture of shared success, rooted in integrity, a bias for action and a winning mindset. Grounded by our core values, we have an an established culture of caring, inclusion, and belonging, that values different perspectives. Our teams are led by dynamic, multi-faceted teams led by supportive leaders, driven by performance excellence and unified under a shared purpose. As part of our culture, we also offer employee engagement and recognition programs that reward the positive impact our work makes on the lives of our customers. Great Rewards: We offer compensation and benefits built to enhance your physical well-being, mental and emotional health and financial future. Comprehensive Total Rewards program that offers personalized coverage tailor-made for you and your family’s overall well-being. Financial benefits including market-competitive compensation; a 401K savings plan vested from day one that offers a 6% match; performance and recognition-based incentives; and tuition assistance. Access to additional benefits like mental healthcare as well as fertility and adoption assistance. Supports flexibility- We provide workplace flexibility as well as our GEICO Flex program, which offers the ability to work from anywhere in the US for up to four weeks per year. 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.