Senior Data Engineer (Cloud / Snowflake / PySpark)

We love technology, and we enjoy what we do. We are always looking for innovation. We have social awareness and strive to improve it daily. We make things happen. You can trust us. Our Enrouters are always up for a challenge. We ask questions, and we love to learn. We pride ourselves on having great benefits and compensations, a fantastic work environment, flexible schedules, and policies that positively impact the balance of work and life outside of it. At Enroute, we are looking for a **Senior Data Engineer** to join a growing Data team responsible for designing, building, and evolving scalable data platforms and cloud-native pipelines that support business intelligence, analytics, and operational workloads. The ideal candidate is highly hands-on with **Python, Spark/PySpark, Snowflake, and cloud-based data architectures**, with strong experience building reliable, production-grade ETL/ELT pipelines and modern data warehousing solutions. This role is ideal for someone who enjoys solving complex data challenges, optimizing performance at scale, and collaborating closely with data scientists, analysts, and engineering teams. **Requirements** ### ✅ Must-Have Requirements **Core Data Engineering** * **5+ years of professional experience** in Data Engineering or related fields * Strong experience designing and maintaining **scalable data pipelines** * Deep understanding of **ETL / ELT best practices** * Strong experience with **large-scale data processing architectures** * Proven experience with **batch data processing** * Strong experience with **data warehousing concepts** ### **Programming & Data Processing** * Advanced **Python** * Strong hands-on experience with **Apache Spark / PySpark** * Advanced **SQL** (complex queries, optimization, transformations) * Strong experience processing **large structured and unstructured datasets** ### **Cloud & Infrastructure** * Hands-on experience with **AWS or Azure** * Experience building **cloud-native data solutions** * Experience with **Docker** * Experience with **CI/CD pipelines** * Strong knowledge of **Git / version control** ### **Data Orchestration** * Strong hands-on experience with **Apache Airflow** * Experience designing **workflow orchestration pipelines** * Scheduling, monitoring, and failure recovery strategies ### **Critical Must-Have** * **Strong expertise in Snowflake (MUST HAVE)** * Snowflake data warehouse **design** * Snowflake **development** * Query and warehouse **optimization** * Performance tuning and **cost efficiency** * Cloud data warehouse architecture best practices ### **🎯 Responsibilities** * Design, build, and maintain **scalable, reliable, and high-performance data pipelines** * Develop end-to-end **ETL / ELT workflows** * Process large-scale datasets using **Spark / PySpark** * Build and orchestrate cloud-native pipelines in **AWS and/or Azure** * Design and optimize **Snowflake data warehouse solutions** * Ensure **performance, scalability, governance, and cost optimization** * Write and optimize **advanced SQL queries** * Collaborate with **Data Scientists, Analysts, and Software Engineers** * Translate business requirements into **production-ready data solutions** * Ensure **data consistency, availability, and quality** * Implement **CI/CD, Git workflows, and Dockerized deployments** * Improve reliability and observability of data platforms **Benefits** * Monetary compensation * Year-end Bonus * IMSS, AFORE, INFONAVIT * Major Medical Expenses Insurance * Minor Medical Expenses Insurance * Life Insurance * Funeral Expenses Insurance * Preferential rates for car insurance * TDU Membership * Holidays and Vacations * Sick days * Bereavement days * Civil Marriage days * Maternity & Paternity leave * English and Spanish classes * Performance Management Framework * Certifications * TALISIS Agreement: Discounts at ADVENIO, Harmon Hall, U-ERRE, UNID * Taquitos Rewards * Amazon Gift Card on your Birthday * Work-from-home Bonus * Laptop Policy **Equal employment** Enroute is committed to providing equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.