Senior Database Engineer

About Enroute:

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.

We are looking for a Senior Data Engineer to join our growing data team. This role will be responsible for creating, automating, and maintaining robust data pipelines, working with large and complex datasets, and integrating data from multiple sources. You will play a critical role in enabling scalable, efficient data solutions to support business and technology needs.

Requirements

5+ years of professional experience in data engineering or related fields.

Strong programming skills in Python and experience with Spark/PySpark.

Deep experience with AWS cloud services for data processing (Glue, S3, Lambda, Step Functions, ECS, etc.).

Proficiency in SQL and Bash scripting.

Hands-on experience with container technologies like Docker.

Knowledge of CI/CD pipelines and version control using Git.

Experience working with Snowflake or similar cloud-based data warehouses.

Solid understanding of data integration, ETL best practices, and large-scale data processing.

Strong problem-solving skills and the ability to work independently and collaboratively.

Key Skills and Attributes
Design, build, and maintain scalable and reliable data pipelines.

Extract, transform, and load large datasets from various structured and unstructured data sources using Spark/PySpark.

Develop and integrate data processing solutions leveraging AWS services such as Glue, S3, Step Functions, Lambda, EC2, Batch, ECR, and ECS.

Write and optimize complex SQL queries for large-scale data processing and analysis.

Translate business and technical requirements into detailed, functional data solutions.

Collaborate with cross-functional teams to support data initiatives and ensure consistent data delivery.

Implement best practices for code versioning (Git), CI/CD processes, and containerization (Docker).

Utilize Snowflake for scalable data storage and analytics.

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.