Delivery Hero · api.smartrecruiters.com · checked today
Sr Analytics Engineer
PedidosYa forma parte de Delivery Hero, empresa líder mundial en servicios de delivery con presencia en ~65 países. PedidosYa es la empresa de tecnología líder en delivery y quick-commerce en Latinoamérica. Es una plataforma simple, rápida y accesible que conecta a millones de personas usuarias, empresas y repartidores con una amplia variedad de productos y servicios.
Skills, with evidence
- Airflow / orchestration
Experiencia en el manejo de grandes volúmenes de datos y en la orquestación de procesos (ej: Airflow).
must have - Data modelling
Capacidad para traducir las necesidades del negocio en modelos de datos y resolver problemas de forma autónoma.
must have - SQL
Dominio avanzado de SQL y conocimientos sólidos de modelado y almacenamiento de datos.
must have - GCP
GCP o servicios de datos en la nube.
must have · not practised here - Dashboards & BI
Herramientas de visualización (Looker, Tableau)
not practised here
Your plan
- The SQL screen: correct, then fast≈ 2 h
SQL
- Median delivery time per cityIntermediate
- Bucket deliveries into quartilesIntermediate
- Median order value without a median functionIntermediate
- New and repeat orders by monthIntermediate
- Every order against its customer's averageIntermediate
- Data modelling: the round most people fail≈ 3 h
Data modelling
- Addresses that stay true to the pastIntermediate
- Seat holds and the release-night raceIntermediate
- Subscription warehouse grainIntermediate
- Campaign efficiencyIntermediate
- Catalogue: products, variants and sellersIntermediate
- Pipeline design: safe to run twice≈ 4 h
Airflow / orchestration
- Is this change safe?Intermediate
- Marketplace transactions at scaleIntermediate
- The source will not let youIntermediate
- Changing a pipeline that’s already runningIntermediate
- SLA-aware alerting flowIntermediate
- Say it out loud≈ 1 h
15 drills · Intermediate + Advanced≈ 9 hours
Not covered by the plan: GCP, Dashboards & BI.
Readiness
Counted from drills you have completed anywhere on D8LooP.
leaves tomorrowremoved the moment Delivery Hero closes it