Experteer Overview In this StaffAI Analytics Engineer role, you will help shape Factorial’s analytics platform with a strong emphasis on advanced analytical architectures, semantic modeling, and AI/LLM-powered data workflows. You’ll work within the DX and Performance team to improve real-time analytics, data access, and scalable pipelines that empower product and business teams. This position offers the chance to influence architectural decisions and drive AI-enabled analytics across the company. You’ll join a mission to deliver robust, high-quality insights at scale.Compensaciones / Incentivos
- Lead evolution of Factorial's analytics platform and how data becomes actionable for millions of users
- Design high-performance pipelines using ClickHouse and Kafka-based streaming
- Define and architect semantic models/cubes (measures, dimensions, joins, pre-aggregations)
- Integrate LLMs into analytics workflows (text-to-SQL, natural-language querying, conversational BI) with governance
- Apply prompt engineering, tool calling, and embedding-based retrieval (RAG)
- Build shared capabilities to enable other teams to develop intelligent analytic experiences




- Lead architectural decisions around modeling, performance, governance, observability, and scalability
- Collaborate with Product, Engineering, Analytics, and Data Science to translate business questions into scalable solutionsResponsabilidades
- Strong SQL skills with hands-on ClickHouse experience (queries, materialized views, MergeTree)
- Solid OLAP fundamentals (dimensional modeling, aggregations, star/snowflake schemas)
- Experience defining/building semantic layers/cubes (e.G. Cube.Js)
- Experience integrating LLMs into structured analytics (RAG, text-to-SQL, tool calling)
- Proficiency in TypeScript for tooling, APIs, and data integrations
- Willingness to work with Ruby on Rails backends (optional)
- Familiarity with cloud environments (AWS/GCP), Docker, Kubernetes
- Experience with BI and data transformation tools (Cube.Js, dbt, LookML, Superset)Requisitos principales
- Alan private health insurance
- Wellhub (fitness benefits)
- Cobee expense management
- Language classes
- Breakfast in the office and organic fruit
- Pet Friendly

📌 Staff Ai Analytics Engineer (Barcelona)
🏢 Factorial Hr
📍 Barcelona