Senior Analytics Engineer in Barcelona

Caravelo is seeking an Analytics Engineer / Data Modeller to join our Platform Team and lead a full revamp of our data-modeling layer using a modern ELT stack (dbt + cloud warehouse). In this startup-casual environment, you’ll design scalable dimensional schemas, build and automate dbt pipelines, own CI/CD and orchestration, and establish data-governance practices that set us up for future AI initiatives.

You’ll work closely with product managers, software engineers, and data analysts to ensure our data is reliable, well-documented, and accessible, enabling Caravelo to deliver next-generation travel experiences.

Duties and responsibilities

• Architect Data Models: Design and implement star/snowflake schemas to support core product metrics (e.g. revenue by product line, incremental revenue analysis churn cohorts, LTV).
• Build ETL Pipelines: Develop dbt projects with staging layers, incremental models, snapshots, and seed tables.
• Automate Quality: Configure sqlfluff linting and dbt tests (uniqueness, not_null, custom assertions) in CI pipelines so merges pass automatically.
• Own Orchestration: Take ownership of orchestration processes including monitoring transformation jobs, source data freshness, and ingestion pipelines.
• Governance & Security: Implement PII-safe modeling patterns, maintain documentation, and enforce data-privacy controls.
• Collaboration & Mentorship: Partner with cross-functional teams to gather requirements, review code, and mentor junior engineers on best practices.
• Continuous Improvement: Identify and drive process improvements: optimizing performance, reducing cost, and embedding scalability for AI use cases.

Required skills and experience

• 3+ years in analytics engineering or data modeling roles
• Mastery of SQL (CTEs, window functions, performance tuning)
• Hands-on experience with dbt (models, tests, snapshots, incremental)
• Experience in Redshift, or other data warehouses like Snowflake, BigQuery, or Databricks
• Familiarity with Git-based CI/CD (GitHub Actions, GitLab CI) and sqlfluff or similar
• Appetite to adopt AI coding workflows and ways of working.
• Strong problem-solving skills and ability to troubleshoot complex technical issues.
• Collaborative attitude, open to feedback, and committed to raising the bar for the entire Platform Team.

What we offer

• Competitive Salary – We offer a competitive compensation package.

• Career Growth – Work in a high-growth environment with opportunities for professional development.

• Awesome Culture – Join a diverse, inclusive, and innovative team that values collaboration.

• High Impact Role – Play a key role in shaping the data strategy and stack of a growing SaaS platform.

• Exciting Travel-Tech Projects – Help revolutionize airline subscriptions and travel commerce.

• Coverflex Card – Use it for restaurants, transportation, childcare, and even health insurance—tax-free!

• Tech Tools Budget – Receive €150 after passing the probation period to spend on tech tools of your choice.

About us

At Caravelo, your work will be seen, valued, and celebrated. You'll shape technology that redefines travel, while growing your career in a company that puts people first and inside and out.

We are also proud to be an inclusive, equal opportunity employer.

Are you ready to help us build the future of travel? Let’s talk.