Engineer II – Data Engineer
Palo Alto, CA - USA
Job Summary
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. Thats 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 buildingfast reliable platforms and applicationsthat areeasy to operateand designed forcontinuous this role you will help advance our insurance business as we evolve into atechnology organization grounded in engineering excellence. This role supports ourFinance Data Warehouse.
Position Description:
As anEngineer II you will be an important part of our FinTech organization touphold strong standards fordata protection reliability and availability. Our team succeeds by shippinghigh-quality technology products and servicesin ahigh-growth settingwhere priorities can change quickly. We are looking for someone withbroad technical depth comfortable across the stack fromuser-facing experiencesthroughbackend and data systemsand 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 toolingeffectively 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 collaborationacross the full data lifecycle with analysts platform engineers and product partners from requirements through production support.
- Participate in design sessions and code reviewswith 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 createSQLand Python dbt(models tests macros incremental strategies) Apache Airflow(DAGs dependencies backfill/retry patterns) cloud data warehouseplatforms (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 Codewhere applicablescripting for automation platform consoles for warehouse and orchestration and observabilitytooling (logging metrics alertingfor example dashboards and APM where used).
- Build pipeline definitions and apply strong technical judgment to choose and implement solutionsthat balance latency cost freshness and reliability.
- Share best practicesand improve processes within and across teams.
Qualifications:
- Strong hands-on experience with SQL dbt and Pythonfor 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-centricanalytics stack.
- Experience contributing to the architecture and designof data systems (layering modeling patterns reliability scaling cost awareness).
- Working knowledge of structured data interchange(e.g. JSON XML/CSVas 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 Gittoolsand standard branching/review workflows.
- Familiarity with cloud data and orchestration services(e.g. Snowflake and managed Airflow or equivalent).
- Experience with continuous deliveryand Infrastructure as Codefor pipeline repos or supporting infrastructure.
- Strong oral and written communicationskills.
- Strong problem-solvingand debugging skills across SQL logs and orchestration failures.
- Practical experience working in an Agileenvironment.
- Ability to deliver in a fast-paced priority-driven setting.
- Knowledgeof developer toolingacross the SDLC (task management source control build/deploy operations collaboration tools) including AI-assisted IDEsused responsibly alongside dbtand Airflowworkflows.
Experience:
- 2years of non-internship professional experience in data engineering software engineeringwith a data focus or equivalent.
- 2years contributing to design and architectureof data pipelinesor analytics data products (models DAGs warehouse objects).
- 2years building and operating ETL/ELTor transformation-heavy systems using SQL-centric tooling (required: dbtor equivalent transform discipline; Airflowor comparable orchestration).
- 2years with AWS GCP Azure or comparable cloud platforms in a data or backend context.
Education:
- Bachelors degree in Computer Science Information Systems or equivalent education or work experience
Annual Salary
$75000.00 - $260000.00The 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 candidates work experience education and training the work location as well as market and business considerations.
The GEICO Pledge:
Great Company:At GEICO we help our customers through lifes twists and turns. Our mission is to protect people when they need it most and were constantly evolving to stay ahead of their needs.
Were an iconic brand that thrives on innovation exceeding our customers expectations and enabling our collective success. From day one youll take on exciting challenges that help you grow and collaborate with dynamic teams who want to make a positive impact on peoples 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. Youll 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 familys 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.
Required Experience:
IC
About Company
Get insurance from a company that's been trusted since 1936. See how much you can save with GEICO on insurance for your car, motorcycle, and more.