Lithia Motors, Inc. Logo

Lithia Motors, Inc.

Snowflake Data Engineer

Posted 22 Hours Ago
Remote
Hiring Remotely in USA
80K-115K Annually
Junior
Remote
Hiring Remotely in USA
80K-115K Annually
Junior
Design, build, and optimize scalable ETL/ELT data pipelines into Snowflake using Azure Data Factory, Synapse, and ADLS. Migrate on-prem SQL Server processes to cloud, develop and tune SQL and stored procedures, implement monitoring and CI/CD, support production as part of Tier-3 on-call rotation, and collaborate with stakeholders to ensure data quality and governance.
The summary above was generated by AI
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: Remote (PST work hours, preferred)

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. 

Similar Jobs

Yesterday
In-Office or Remote
98K-163K Annually
Senior level
98K-163K Annually
Senior level
Consulting
Design, build, and optimize Snowflake-based data platforms, ELT/ETL pipelines, and lakehouse architectures. Implement Snowpipe, Streams, Tasks, Snowpark and Cortex features, secure/RBAC controls, performance tuning, production support, and integrations across cloud/on-prem/SaaS sources to support analytics and AI initiatives.
Top Skills: AWSAzureCdcCi/CdDbtDynamic TablesEltETLGCPGitInfrastructure As CodePythonRbacSnowflakeSnowflake CortexSnowparkSnowpipeSQLStored ProceduresStreamsTasksUdfs
Yesterday
In-Office or Remote
113K-188K Annually
Senior level
113K-188K Annually
Senior level
Consulting
Design, build, and optimize enterprise Snowflake data solutions and scalable ELT/ETL pipelines. Implement Snowflake-native ingestion (Snowpipe, Streams, Tasks, Dynamic Tables), Snowpark, SQL-based transformations, governance (RBAC), performance tuning, production support, and integrations across cloud, on‑prem, API, and SaaS sources. Support AI initiatives using Snowflake Cortex and Snowpark.
Top Skills: AWSAzureCdcCi/CdDbtDynamic TablesEltETLGCPGitInfrastructure As CodePythonRbacSnowflakeSnowflake CortexSnowparkSnowpipeSQLStored ProceduresStreamsTasksUdfs
Yesterday
In-Office or Remote
Mid level
Mid level
Payments
Design, build, test, deploy, and maintain production-grade Snowflake data pipelines, semantic views, and AI solutions using Cortex AI. Implement ingestion (Openflow, Kafka, Snowpipe, APIs), data sharing, observability, testing, and CI/CD. Optimize performance, collaborate with platform/security teams, and productionize AI agents and external-facing applications while separating account administration responsibilities.
Top Skills: APIsAzureAzure AdCortex AiCortex AnalystCortex SearchJavaScriptKafkaNetSuiteOpenflowPythonScimSnowflakeSnowflake CliSnowparkSnowpipeSnowsqlSQL ServerStreamlit

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

  • Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
  • Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
  • Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
  • Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account