Data Modeler

Caravelo; Madrid; Presencial; EUR 45.000 - 65.000; Jornada completa

Descripción de la vacante

A travel technology company based in Madrid is seeking a Data Modeler to lead the revamp of their data-modeling layer using a modern ELT stack including dbt and cloud warehousing. This role involves designing scalable data schemas, automating dbt pipelines, and establishing governance practices, ultimately contributing to the next generation of travel experiences.

Servicios

Competitive Salary

Career Growth Opportunities

Diverse and Inclusive Culture

High Impact Role

Coverflex Card

Tech Tools Budget

Formación

• 3+ years in analytics engineering or data modeling roles.
• Hands-on experience with dbt models and tests.
• Familiarity with Git-based CI/CD.

Responsabilidades

• Design and implement star / snowflake schemas.
• Develop dbt projects with staging layers.
• Configure sqlfluff linting in CI pipelines.
• Define job graphs and backfill strategies.
• Implement PII-safe modeling patterns.
• Partner with teams to gather requirements.
• Identify and drive process improvements.

Conocimientos

Analytics engineering

SQL mastery

dbt experience

CI/CD familiarity

Problem-solving

Collaborative attitude

Herramientas

GitHub Actions

GitLab CI

SQLFluff

Descripción del empleo

Join to apply for the Data Modeler role at Caravelo

1 day ago Be among the first 25 applicants

Join to apply for the Data Modeler role at Caravelo

Direct message the job poster from Caravelo

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

1. 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).
2. Build ETL Pipelines: Develop dbt projects with staging layers, incremental models, snapshots, and seed tables.
3. Automate Quality: Configure sqlfluff linting and dbt tests (uniqueness, not_null, custom assertions) in CI pipelines so merges pass automatically.
4. Own Orchestration: Define job graphs, retries, backfill strategies, and feature-flag controls to meet nightly data-freshness SLAs.
5. Governance & Security: Implement PII-safe modeling patterns, maintain documentation, and enforce data-privacy controls.
6. Collaboration & Mentorship: Partner with cross-functional teams to gather requirements, review code, and mentor junior engineers on best practices.
7. 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)
• 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.

Seniority level: Mid-Senior level

Employment type: Full-time

Job function: Information Technology, IT Services and IT Consulting

Note: This job posting appears active; no explicit expiration indicator found.