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.Wellhub (fitness benefits)Cobee expense managementLanguage classesBreakfast in the office and organic fruitPet FriendlyLead evolution of Factorial's analytics platform and how data becomes actionable for millions of usersDesign high-performance pipelines using ClickHouse and Kafka-based streamingDefine and architect semantic models/cubes (measures, dimensions, joins, pre-aggregations)Integrate LLMs into analytics workflows (text-to-SQL, natural-language querying, conversational BI) with governanceApply prompt engineering, tool calling,



and embedding-based retrieval (RAG)Build shared capabilities to enable other teams to develop intelligent analytic experiencesLead architectural decisions around modeling, performance, governance, observability, and scalabilityCollaborate with Product, Engineering, Analytics, and Data Science to translate business questions into scalable solutionsStrong SQL skills with hands-on ClickHouse experience (queries, materialized views, MergeTree)Solid OLAP fundamentals (dimensional modeling, aggregations, star/snowflake schemas)Experience integrating LLMs into structured analytics (RAG, text-to-SQL, tool calling)Proficiency in TypeScript for tooling, APIs, and data integrationsWillingness to work with Ruby on Rails backends (optional)Familiarity with cloud environments (AWS/GCP), Docker, KubernetesExperience with BI and data transformation tools (Cube.js, dbt, LookML, Superset)Curiosity and proactive problem-solvingEffective communication across cross-functional teamsStrong collaboration with Product, Engineering, Analytics, and Data ScienceClickHouse (OLAP store)TypeScriptStaff AI Analytics Engineer - Factorial HR barcelona, catalunya, es
#J-18808-Ljbffr

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