Senior Data Engineer | Snowflake | PySpark | AWS

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. ✅ 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 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.