[Hiring] Snowflake Data Engineer @Lithia & Driveway

This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description 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. • 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. Qualifications • 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. Requirements • 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. 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 Apply tot his job