Data Engineer

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

Job summary

El Car Wash is seeking a Data Engineer to design, build, and maintain its enterprise data platform, enabling analytics, reporting, and business applications across Finance, Operations, Marketing, Customer Experience, and Technology.

You will work on a Snowflake-based medallion architecture, optimize data models with dbt Cloud, and partner with various teams to deliver trusted data and reporting solutions. This role emphasizes scalable pipelines, data governance, and future AI initiatives.

Qualifications

• Bachelor's degree or equivalent experience.
• 5+ years in data engineering, warehousing, or analytics.
• Strong Snowflake expertise including security and performance.
• dbt/ dbt Cloud for modeling, testing, and deployment.
• Advanced SQL; experience modernizing legacy SQL environments.
• Dimensional modeling with Kimball methods and SCD Type 2.
• ETL/ELT pipelines using Python and orchestration tools.
• Azure cloud services including Data Lake Storage and Data Factory.
• Git-based version control and CI/CD experience.
• Integrating multiple enterprise apps and APIs.
• Knowledge of Power BI or similar BI tools.
• Experience in retail/hospitality/automotive multi-location businesses is preferred.
• Excellent analytical, problem-solving, communication, and stakeholder management skills.

Responsibilities

• Design, build, and maintain scalable data pipelines within Snowflake (bronze-silver-gold).
• Develop and optimize data models with dbt Cloud to create reliable datasets.
• Integrate data from POS, HRIS, ERP, CRM, Finance, Marketing, and ops systems.
• Lead migration of legacy SQL Server/Azure SQL to cloud-based architecture.
• Develop a unified enterprise data model across sources and acquisitions.
• Build automated ingestion, transformation, and change-detection processes.
• Implement data quality, testing, documentation, monitoring, and governance.
• Establish CI/CD processes and version control for data development.
• Collaborate with Finance, Operations, Marketing, and Tech for trusted reporting.
• Support BI, dashboards, self-service analytics, and AI initiatives.
• Troubleshoot data issues and optimize platform performance.

Skills

Analytical skills

Problem-solving

Communication

Stakeholder management

Education

Bachelor's degree in CS/IS/Data Engineering

Tools

Snowflake

dbt Cloud

dbt

Python

Azure Data Lake Storage

Azure Data Factory

Key Vault

Git

Power BI

Job description

THE ROLE
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.

Level: Manager/Lead | Salary
Department: IT
THE ROLE
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.