Lithia Motors
Snowflake Data Engineer
NewWhat's your preference?
Job Description
- Req#: R100952
Design and implement data ingestion and transformation processes to load data from disparate source systems into Snowflake and downstream data platforms to enable reliable enterprise reporting and analytics.
Migrate existing on-premises SQL Server data processes and datasets to Azure-based solutions to improve scalability, performance, and long-term maintainability.
Integrate Azure Data Factory with Snowflake for automated data extraction, transformation, and loading processes
Develop, test, and maintain SQL scripts, stored procedures, and data pipelines to ensure accurate , timely , and efficient data processing.
Ensure data is created, structured, and maintained according to established standards and documentation requirements to support data governance and usability.
Build and configure end-to-end telemetry, alerting, and self-healing capabilities to proactively identify and resolve data pipeline issues.
Collaborate with business stakeholders to understand requirements and translate them into effective data integration and MDM solutions
Implement CI/CD pipelines for data engineering projects to enhance deployment and automation capabilities
Ensure thorough documentation and compliance with data standards across all processes
Mentor and support junior team members through knowledge sharing, technical guidance, and code reviews to strengthen team capability and consistency.
Strive for continuous improvement of code quality and development practices.
Participate as part of a Tier-3 on-call rotation to support team-built software
Working knowledge of cloud-based data platforms and modern data pipeline design principles, including:
Azure Data Services: Azure Data Factory, Synapse, Functions, Logic Apps, ADLS, and Blob Storage
Development & Integration Tools: SSMS, Visual Studio, Azure DevOps
Data Platforms & Engineering Tools: Snowflake, Databricks, and DBT
Proficiency in Snowflake development , including stored procedures, UDFs, query performance tuning, and Snowpipe configuration.
Strong SQL development skills, including query optimization and stored procedure design.
Solid understanding of ETL/ELT processes , data integration patterns, and foundational data warehouse concepts.
Experience supporting and troubleshooting data integrations across cross-functional teams .
Proficiency with version control systems such as Git or TFS.
Knowledge of CI/CD pipelines and best practices for data engineering projects.
Strong attention to detail with the ability to manage multiple priorities and deadlines effectively.
Excellent communication and collaboration skills.
1+ year of experience in analytics or data engineering, working closely with cross-functional teams.
2+ years of experience in SQL Server development or equivalent SQL-based data engineering environments.
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
Dealership:
L0105 Lithia Home OfficeData Engineer | Lithia & Driveway
Location: Remote (PST work hours, preferred)
Compensation: The full salary range for this position is $80,000-$115,000 annually. The anticipated starting pay is $80,000-$110,000, determined by factors such as skills, experience, and organizational considerations. Final compensation will be established through the interview process in accordance with applicable pay equity and transparency laws.
Lithia & Driveway (LAD) is one of the largest global automotive retailers providing a wide array of products and services throughout the ownership lifecycle with a vision to modernize personal transportation solutions wherever, whenever, and however consumers desire. With a mission of "Growth Powered by People," we are propelled by our colleagues and preferred by our customers, making Lithia & Driveway the leading automotive retailer in each of our markets. Our success is fueled by four core values: earning customers for life, improving constantly, taking personal ownership, and having fun. Our entrepreneurial, high-performance culture sets us apart, and our philosophy is straightforward: assemble a team of passionate individuals and cultivate an environment that empowers colleagues to excel. We’d love to have you join us on our journey!
Role Overview
The Data Engineer plays a critical role in building and maintaining the data foundation that supports analytics, reporting, and business decision-making. This position is responsible for developing, implementing, and supporting scalable data pipelines and managing data engineering workflows across modern cloud platforms. With a strong focus on automation, performance, and data quality, the Data Engineer designs, builds, and migrates ETL/ELT processes using technologies such as Azure Data Factory, Azure Synapse, and Snowflake.
Working closely with Data Architects, Data Analysts, and fellow engineers, the Data Engineer contributes to robust data ingestion, transformation, and analytics pipelines. This role receives technical direction from the Lead Data Engineer and operates primarily within Azure and Snowflake environments, partnering across teams to ensure data integrity, operational excellence, and continuous improvement.
What You'll Do
What You'll Bring
Skills
Experience
We offer best in class industry benefits:
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.
About the company
Notice
Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000.
Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.
An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report. NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.