Senior Analytics Engineer
Caravelo
- Barcelona
- Permanente
- Tiempo completo
- 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: Define job graphs, retries, backfill strategies, and feature-flag controls to meet nightly data-freshness SLAs.
- Governance & Security: Implement PII-safe modeling patterns, maintain data lineage 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.
- 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.