Senior Data Engineer (Data Warehouse, Service & Tools)

Quick Facts

• Role: Senior Data Engineer (Data Warehouse, Service & Tools)

• Focus: Building and improving reliable ETL/ELT pipelines for vehicle service, maintenance, repair, warranty, and collision analytics

Description

Build and maintain data pipelines that power analytics for vehicle service, maintenance, repair, warranty, and collision events. Use Apache Airflow for orchestration, Spark (PySpark/Scala) for transformations, Apache Iceberg for ACID-compliant data lake storage, and relational databases for SQL transformations. Monitor and troubleshoot pipelines, run data quality checks, and enable Tableau dashboard development with clean datasets.

Responsibilities

• Build and maintain ETL/ELT pipelines using Apache Airflow to orchestrate workflows

• Write Spark jobs for transformation, cleansing, and aggregation (PySpark or Scala)

• Work with Apache Iceberg tables for reliable ACID data lake storage and schema evolution

• Develop and optimize SQL queries and transformations in Vertica, SQL Server, and MySQL

• Implement incremental loading patterns and CDC (change data capture)

• Collaborate with data analysts, BI developers, and stakeholders to understand data requirements

• Monitor pipeline health, troubleshoot failures, and improve reliability & performance

• Perform data quality checks and maintain documentation of pipelines and data flows

• Ensure clean, well-structured data is available for Tableau dashboard developers

• Learn modern data engineering best practices and take on increasingly complex tasks

Requirements

• Degree in Computer Science, Engineering, Information Systems, Data Science, or related field OR equivalent experience

• Strong foundation in SQL (writing, debugging, and optimizing complex queries)

• Solid understanding of Python (used with Spark and Airflow)

• Basic knowledge of ETL/ELT concepts and data pipeline patterns

• Familiarity with at least one major relational database (MySQL, SQL Server, PostgreSQL, etc.)

• Eagerness to learn big data technologies and modern data lake formats

Benefits

• Medical plans with multiple options and $0 payroll deduction; HSA contribution with the High-Deductible plan

• Dental and vision plans with options and $0 paycheck contribution

• Family-building, fertility, adoption, and surrogacy benefits

• Healthcare and Dependent Care Flexible Spending Accounts (FSA)

• 401(k) with employer match; Employee Stock Purchase Plans

• Company-paid Basic Life and AD&D; short-term and long-term disability insurance

• Employee Assistance Program

• Sick and vacation time (flex time for salary roles), accrued hours for hourly roles, and paid holidays

• Backup childcare and parenting support resources

• Voluntary benefits (critical illness, hospital indemnity, accident insurance, theft & legal services, pet insurance)

• Weight loss and tobacco cessation programs

• Tesla Babies program and commuter benefits

• Employee discounts and perks program

Expected Compensation

$120,000–$216,000 annual salary + cash and stock awards + benefits. Pay may vary based on market location and job-related knowledge, skills, and experience.