onsite
Senior Data Engineer - MRCOOL, LLC
Data Engineer
Senior Data Engineer responsible for designing, building, and governing a modern Snowflake‑based enterprise data warehouse, integrating data from ERP, CRM, e‑commerce, and other systems using Python, SQL, and Airflow.
About the role
Key Responsibilities
- Architect and implement a greenfield Snowflake data platform that consolidates data from ERP, accounting, CRM, e‑commerce, EDI, support, and telephony systems.
- Design scalable data models, pipelines, and ELT processes to create a single source of truth for analytics and reporting.
- Develop, schedule, and monitor data workflows using Apache Airflow or equivalent orchestration tools.
- Write production‑grade Python and SQL code for data extraction, transformation, and loading.
- Establish data governance, quality checks, and documentation to ensure reliability and compliance.
- Collaborate with cross‑functional teams (product, finance, operations) to understand data needs and deliver actionable insights.
Requirements
- 5+ years of experience in data engineering, with a strong focus on cloud data warehouses, preferably Snowflake.
- Proficiency in Python and advanced SQL for building robust ETL/ELT pipelines.
- Hands‑on experience designing data models and data pipelines using tools such as Apache Airflow, dbt, or similar.
- Solid understanding of data integration from heterogeneous sources (ERP, CRM, e‑commerce, etc.) and data governance best practices.
- Excellent problem‑solving skills and ability to work autonomously in a fast‑growing, technology‑driven environment.