Snowflake Data Engineer

Lithia Motors; Eugene (OR); On-site; USD 80,000 - 115,000; Full time

Benefits offered by this job

Competitive pay

Medical/Dental/Vision plans

Paid holidays & PTO

Short and long-term disability

Paid life insurance

401(k) retirement plan

Employee stock purchase plan

Lithia Learning Center

Vehicle purchase discounts

Wellness programs

Job summary

Lithia & Driveway is seeking a Data Engineer to design, build, and optimize scalable ETL/ELT pipelines across Azure and Snowflake. You will migrate on-prem SQL Server processes to cloud solutions, and ensure data quality for enterprise reporting and analytics.

The role requires 2+ years in data engineering, strong SQL, and hands-on cloud data tooling (Azure Data Factory, Synapse, ADLS, Snowflake). Oregon-based location preferred with up to 15% travel.

Qualifications

• 2+ years of experience in data engineering or a related field.
• Strong SQL expertise, including query optimization and stored procedures.
• Experience designing and building data pipelines in cloud environments (Azure Data Factory, Synapse, ADLS).
• Hands-on experience with Snowflake (data loading, transformation, performance tuning).
• Solid understanding of ETL/ELT processes and data warehousing concepts.
• Experience with version control (Git/TFS) and CI/CD practices.
• Strong attention to detail with the ability to manage multiple priorities.
• Effective communication and collaboration skills in a cross-functional environment.

Responsibilities

• Design and implement scalable data ingestion and transformation processes into Snowflake and downstream platforms.
• Migrate on-prem SQL Server data processes to Azure-based solutions to improve performance and scalability.
• Build and maintain ETL/ELT pipelines using Azure Data Factory and related tools.
• Develop, test, and optimize SQL scripts, stored procedures, and data pipelines to ensure data accuracy and efficiency.
• Implement monitoring, alerting, and self-healing capabilities to proactively resolve data pipeline issues.
• Partner with business stakeholders and cross-functional teams to deliver data integration and MDM solutions.
• Apply data standards, governance practices, and thorough documentation across all workflows.
• Support CI/CD processes to improve deployment, automation, and code quality.
• Mentor junior team members and contribute to continuous improvement of engineering practices.
• Participate in a Tier-3 on-call rotation to support production systems.

Skills

2+ years data engineering

Strong SQL

CI/CD practices

Cross-functional collaboration

Attention to detail

Tools

Azure Data Factory

Azure Synapse

ADLS

Snowflake

Git/TFS

Job description

Dealership:

Lithia & Driveway | Data Engineer

At Lithia & Driveway (NYSE: LAD) our success is fueled by our high performing teams delivering Auto Done Easy for our customers. We create simple, transparent, and convenient customer experiences throughout the vehicle-ownership lifecycle by leveraging our hundreds of store locations and our key adjacencies - Driveway, DFC, and GreenCars. We’ve built a retail model that champions entrepreneurial leadership, Growth Powered by People , and a strategy that creates possibilities and pushes us to reach our potential.

The Data Engineer is responsible for developing, implementing, and supporting scalable data pipelines and workflows across cloud platforms. This role focuses on designing, building, and optimizing ETL/ELT processes using Azure Data Factory, Azure Synapse, Snowflake, and related technologies, with an emphasis on automation, performance, and data quality.

Working closely with Data Architects, Analysts, and cross-functional teams, the Data Engineer ensures reliable data ingestion, transformation, and accessibility to support enterprise reporting and analytics. This role also contributes to the migration of on-premises SQL Server data solutions to modern cloud-based environments.

Location: Ideal candidate to reside in Oregon (Portland, Eugene, Medford), Seattle, Dallas or Denver

Travel: Up to 15% of the time

Compensation Range: $80,000-$115,000, with a typical starting range of $80,000-$110,000. Actual pay may vary based on skills, experience, job-related knowledge, and location. Final compensation will be determined during the interview process in accordance with applicable pay equity and transparency laws.

What You'll Do

• Design and implement scalable data ingestion and transformation processes into Snowflake and downstream platforms
• Migrate on-prem SQL Server data processes to Azure-based solutions to improve performance and scalability
• Build and maintain ETL/ELT pipelines using Azure Data Factory and related tools
• Develop, test, and optimize SQL scripts, stored procedures, and data pipelines to ensure data accuracy and efficiency
• Implement monitoring, alerting, and self-healing capabilities to proactively resolve data pipeline issues
• Partner with business stakeholders and cross-functional teams to deliver data integration and MDM solutions
• Apply data standards, governance practices, and thorough documentation across all workflows
• Support CI/CD processes to improve deployment, automation, and code quality
• Mentor junior team members and contribute to continuous improvement of engineering practices
• Participate in a Tier-3 on-call rotation to support production systems

What You'll Bring

• 2+ years of experience in data engineering, analytics, or a related field
• Strong SQL expertise, including query optimization, complex joins, and stored procedures
• Experience designing and building data pipelines in cloud environments (Azure Data Factory, Synapse, ADLS, etc.)
• Hands-on experience with Snowflake (data loading, transformation, performance tuning)
• Solid understanding of ETL/ELT processes and data warehousing concepts
• Experience with version control (Git/TFS) and CI/CD practices
• Strong attention to detail with the ability to manage multiple priorities
• Effective communication and collaboration skills in a cross-functional environment

Preferred

• Exposure to Python for data processing, automation, or scripting
• Experience with tools such as Databricks, Postgres, DBT, or similar
• Familiarity with AI-enabled development tools (e.g., Claude Code, Cortex, Copilot)

We offer a comprehensive benefits package designed to support you and your family, including:

• Competitive pay
• Medical, Dental and Vision Plans
• Paid Holidays & PTO
• Short and Long-Term Disability
• Paid Life Insurance
• 401(k) Retirement Plan
• Employee Stock Purchase Plan
• Lithia Learning Center
• Vehicle Purchase Discounts
• Wellness Programs

For a more detailed view, visit: www.totalrewards.lithiadriveway.com .

High School graduate or equivalent, 18 years or older required. We are a drug free workplace. We are committed to equal employment opportunity (regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status). We also consider qualified applicants regardless of criminal histories, consistent with legal requirements.

This position is not eligible for visa sponsorship. Candidates must be authorized to work in the United States without the need for employer sponsorship now or in the future.