Requirements

Hands-on experience with dbt (or Dataform) in production environments, including orchestration tools such as Airflow.
Advanced SQL skills with a strong track record of building production-grade transformation layers.
Experience integrating third-party data sources via APIs or batch ingestion pipelines.
Proficiency with modern analytical data platforms such as Databricks, BigQuery, or Snowflake, including data modeling, performance optimization, and cost management.
Experience designing dimensional data models (fact tables, SCDs, data marts) and strong Python skills for pipeline development and automation.
Experience implementing data quality testing, monitoring, and governance practices, with comfort in Git-based workflows and CI/CD.

What You'll Be Doing

Design and maintain the end-to-end data model (raw → staging → intermediate → marts) using dbt, ensuring clear documentation, lineage, and maintainability across all data assets.
Develop reusable data products: datasets, models, and metric layers, that power dashboards, analyses, and automated systems across Bolt.
Design and manage ingestion pipelines for third-party competitive intelligence vendors (APIs, SFTP, batch files), including schema management, validation, and change handling.
Implement data quality checks, monitoring, and alerting to ensure pipelines are reliable, secure, and aligned with Bolt's data platform standards.
Define, standardize, and maintain competition-related KPIs and metric logic to ensure consistent interpretation across analytics and business teams.
Optimize warehouse performance and cost efficiency for competition-related workloads, and enable teams through clear metric definitions and documentation.

Experience is great, but we also look for drive, intelligence, and integrity. So, even if you don’t tick every box, please consider applying if you feel you’re the kind of person described above!

Play a direct role in shaping the future of mobility.
Impact millions of customers and partners in 600+ cities across 50+ countries.
Work in fast-moving autonomous teams with some of the smartest people in the world.
Accelerate your professional growth with unique career opportunities.
Get a rewarding salary and stock option package that lets you focus on doing your best work.
Enjoy the flexibility of working in a hybrid mode with a minimum of 2 days in the office each week to foster strong connections and teamwork.
Take care of your physical and mental health with our wellness perks.