Analytics Engineer

Experteer Overview In this Analytics Engineer role, you will shape how ALOHAS measures performance, from defining metrics to delivering trusted dashboards and AI-ready data.You'll work at the center of our data stack with BigQuery, dbt, and Lightdash, partnering with a Data Engineer and cross-functional teams.You own end-to-end questions, ensuring metrics are well-defined, documented, and accessible.This is a hands-on, builder role at a growing fashion-focused company committed to sustainable practices.Compensaciones / Beneficios- Build trusted data models in dbt (facts, dimensions, curated marts) used by multiple teams- Translate business questions into clean models across sales, retail, supply chain, marketing, inventory, and customer behavior- Write tests, documentation, and exposures to ensure data trust- Adhere to dbt conventions to maintain scalable, consistent data architecture- Own canonical metric definitions across the business and maintain semantic layer in Lightdash- Collaborate with stakeholders to align metrics with actual operations- Design and own Lightdash explorations and dashboards for self-serve governance- Ensure metrics/models are canonical sources of truth for downstream AI agents and dashboards- Contribute to the team by sharing knowledge, reviewing work, and helping othersResponsabilidades- Hands-on SQL + dbt experience with modular models, tests, docs, and macros- Strong understanding of business/financial metrics across commercial, unit economics, marketing, retention, and operations- Experience with a modern data warehouse (BigQuery preferred; Snowflake/Redshift/Databricks acceptable) and cost/performance-aware querying- Data quality discipline including freshness, tests beyond not_null, anomaly detection, and documentation- Experience with AI-ready workflows and Claude/OpenAI/Cursor-like tools for SQL, debugging, and documentation- PR-based workflow familiarity (Git, code reviews, dbt CI) and collaboration with a Data Engineer- Experience with BI/semantic tools (Lightdash, Looker, dbt Semantic Layer, Cube) is a plus- Familiarity with e-commerce/ERP sources (Shopify, Odoo) is a plus- Experience modeling DTC data complexity (multi-currency, multi-warehouse, returns, multi-channel) is a plus- Python for scripting or analyses is a plus- Background in fast-paced DTC/e-commerce/fashion is a plus- Degree in quantitative/technical field or equivalent practical experience- Fluent in Spanish and English- Three years with strong ownership (not strictly counted)Requisitos principales- Culture of Freedom, Responsibility & Trust- Flexible Working Hours- Hybrid Work Model- Summer Hours- Mental Health Support- Team wellbeing initiatives and disconnect days

Experience with AI-ready workflows and Claude/OpenAI/Cursor-like tools for SQL, debugging, and documentation

• PR-based workflow familiarity (Git, code reviews, dbt CI) and collaboration with a Data Engineer
• Experience with BI/semantic tools (Lightdash, Looker, dbt Semantic Layer, Cube) is a plus
• Familiarity with e-commerce/ERP sources (Shopify, Odoo) is a plus
• Experience modeling DTC data complexity (multi-currency, multi-warehouse, returns, multi-channel) is a plus
• Python for scripting or analyses is a plus
• Background in fast-paced DTC/e-commerce/fashion is a plus
• Degree in quantitative/technical field or equivalent practical experience
• Fluent in Spanish and English
• Three years with strong ownership (not strictly counted)Requisitos principales
• Culture of Freedom, Responsibility & Trust