Coinbase · coinbase.com · checked today
Staff Analytics Engineer
Skills, with evidence
- Airflow / orchestration
Built and owned production ETL/ELT pipelines with dbt, Airflow or similar, including testing, monitoring and SLAs.
must have - Data modelling
Deep data modeling: designed modular, reusable source-of-truth models (star/snowflake schemas, SCDs) used by many teams.
must have - Python
Expert SQL (window functions, complex aggregations, optimization) and strong Python (OOP, reusable frameworks). No production ETL or SQL experience = reject.
must have - SQL
Expert SQL (window functions, complex aggregations, optimization) and strong Python (OOP, reusable frameworks). No production ETL or SQL experience = reject.
must have - Warehousing
Modern data warehouse/lakehouse experience (Snowflake, Databricks, BigQuery, Redshift). Snowflake is not required; no comparable warehouse experience = reject.
must have - dbt
Built and owned production ETL/ELT pipelines with dbt, Airflow or similar, including testing, monitoring and SLAs.
must have - Data quality
We sit at the intersection of data engineering, data science and business analytics: we own the source-of-truth financial datasets in Snowflake/Databricks, the pipelines that produce them, and the reconciliation, month-end close, safeguarding and reporting workflows built on top.
- Failure handling
Define reusable data quality and reconciliation frameworks (tests, monitoring, alerting, SLAs) and agree with Accounting on what "done" means for financial correctness.
- Idempotency & backfills
Build and own scalable batch (and where needed, near-real-time) pipelines orchestrated with Airflow/dbt, including dependency management, backfills and runbooks.
- Schema evolution & contracts
Drive data contracts with upstream engineering teams, mentor Analytics Engineers, and build abstractions (Python packages, UDFs, LLM-assisted tools) that make finance data users more efficient.
- Spark
Modern data warehouse/lakehouse experience (Snowflake, Databricks, BigQuery, Redshift).
- GCP
Modern data warehouse/lakehouse experience (Snowflake, Databricks, BigQuery, Redshift).
not practised here - Governance & security
Make financial data and pipelines audit-ready: SOX-compliant controls, lineage, change management and evidence for internal and external auditors.
not practised here
Your plan
- SQL
drills at the Staff level
- Python
drills at the Staff level
- Modelling
drills at the Staff level
- Pipelines
drills at the Staff level
- Spark
drills at the Staff level
The full plan, drill by drill, is on the job page.
leaves in 6 dremoved the moment Coinbase closes it
