Senior Data Engineer

We love technology, and we enjoy what we do. We are always looking for innovation. We have social awareness and try 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. We care about who you are in the office and as an individual. We get involved, we like to know our people, we want every Enrouter to become part of a great community of highly driven, responsible, respectful, and above all, happy people. We want you to enjoy working with us.Enroute is seeking a **Senior Data Engineer** to design, build, and optimize our next-generation data infrastructure. This role is for a cloud-native expert passionate about scalability, performance, and using **Snowflake** and **AWS** to solve complex, large-scale data challenges. You will be instrumental in turning raw data into actionable intelligence across the organization.**Requirements**:- **Experience**:5+ years** of professional experience in data engineering or related fields.- **Core Programming**: Strong programming skills in **Python** and proven experience with **Spark/PySpark**.- **Data Warehousing**:Deep expertise in Snowflake**, specifically in the design, development, and optimization of cloud-based data warehouses.- **Cloud Engineering**: Deep hands-on experience with **AWS cloud services** for data processing and orchestration (Glue, S3, Lambda, Step Functions, ECS, etc.).- **Scripting & Querying**: Advanced proficiency in **SQL and Bash scripting**.- **DevOps/MLOps**: Practical experience with container technologies (**Docker**) and knowledge of **CI/CD pipelines** and version control using **Git**.**Key Responsibilities**:**Pipeline Design and Execution**- Design, build, and maintain **scalable, reliable, and high-performance data pipelines** to support analytical and operational use cases.- Perform **Extract, Transform, and Load (ETL/ELT)** of large volumes of structured and unstructured data using **Spark/PySpark** and other modern frameworks.- Orchestrate end-to-end data processing solutions leveraging a wide array of **AWS cloud services** (including Glue, S3, Step Functions, Lambda, EC2, ECR, and ECS).**Cloud Data Warehousing & Optimization**- Utilize and optimize **Snowflake** for data warehousing, transformation, and analytical workloads, ensuring industry-leading **scalability and cost efficiency** (**Must-Have Expertise**).- Write, tune, and maintain complex **SQL queries and Bash scripts** for large-scale data analysis and processing.- Implement advanced best practices for data modeling and ETL architectures.**Engineering Best Practices & Collaboration**- Implement engineering rigor, including **CI/CD automation**, version control (**Git**), and containerization (**Docker**) for reliable and repeatable deployments.- Collaborate with cross-functional teams—including data scientists, analysts, and software engineers—to translate business needs into well-architected data solutions.**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.