[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 Now
Apply Now
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 Now
Apply Now