Remote Database Engineer

Summary

Join Supra, a fast-growing, well-funded startup pioneering information services in global markets, as a Database Engineer. You will design, implement, and maintain robust database systems for blockchain data, extract on-chain data from various blockchains, and integrate blockchain data with traditional sources. This role requires expertise in SQL and NoSQL databases, ETL processes, Python programming, cloud deployment, and blockchain technology. You'll work remotely with a globally distributed team, enjoying competitive compensation, flexible working hours, paid time off, and comprehensive health benefits. Your first month will focus on onboarding and familiarization with Supra's operations and culture.

Requirements

• Deep understanding of blockchain ecosystems, including protocols like Ethereum, Solana, or Binance Smart Chain
• Hands-on experience extracting on-chain data using APIs, smart contracts, or tools like Web3.js, ethers.js, or The Graph
• Familiarity with transaction data, block structure, and DeFi protocols
• Degree in Computer Science, Information Technology, Mathematics, Engineering, or demonstrable equivalent self-learning
• Strong foundation in blockchain technology, including decentralised systems and cryptographic principles
• Expertise in SQL databases (e.g., PostgreSQL, MySQL) and NoSQL databases (e.g., MongoDB)
• Experience designing, indexing, and optimising blockchain-specific data models
• Proven ability to design ETL pipelines specifically for blockchain data sources
• Experience using tools like Apache Airflow, custom Python scripts, or other ETL frameworks to manage blockchain data
• Strong skills in cleaning and updating blockchain data for analytical and operational use
• Ability to apply statistical techniques to fill gaps in incomplete or missing blockchain datasets
• Expertise in tuning database queries for efficient handling of large-scale blockchain data
• Familiarity with indexing and partitioning techniques for optimised storage and retrieval of blockchain data
• Advanced skills in Python for blockchain scripting and automation
• Experience working with blockchain SDKs and libraries for data extraction and integration
• Proficiency in deploying and scaling blockchain-focused databases on cloud platforms like AWS, Azure, or Google Cloud
• Experience using cloud-native tools for blockchain data security and performance enhancement
• Experience with Git for version control and debugging complex blockchain-related database systems
• Analytical mindset and problem-solving skills tailored to blockchain systems
• Independence and accountability in managing complex blockchain-related projects
• Strong adaptability and first-principles thinking in new or ambiguous situations

Responsibilities

• Design, implement, and maintain robust database systems to store and manage blockchain data, including on-chain and off-chain data, with a focus on scalability, reliability, and security
• Build and optimise tools and pipelines for extracting on-chain data from blockchains like Ethereum, Binance Smart Chain, Solana, or others. Leverage APIs, smart contract interactions, and technologies such as Web3.js, The Graph, or equivalent frameworks
• Process, clean, and transform blockchain data to ensure integrity and usability. Apply statistical methods to handle incomplete or missing data
• Regularly update and maintain databases to reflect real-time blockchain activity. Implement systems for versioning and ensuring data consistency
• Seamlessly integrate blockchain data with traditional data sources for analytical and operational needs
• Design and manage Extract, Transform, Load (ETL) pipelines tailored for blockchain data sources, ensuring efficient and accurate data ingestion into centralised or decentralised databases
• Monitor and optimise the performance of blockchain data queries and storage, ensuring efficient access and minimal latency
• Deploy and manage blockchain-related databases on cloud platforms such as AWS, Google Cloud, or Azure. Leverage cloud-based tools for scaling and securing blockchain data storage and processing
• Ensure the secure handling of sensitive blockchain data, manage access controls, and adhere to compliance standards for data privacy and security

Preferred Qualifications

• Experience with integrating blockchain data into data warehouses such as Snowflake or BigQuery
• Familiarity with data warehousing and advanced analytics on blockchain data
• Ability to transform blockchain data into insights through platforms like Power BI or Tableau
• Experience creating dashboards for monitoring on-chain activity and metrics

Benefits

• Fully remote environment with adaptable working hours
• Competitive Compensation
• Flexible paid time off, sick leave, and other time-off options, adjusted in line with local regulations
• Paid leave in accordance with local guidelines for national holidays
• Comprehensive health coverage options, including medical, dental, and vision benefits