About the company
Flipside Crypto enables on-demand analytics for blockchains, driving ecosystem growth and retention. Through a free, open data platform, it enables 60,000 analysts to learn, collaborate and compete to solve analytical challenges via structured bounty programs. Flipside activates on projects with kinetic energy including Flow, Solana, Algorand, THORChain, SushiSwap, and Osmosis. Founded in 2017, Flipside Crypto recently raised $50M in a Series A financing led by Republic Capital with other investors including True Ventures, Galaxy Digital, M13, Dapper Labs, Collab Currency, Tribe Capital, HashKey and others. Flipside is remote-first (originally headquartered in Boston, MA) with a growing team of 75+ employees.
Job Summary
Responsibilities:
šWrite SQL or other querying code to extract and manipulate data from database systems to create reports and data visualizations using proprietary Flipside applications šPartner with Product and Data Science to design and define analytics product specifications šEnsure accuracy of data results and analytic methods through testing and validation of underlying report data and coordinate closely with šData Product on issue resolution šLearn about the top Blockchains and Protocols in order to model a data framework needed to do proper analysis of their use cases. šBecome an expert on customer blockchain projects and serve as the main point of contact for data questions as well as mentor other analysts šHelp build data models that are in line with analytics product specifications in Python and in SQL šWork with Blockchain Communities on Discord in order to gather insights as well as give support šAccepting and giving out constructive feedback and willingness to switch priorities based on the teamās needs
You are a fit if:
šYou possess a strong analytical background that includes 3+ of experience working with complex data sets šYou are have experience working with and are a subject matter expert with Blockchain Data (experience with Cosmos/IBC data a plus) šYou are comfortable creating your own intermediary tables and thrive in ambiguity šYou have a 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, Hive, Postgres, SQL Server) šAre familiar using ETL pipelining tools like DBT šYou have an analytical mindset