#### **About Caravelo** Caravelo is seeking a **Data Modeler** 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.**