Lead Data Engineer

Department: IT | Level: Lead Role Summary The Data Engineer is responsible for designing, building, and maintaining the enterprise data platform that powers analytics, reporting, and business applications across El Car Wash. This role develops scalable data pipelines, integrates data from multiple business systems, and transforms raw data into trusted, business-ready datasets that support Finance, Operations, Marketing, Customer Experience, and Technology. As a key member of the Technology team, the Data Engineer will build and optimize our Snowflake data platform using a modern medallion architecture (Bronze, Silver, Gold), ensuring data is reliable, secure, well-governed, and accessible. This role will partner closely with cross-functional stakeholders to support business intelligence, automation, and future AI initiatives while helping standardize data across acquisitions and multiple source systems. Key Responsibilities Design, build, and maintain scalable data pipelines within the Snowflake data platform using a Bronze, Silver, and Gold (medallion) architecture. Develop and optimize data models using dbt Cloud to create reliable, business-ready datasets. Integrate and manage data from multiple enterprise systems including POS, HRIS, ERP, CRM, Finance, Marketing, and operational platforms. Lead the migration of legacy SQL Server and Azure SQL data environments into a modern cloud-based architecture. Develop and maintain a unified enterprise data model that standardizes information across multiple source systems and acquisitions. Build automated ingestion, transformation, and change-detection processes to support new business applications and acquisitions. Implement data quality standards, testing, documentation, monitoring, and governance best practices. Establish CI/CD processes and version control to support reliable, scalable data development. Partner with Finance, Operations, Marketing, and Technology teams to understand business requirements and deliver trusted reporting and analytics solutions. Support business intelligence, dashboards, self-service reporting, and future AI and automation initiatives. Troubleshoot data issues, optimize platform performance, and continuously improve the reliability and scalability of the data ecosystem. Qualifications

QUALIFICATIONS:

Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field, or equivalent experience. 5+ years of experience in data engineering, data warehousing, or analytics engineering. Strong experience with Snowflake, including warehouse management, security, and performance optimization. Experience with dbt and dbt Cloud for data modeling, testing, documentation, and deployment. Advanced SQL skills with experience optimizing and modernizing legacy SQL environments. Experience designing dimensional data models, including Kimball methodologies and Slowly Changing Dimensions (SCD Type 2). Experience building scalable ETL/ELT pipelines using Python and modern orchestration tools. Familiarity with Azure cloud services including Azure Data Lake Storage, Azure Data Factory, Key Vault, and related services. Experience with Git-based version control and CI/CD processes. Experience integrating multiple enterprise applications and APIs. Knowledge of business intelligence platforms such as Power BI or similar visualization tools. Experience supporting retail, hospitality, automotive, or multi-location businesses is preferred. Excellent analytical, problem-solving, communication, and stakeholder management skills. Ability to thrive in a fast-paced, high-growth environment and effectively manage multiple priorities. #J-18808-Ljbffr El Car Wash