Snowflake Data Engineer

Pfaff Harley-Davidson; Tigard (OR); On-site; USD 80,000 - 115,000; Full time

Benefits offered by this job

Competitive pay

Medical, Dental and Vision Plans

Paid Holidays & PTO

Disability insurance

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 scalable data ingestion and transformation pipelines, migrating on-prem data to Azure-based cloud solutions, and building ETL/ELT processes with Data Factory and Snowflake. The role emphasizes automation, data quality, and collaboration with Architects, Analysts, and cross-functional teams.

Ideal candidates bring 2+ years in data engineering, strong SQL, Snowflake expertise, and experience with cloud ETL/ELT.

Qualifications

• 2+ years of experience in data engineering, analytics, or a related field.
• Strong SQL expertise, including query optimization and stored procedures.
• Experience building data pipelines in cloud environments (Azure Data Factory, Synapse, ADLS).
• Hands-on with Snowflake (data loading, transformation, performance tuning).
• Solid understanding of ETL/ELT and data warehousing concepts.
• Experience with version control (Git/TFS) and CI/CD practices.
• Attention to detail and ability to manage multiple priorities.
• Effective communication in a cross-functional team.
• Exposure to Python for data processing or scripting (preferred).
• Familiarity with Databricks, Postgres, DBT; knowledge of AI-enabled tools (Claude/Copilot).

Responsibilities

• Design scalable data ingestion/transformation processes for Snowflake and downstream platforms.
• Migrate on-prem SQL Server data processes to Azure-based solutions to improve performance.
• Build and maintain ETL/ELT pipelines with Azure Data Factory and related tools.
• Develop, test, and optimize SQL scripts and data pipelines for accuracy and efficiency.
• Implement monitoring, alerting, and self-healing capabilities for data pipelines.
• Partner with stakeholders to deliver data integration and MDM solutions.
• Apply data standards, governance, and thorough documentation across workflows.
• Support CI/CD processes to improve deployment and code quality.
• Mentor junior engineers and contribute to engineering practices.

Skills

SQL

Azure Data Factory

Snowflake

ETL/ELT

CI/CD

Python

Databricks

Postgres

Git/TFS

Communication

Tools

Azure Data Factory

Azure Synapse

Snowflake

ADLS

Databricks

Postgres

DBT

Git

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)

Benefits

• 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.

At Lithia & Driveway, we stand by our mission of Growth Powered by People, as we build a workplace that ignites ideas and opportunities to Earn Customers for Life. Our focus is on making the customer experience better; as we aim to meet our customers’ needs whether in person, online or a combination of both. Lithia & Driveway is the largest automotive retailer in North America and listed on the Fortune 500 (NYSE: LAD). Drive your career forward with roles in Sales, Finance, Service, Technology and Corporate. With thousands of vehicles and hundreds of locations, the career possibilities are endless. Join us as we accelerate towards growth in automotive and beyond!