Data Engineer Mid

Reservamos; À distance; EUR 40 000 - 60 000; Plein temps

Résumé du poste

A leading technology firm in Gouaux-de-Luchon is seeking a Data Engineer to maintain and extend their Data Lake and implement ETL pipelines. This role is ideal for candidates with over 3 years of experience in Elixir/Phoenix, Python for data pipeline development, and strong SQL skills. The company promotes a collaborative environment, and offers remote work flexibility along with competitive benefits including 20 days of paid vacation and other perks.

Prestations

20 days paid time off

Remote work flexibility

Permanent training access

Qualifications

• 3+ years of experience with Elixir/Phoenix.
• Experience with Python for data processing.
• Strong understanding of SQL and databases.

Responsabilités

• Help maintain and extend the Data Lake.
• Propose and implement ETL pipelines.
• Integrate WhatsApp Business API for notifications.

Connaissances

Clean, readable code

Elixir/Phoenix programming

SQL & Databases

Python data pipeline development

Data Engineering

Outils

PostgreSQL

ClickHouse

WhatsApp Business API

Description du poste

Technology is transforming the way people travel and were here to drive that evolution from the ground up. In 2014, at MIT, we decided to embark on this journey by focusing on the bus industry. Why? Because its the most widely used mode of transportation in Latin America, with over 10 billion passengers per year 13 times more than air travel. Yet, only 10% of tickets are currently sold online.

We know thats changing. And we strongly believe that digital sales will soon surpass 50%. Today, Reserhub is becoming the operating system for ground transportation, connecting companies with tech solutions that integrate data, pricing intelligence, and tools to digitalize their operations from ticket sales to revenue management and customer loyalty.

Our ecosystem powers leading brands like Primera Plus, ETN, and others across the region. And we continue to grow our network with a clear mission: to connect data, people, and technology to accelerate digital transformation. Our motto says it all: "Be creative, take ownership, and be a team player."

What youll do

• Help maintain and extend our Data Lake, ingesting behavioral data from Mixpanel and processing it in ClickHouse to provide intelligence for our customers and partners.
• Propose and implement ETL pipelines that transform raw event data into structured analytics tables, enabling cohort analysis and customer segmentation.
• Implement and improve data validation and transformation steps to ensure data quality and consistency across our analytics infrastructure.
• Maintain our ticket sales data pipeline, tracking transactions from purchase through fulfillment for analytics and reporting.
• Contribute to our messaging infrastructure, integrating WhatsApp Business API to send automated notifications and personalized messages to customers.
• Write and review database migrations and work with PostgreSQL and ClickHouse.
• Collaborate with product and engineering teams to deliver analytics and personalization features.
• Help monitor the performance of data pipelines and APIs to handle growing volumes of traffic and events.

Who you are

We\'re looking for someone with engineering skills in both development and data engineering who shares our core values:

• You care about clean, readable code.
• You enjoy learning new tools and diving into unfamiliar systems.
• You can break down tasks into smaller pieces and communicate progress clearly.
• You write clear PR descriptions, documentation, and messages to teammates.
• You collaborate well and enjoy pair programming and reviewing code.
• You have a mindset for performance and enjoy writing efficient software.

When it comes to technology, you dont need to know it all — just be ready to pick things up fast. Youll fit right in if you have experience in these areas 3+ years of experience:

• Elixir/Phoenix — our primary backend language. Strong understanding of functional programming, OTP, GenServers, and building scalable web applications. Experience with Ecto for database interactions.
• Python — for data pipeline development and ETL processes. Experience with data processing libraries and frameworks.
• SQL & Databases — knowledge of PostgreSQL for transactional workloads.
• Data Engineering — experience building ETL/ELT pipelines, data modeling for analytics, handling data quality, and working with large datasets.

Nice to have:

• Backend Development — REST API design, webhook implementations, background job processing, and microservices architecture.
• Analytics platforms — Experience with platforms like Mixpanel, Segment, or Amplitude.
• Its a bonus if youve worked with tools like OneSignal or Fingerprint.
• Experience with ClickHouse.
• Messaging platforms — Experience with messaging APIs like WhatsApp Business API or SMS providers.
• Cloud Infrastructure — (Google Cloud Storage, Cloud Functions) and understanding of distributed systems.

In our team, everyone works across all of our applications — or at least we try. We share ownership, collaborate closely, and help each other maintain and improve every part of the platform.

Some of our projects

Data Lake & Analytics Infrastructure

We\'re building a comprehensive data lake that consolidates behavioral data from multiple sources. Currently, we\'re ingesting event data from Mixpanel (tracking millions of user interactions across our sites) and storing it in ClickHouse for fast analytical queries.

Ticket Sales Pipeline

We\'ve built an end-to-end pipeline that tracks every ticket purchase from search to fulfillment. This pipeline processes thousands of transactions daily and serves as the foundation for revenue analytics and business intelligence.

Using the behavioral data in our data lake, we\'re building intelligent systems to improve the customer experience:

• WhatsApp Notifications — Automated purchase confirmations, trip updates, and personalized messages sent via WhatsApp Business API with dynamic template selection based on tenant and language
• Discount Engine — Smart discount application based on user cohorts, booking patterns, and partner strategies
• User Profile Integration — Automatic registration of users in OneSignal for push notifications, with phone normalization and subscription management

How to apply

• Take-home project we invite you to complete a small technical project. Expect to spend about half a day on this.
• In-depth interview after the take-home project, we do a longer interview where we\'ll ask you questions about the project and your experience in previous roles.
• Culture fit interview during this one hour interview, we\'ll talk about your experience and expectations, no coding required.

Pay and benefits:

• Work remotely from wherever you\'re most productive, no commuting to an office.
• 20 days paid time off four weeks of total time off for you to use throughout the year.
• Day off on your birthday, enjoy your birthday with friends and family.
• Day off on official festivities (Mothers Day, Christmas Eve, Holy Thursday & Friday).
• Permanent training access to books, learning platforms, etc.
• 100% payroll (IMSS + Infonavit).
• 2 weeks aguinaldo.
• Unlimited flight discounts with Viva Aerobus (only pay TUA).