Coinbase · coinbase.com · checked today
Senior Software Engineer - Data Platform
Ready to do the most impactful work of your career? At Coinbase , we are uncompromising on our mission to increase economic freedom. The bar is high, the environment is intense, and we like it that way.
Skills, with evidence
- Airflow / orchestration
orchestration (Airflow), batch processing (Spark, SQL), and streaming (Kafka).
must have - Python
Strong Python, Go, or Java backend development skills.
must have - SQL
Working knowledge of SQL and Airflow for operational data analysis.
must have - Spark
batch processing (Spark, SQL)
must have - Cost & performance
Utilizes generative AI responsibly, maintaining human oversight to deliver business-ready outputs and drive measurable improvements in workflow efficiency, cost, and quality.
- Data quality
Build services for data security, observability, quality, cataloging, and lineage.
- Streaming
Design, build, and operate foundational data services, including storage (cloud warehouse, data lake), orchestration (Airflow), batch processing (Spark, SQL), and streaming (Kafka).
- Warehousing
Design, build, and operate foundational data services, including storage (cloud warehouse, data lake), orchestration (Airflow), batch processing (Spark, SQL), and streaming (Kafka).
- Governance & security
Build services for data security, observability, quality, cataloging, and lineage.
not practised here - Java
Strong Python, Go, or Java backend development skills.
not practised here - Machine learning
The Data Platform team builds and operates systems that centralize all of Coinbase's internal and third-party data, so teams across the company can access, process, and transform it for analytics, machine learning, and end-user experiences.
not practised here
Your plan
- The SQL screen: correct, then fast≈ 2 h
SQL · Data quality
- 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
- Python: the data-wrangling round≈ 3 h
Python
- Diff two snapshots of a tableIntermediate
- Explode an array column into rowsIntermediate
- Flatten nested event payloadsIntermediate
- Keep only the latest row for each eventIntermediate
- Pivot a long metrics table to wideIntermediate
- Data modelling: the round most people fail≈ 3 h
Warehousing
- Subscription warehouse grainIntermediate
- Addresses that stay true to the pastIntermediate
- Campaign efficiencyIntermediate
- Chats, members and read receiptsIntermediate
- Churn that survives an argumentIntermediate
- Pipeline design: safe to run twice≈ 4 h
Airflow / orchestration · Streaming
- The source will not let youIntermediate
- Parcel tracking pipelineIntermediate
- Is this change safe?Intermediate
- Marketplace transactions at scaleIntermediate
- Five minutes behind the sourceIntermediate
- Spark: read the plan Spark actually ran≈ 2 h
Spark · Cost & performance
- broadcast() with auto-broadcast off, and the case where Spark ignores itIntermediate
- autoBroadcastJoinThreshold compares an estimate: flip a join with select() and one settingIntermediate
- Does Spark really run your EXISTS subquery once per row?Intermediate
- left_semi and left_anti: "customers who did / never did" without a full joinIntermediate
- A self-join on a real key that still multiplies rowsIntermediate
- Say it out loud≈ 1 h
25 drills · Intermediate + Advanced≈ 14 hours
Not covered by the plan: Governance & security, Java, Machine learning.
Readiness
Counted from drills you have completed anywhere on D8LooP.
leaves in 3 dremoved the moment Coinbase closes it