Delivery Hero · api.smartrecruiters.com · checked today
Data Analytics Engineer (They/She/He)
Glovo is part of the Delivery Hero Group, the world’s pioneering local delivery platform, our mission is to deliver an amazing experience—fast, easy, and to your door. We operate in around 65 countries worldwide. Headquartered in Berlin, Germany.
Skills, with evidence
- Python
Working proficiency in Python to support data analysis, automation and workflow improvements.
must have - GCP
Exposure to Google Cloud Platform, infrastructure/cost monitoring or governance.
not practised here - Governance & security
You will join Data Platform Enablement , the central team responsible for maintaining and governing Glovo's data tools, defining data governance standards and automating the processes that keep our data ecosystem trustworthy and efficient.
not practised here - Dashboards & BI
Help maintain and govern Glovo's core data tools, including Looker, defining and enforcing governance standards across the company.
not practised here - Failure handling
Contribute to monitoring GCP infrastructure usage and costs, and help define governance around cloud resources.
- Cost & performance
Strong SQL foundations , with the ability to independently write, debug and optimise analytical queries.
- SQL
Strong SQL foundations , with the ability to independently write, debug and optimise analytical queries.
Your plan
- The SQL screen: correct, then fast≈ 1 h
SQL
- Line items per orderFoundations
- Average order value by countryFoundations
- Count at the right grainFoundations
- Revenue by buyer countryFoundations
- Join three tables into an order detailFoundations
- Python: the data-wrangling round≈ 2 h
Python
- Clean spreadsheet headers into column namesFoundations
- Events normalization jobFoundations
- List the distinct composite keysFoundations
- Deduplicate rows, first one winsFoundations
- Render a byte count for humansFoundations
- Pipeline design: safe to run twice≈ 3 h
Failure handling
- After the first one finishesFoundations
- The history nobody keptFoundations
- The spreadsheet is a dependencyFoundations
- Waiting for the fileFoundations
- Where did the rows go?Foundations
- Spark: read the plan Spark actually ran≈ 2 h
Cost & performance
- HAVING vs WHERE: where does a filter after groupBy actually run?Foundations
- partitionBy("country"): what does partition pruning look like in the plan?Foundations
- Predicate pushdown: equality, ranges, and the filter that cannot be pushedFoundations
- Revenue by country: read the DAG behind one groupByFoundations
- Too many small files: where do they cost you, and how does compaction help?Foundations
- Say it out loud≈ 1 h
20 drills · Foundations + Intermediate≈ 8 hours
Not covered by the plan: GCP, Governance & security, Dashboards & BI.
Readiness
Counted from drills you have completed anywhere on D8LooP.
leaves in 5 dremoved the moment Delivery Hero closes it