Snowflake Data Engineer

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

Benefits offered by this job

Medical, Dental, Vision Plans

401(k) Retirement Plan

Employee Stock Purchase Plan

Job summary

Lithia & Driveway is seeking a Data Engineer to design, build, and optimize scalable data pipelines across cloud platforms. The role focuses on ETL/ELT processes using Azure Data Factory, Azure Synapse, and Snowflake to support enterprise reporting and analytics.

You will migrate on-prem SQL Server solutions to Azure-based environments, implement monitoring and CI/CD practices, and collaborate with data architects and cross-functional teams to ensure data quality and accessibility.

Qualifications

• 2+ years of experience in data engineering or analytics.
• Strong SQL expertise with complex joins and performance tuning.
• Experience designing/building data pipelines in cloud environments (Azure Data Factory, Synapse, ADLS).
• Hands-on Snowflake experience for data loading and transformations.
• Familiarity with version control (Git) and CI/CD practices.

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 for performance and scalability.
• Build and maintain ETL/ELT pipelines using Azure Data Factory and related tools.
• Develop and optimize SQL scripts, stored procedures, and data pipelines for accuracy and efficiency.
• Implement monitoring, alerting, and self-healing capabilities to resolve data pipeline issues.

Skills

SQL

ETL/ELT

Cloud data pipelines

Data warehousing

CI/CD

Python

Tools

Azure Data Factory

Azure Synapse

Snowflake

Git

CI/CD tooling

Job description

Dealership:Lithia & Driveway | Data EngineerAt 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 DenverTravel: Up to 15% of the timeCompensation 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 DoDesign and implement scalable data ingestion and transformation processes into Snowflake and downstream platformsMigrate on-prem SQL Server data processes to Azure-based solutions to improve performance and scalabilityBuild and maintain ETL/ELT pipelines using Azure Data Factory and related toolsDevelop, test, and optimize SQL scripts, stored procedures, and data pipelines to ensure data accuracy and efficiencyImplement monitoring, alerting, and self-healing capabilities to proactively resolve data pipeline issuesPartner with business stakeholders and cross-functional teams to deliver data integration and MDM solutionsApply data standards, governance practices, and thorough documentation across all workflowsSupport CI/CD processes to improve deployment, automation, and code qualityMentor junior team members and contribute to continuous improvement of engineering practicesParticipate in a Tier-3 on-call rotation to support production systemsWhat You'll Bring2+ years of experience in data engineering, analytics, or a related fieldStrong SQL expertise, including query optimization, complex joins, and stored proceduresExperience 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 conceptsExperience with version control (Git/TFS) and CI/CD practicesStrong attention to detail with the ability to manage multiple prioritiesEffective communication and collaboration skills in a cross-functional environmentPreferredExposure to Python for data processing, automation, or scriptingExperience with tools such as Databricks, Postgres, DBT, or similarFamiliarity 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 payMedical, Dental and Vision PlansPaid Holidays & PTOShort and Long-Term DisabilityPaid Life Insurance401(k) Retirement PlanEmployee Stock Purchase PlanLithia Learning CenterVehicle Purchase DiscountsWellness ProgramsFor 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.