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 aSenior 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 withPython, 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 maintainingscalable data pipelines
• Deep understanding ofETL / ELT best practices
• Strong experience withlarge-scale data processing architectures
• Proven experience withbatch data processing
• Strong experience withdata warehousing concepts

Programming & Data Processing

• AdvancedPython
• Strong hands-on experience withApache Spark / PySpark
• AdvancedSQL (complex queries, optimization, transformations)
• Strong experience processinglarge structured and unstructured datasets

Cloud & Infrastructure

• Hands-on experience withAWS or Azure
• Experience buildingcloud-native data solutions
• Experience withDocker
• Experience withCI/CD pipelines
• Strong knowledge ofGit / version control

Data Orchestration

• Strong hands-on experience withApache Airflow
• Experience designingworkflow orchestration pipelines
• Scheduling, monitoring, and failure recovery strategies

Critical Must-Have

• Strong expertise in Snowflake (MUST HAVE)
• Snowflake data warehousedesign
• Snowflakedevelopment
• Query and warehouseoptimization
• Performance tuning andcost efficiency
• Cloud data warehouse architecture best practices

🎯 Responsibilities

• Design, build, and maintainscalable, reliable, and high-performance data pipelines
• Develop end-to-endETL / ELT workflows
• Process large-scale datasets usingSpark / PySpark
• Build and orchestrate cloud-native pipelines inAWS and/or Azure
• Design and optimizeSnowflake data warehouse solutions
• Ensureperformance, scalability, governance, and cost optimization
• Write and optimizeadvanced SQL queries
• Collaborate withData Scientists, Analysts, and Software Engineers
• Translate business requirements intoproduction-ready data solutions
• Ensuredata consistency, availability, and quality
• ImplementCI/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.