Snowflake Data Engineer

Lithia & Driveway•Tigard, OR

48d•$80,000 - $115,000

About The Position

Lithia & Driveway is hiring a Data Engineer to develop, implement, and support scalable data pipelines and workflows across cloud platforms. The 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. The Data Engineer works with Data Architects, Analysts, and cross-functional teams to ensure reliable data ingestion, transformation, and accessibility for enterprise reporting and analytics, and contributes to migrating on-premises SQL Server data solutions to cloud-based environments. The ideal candidate resides in Oregon (Portland, Eugene, or Medford), Seattle, Dallas, or Denver. Travel is up to 15% of the time. Compensation is $80,000–$115,000, with a typical starting range of $80,000–$110,000; final compensation depends on skills, experience, job-related knowledge, and location. Applicants must be high school graduates or equivalent and at least 18 years old. The position is not eligible for visa sponsorship; candidates must be authorized to work in the United States without employer sponsorship now or in the future. This is a drug-free workplace.

Requirements

At least 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, such as Azure Data Factory, Synapse, and ADLS.
Hands-on experience with Snowflake, including data loading, transformation, and 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 and ability to manage multiple priorities.
Effective communication and collaboration skills in a cross-functional environment.
High school graduate or equivalent and at least 18 years old.
Authorized to work in the United States without employer sponsorship now or in the future.

Nice To Haves

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

Responsibilities

Design and implement scalable data ingestion and transformation processes into Snowflake and downstream platforms.
Migrate on-premises 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 and governance practices, and maintain thorough documentation across 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.