Lead Data Engineer

El Car Wash; Miami (FL); On-site; USD 110,000 - 160,000; Full time

Job summary

El Car Wash is seeking a Lead Data Engineer to design and maintain an enterprise data platform supporting analytics, reporting, and business apps. You will build scalable pipelines, integrate multiple systems, and transform data into trusted datasets for Finance, Operations, Marketing, and Customer Experience.

You'll lead the Snowflake data platform using a medallion architecture, partner with cross-functional teams, and enable BI, automation, and AI initiatives while standardizing data across

Qualifications

• Bachelor's degree or equivalent experience in a relevant field.
• 5+ years in data engineering, data warehousing, or analytics engineering.
• Strong Snowflake expertise including security and performance.
• dbt/dbt Cloud for modeling, testing, and deployment.
• Advanced SQL and modernization of legacy environments.
• Dimensional modeling with Kimball and SCD Type 2.
• ETL/ELT pipelines using Python and orchestration tools.
• Familiarity with Azure cloud services and related tools.
• Git-based version control and CI/CD processes.
• Experience integrating multiple enterprise apps and APIs.
• Power BI or similar BI tools experience.
• Experience in retail, hospitality, automotive, or multi-location contexts preferred.
• Excellent communication and stakeholder management.
• Ability to thrive in a fast-paced, high-growth environment.

Responsibilities

• Design, build, and maintain scalable data pipelines in Snowflake (Bronze-Silver-Gold).
• Develop and optimize data models using dbt Cloud.
• Integrate data from POS, HRIS, ERP, CRM, Finance, Marketing, and Ops systems.
• Lead migration of legacy SQL Server/Azure SQL to cloud architecture.
• Develop a unified enterprise data model across source systems and acquisitions.
• Automate ingestion, transformation, and change-detection for new apps.
• Implement data quality, testing, documentation, monitoring, and governance.
• Establish CI/CD and version control for reliable data development.
• Collaborate with Finance, Operations, Marketing, and Tech to deliver trusted reporting.
• Support BI dashboards, self-service reporting, and future AI initiatives.
• Troubleshoot data issues and optimize platform performance.

Skills

Analytical thinking

Problem-solving

Communication

Stakeholder management

Multi-priority management

Education

Bachelor's degree in CS/IS/Data Eng

Equivalent experience

Tools

Snowflake

dbt Cloud

Python

Azure Data Factory

Azure Data Lake Storage

Key Vault

Git

CI/CD

Power BI

Job description

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.