Role overview
Our crypto wallet is used by millions of people to access apps and financial services built on the Solana blockchain. The Data Engineering team collaborates with an experienced group of engineers, analysts, and product managers to build highly available and scalable data infrastructure for Phantom’s products and services. As one of the founding Data Engineers, you will be responsible for developing, managing, and scaling Phantom’s robust database infrastructure that will ultimately help to onboard millions of people to access web3 apps and financial services. This is a unique opportunity where you'll influence strategic product and infrastructure decisions as we bridge the gap between the blockchain and the delightful experience our users have come to expect. Join us on our mission to make the digital economy safe and easy to use for everyone.
This role is fully remote; however, we’re only open to candidates based in US and EU time zones. Currently, Phantom cannot support employees from the following countries and continents: Russia, Pakistan, Ukraine, Asia, Oceania, and Africa.
What you'll work on
- Design, implement, and maintain Petabyte scale relational database systems with a focus on availability, security, performance, and scalability.
- Experience writing, debugging, and tuning SQL
- Serve as an expert in database performance, scalability, query tuning, monitoring, and incident response.
- Build highly reliable data services to integrate with dozens of blockchains.
- Design data models for optimal storage and retrieval to support sub-second latency for querying blockchain data.
- Deploy and monitor large database clusters that are performant and highly available.
- Work cross-functionally with data scientists, backend engineers and product managers to to plan and execute database infrastructure build-outs to support Phantom’s products.
What we're looking for
- 5+ years of hands-on experience in database design, development, and operations with one or more of the following technologies: PostgreSQL, TimescaleDB, Rockset, Apache Druid, Apache Pinot, StarRocks, ElasticSearch, Redis
- Experience managing a highly reliable database platform with a focus on security, performance, and scale to meet the requirements of millions of users.
- Proficient in data modeling for OLTP and OLAP workloads.
- 5+ years of experience building distributed system architecture, from whiteboard to production.
- Experience influencing product roadmap and strategy, and prioritizing existing database initiatives to drive business outcomes.
- Strong programming skills in Python and SQL.
- Versatility. Experience across the entire spectrum of data engineering, including:
- Data stores (see above)
- Data pipeline and workflow orchestration tools (e.g., Airflow, Dataflow, DBT)
- Data processing technologies and streaming workflows (e.g., Spark, Kafka, Flink, Pub/Sub)
- Deployment and monitoring infrastructure in public cloud platforms (e.g., Docker, Terraform, Kubernetes, Datadog)
- Loading, querying and transforming large data sets