Staff Ai Analytics Engineer - Factorial Hr

Factorial Hr; Barcelona; Presencial; EUR 70.000 - 110.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Wellhub (fitness benefits)

Cobee expense management

Language classes

Breakfast in the office and organic

Pet Friendly

Descripción de la vacante

Factorial HR in Barcelona is seeking a Staff AI Analytics Engineer to shape our analytics platform with a focus on advanced architectures, semantic modeling, and AI-powered data workflows.

You will design high-performance data pipelines, lead architectural decisions, and collaborate with Product, Engineering, Analytics, and Data Science to translate business questions into scalable solutions for millions of users.

Formación

• Strong SQL skills with ClickHouse experience and OLAP fundamentals.
• Experience with semantic modeling, cubing, and pre-aggregations.
• Proven ability to integrate LLMs into analytics workflows with governance.
• Experience designing scalable data pipelines and streaming with Kafka.
• Proficiency in TypeScript and data integration tooling.
• Experience with cloud platforms (AWS or GCP) and container tech (Docker/Kubernetes).

Responsabilidades

• Lead architectural decisions around modeling, performance, governance, observability, and scalability.
• Collaborate with Product, Engineering, Analytics, and Data Science to translate business questions into scalable solutions.
• 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.
• 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.

Conocimientos

Advanced SQL

Semantic modeling

LLM integration

Data pipelines

Observability

Cross-functional collab

Communication

Herramientas

ClickHouse

Kafka

Cube.js

dbt

LookML

Superset

TypeScript

Ruby on Rails

Docker

Kubernetes

AWS

GCP

Descripción del empleo

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 management
• Language classes
• Breakfast in the office and organic fruit
• Pet Friendly
• 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 solutions
• Strong 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 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)
• Curiosity and proactive problem-solving
• Effective communication across cross-functional teams
• Strong collaboration with Product, Engineering, Analytics, and Data Science
• ClickHouse (OLAP store)
• TypeScript

Staff AI Analytics Engineer - Factorial HR barcelona, catalunya, es