Human Resources division · 20 countries
Worldwide Absenteeism — WTM (Workforce Time Management)
Design and technical leadership of a worldwide HR analytics platform covering absenteeism across several Renault Group countries.
Owner of the end-to-end value chain: HR data ingestion and transformation, BigQuery modelling, governance, row- and column-level security (RLS/CLS), KPI computation, Looker semantic layers, self-service dashboards and access management.
- 20 countries
- Per-employee access
- 1 of 5 Looker solutions delivered
Every employee sees only the data they are authorised to see: security lives in the model, not in the dashboards — so the solution stays robust as each new country or user is added.
Architecture — from source to self-service
Sources
Country HRIS (HR information systems)
Multi-country extracts, heterogeneous formats and reference data
Ingestion
Cloud Storage · Dataflow · Composer
Orchestrated pipelines, quality checks, replays and traceability
Modelling
BigQuery — Raw › Refined › Data Product
Partitioning, clustering, RLS/CLS security, absenteeism KPI computation
Semantic
Looker / LookML
KPI source of truth, business dimensions, role-based access
Usage
HR Self-Service Analytics
Country dashboards and autonomous exploration by the HR teams
Governance
Row- and column-level security, role-based access, KPIs defined once and reused everywhere.
Cross-domain sharing
Data models designed for governed sharing across several business domains, without duplication.
Business autonomy
HR teams explore their own indicators without going through the Data team: fewer ad hoc requests, faster decisions.
