Flipside is a commercialization engine that powers blockchain growth. We activate 100,000+ analysts to produce insights, drive narratives, and transact, building emotional connection and a strong and active community that supports token price and chain growth. We make that possible by curating best-in-class data and making that data available entirely for free. Founded in 2017, Flipside works with partners such as Solana, Near, Flow, Avalanche, SEI, Aptos, Blast, Vertex. The company is backed by leading investors including Republic Capital, True Ventures, Galaxy Digital, M13, and more.
Description
As a Senior Data Engineer at Flipside, you will serve in a highly cross functional role and be responsible for creating innovative data platform features that power Flipside’s analytics offerings. You will be part of a high performing team working on a novel data platform using DBT, python, and AWS. This role is critical to the success of Flipside.
Responsibilities
- Write SQL to query Snowflake to assess operational performance and data quality issues. Familiarity with dbt is a plus.
- Partner with Analytics to build data pipelines for data ingestion following ELT best practices.
- Build python data pipelines using AWS lambda and chalice to ingest blockchain data from various APIs. CDK knowledge is a plus.
- Build CI/CD pipelines using Github Actions.
- Monitor and maintain existing data pipelines.
- Build data apis, using python, to integrate into our data platform.
- Use orchestration tools such as HEVO and FiveTran.
- Optimizing poor performing Snowflake queries.
Requirements
- You possess a strong analytical background that includes experience working with complex data sets.
- You have experience working with and are a subject matter expert with Blockchain Data.
- You are comfortable working independently with little supervision and thrive in ambiguity.
- You have a strong background in data modeling and are familiar with star schema and dimensional modeling.
- You are self directed and capable of driving projects forward to meet deadlines.
- You have great communication skills (verbal and written) and are able to present your ideas to a wide audience.
- You have a strong background in writing SQL (Snowflake, Athena, Big Query, or Postgres).