Sql jobs in crypto and blockchain companies

Who we are Game7 is an Autonomous GameFi Institution whose treasury is managed and deployed by the community. Our mission is to make web3 gaming sustainable by accelerating the industry towards collaboration, unified standards, open source innovation and having fun.To achieve this, both BitDAO and Forte have committed $500m to our treasury. Our community then helps decide how to deploy strategic capital towards both Investments and Grants that help drive the ecosystem forward.As a community, we are passionate about crypto, gaming and are comprised of industry leaders and blockchain experts, who believe there are better ways to build distributed organizations. Our community consists of diverse, talented and intelligent members who’s contributions to the ecosystem help define their governance capabilities.We’re looking for the next generation of leaders and doers who have a passion for crypto and are looking to influence the future of DAOs, DeFi, Web3 and GameFi. If you’re a self-starter, believe in autonomy and ownership, then we encourage you to apply for this role.What You'll Help Us BuildWe are seeking a talented Data Analyst to drive data-driven decision-making and provide valuable insights into our Web3 Gaming initiatives. As the first dedicated Data Analyst to join our organization, you will play a crucial role in setting up analytics tooling for our marketing, product, and business development teams and then analyzing large datasets to provide key insights to stakeholders. Key ResponsibilitiesPerform comprehensive analysis of data to derive actionable insights and identify trends within our ecosystem.Develop and maintain data pipelines to ensure efficient data extraction, transformation, and loading (ETL) processes from diverse sources.Collaborate closely with cross-functional teams including developers, product managers, and marketing to support data-driven decision-making.Create and automate reports, dashboards, and visualizations to communicate findings and performance metrics effectively.Stay updated with industry trends, regulations, and emerging technologies in the Web3 and crypto space to provide strategic recommendations.Your craftBachelor's degree in field related to data science, marketing or analytics preferred; Master's degree in Data Science or Data Analytics a bonus.Proven experience as a Data Analyst or similar role, with specific exposure to rapidly growing gaming or B2C companies; Experience with blockchain, cryptocurrencies, or decentralized technologies preferred.Strong proficiency in SQL, Python/R, and data visualization tools (e.g., Tableau, Power BI) to manipulate and analyze complex datasets.Familiarity with blockchain protocols (Ethereum) and understanding of smart contracts is highly advantageous.Past experience setting up analytics tools like Google Analytics, HootSuite, SproutSocial, and/or other marketing analytics tooling.Excellent analytical and problem-solving skills with a keen attention to detail.AdOps experience with an understanding of concepts around attribution, fraud analysis, and user retention.Ability to thrive in a fast-paced, entrepreneurial environment and manage multiple priorities effectively.Strong communication skills with the ability to translate complex data insights into actionable recommendations.If you think you have valuable experience to bring to the organization, but don’t necessarily meet all of the criteria for the role, we still want to hear from you. We consider all applications.About this teamThe Summon Team at Game7 operates at the heart of our organization and is dedicated to bridging the worlds of traditional gaming and the pioneering space of Web3. Reporting directly to and collaborating closely with other teams, this team is pivotal in the creation of worlds that not only attract but also immerse the next 100 million gamers into the Web3 ecosystem. Why work with us?We do things a little differently here at Game7, as you’d expect from the blockchain. We promise a culture of flexibility, autonomy, and the freedom to contribute to the wider Web3 ecosystem.Also: a fully remote working environment. Our compensation packages are reflective of the experience and value you bring to the organization and individual projects.Base pay USDC, paid monthlyWork Supplies, HW & Home Office EquipmentCo-working space or home office-related expensesAny learning or education materials related to workTravel related expenses that are related to workAny expenses related to food and entertainment for workAny expenses related to both physical or mental health and well-beingWe’re committed to fostering a progressive work environment that’s centered on forgiveness, empathy, belonging, and psychological well-being. Game7 is an equal opportunities workplace that doesn’t discriminate based on race, ethnicity, gender, ancestry, national origin, religion, sex, sexual orientation, gender identity, age disability, veteran status, genetic information, marital status, or any other legally protected status.

TRM is on a mission to build a safer financial system for billions of people. We deliver a blockchain intelligence data platform to financial institutions, crypto companies, and governments to fight cryptocurrency fraud and financial crime. We consider our business — and our profit — as a way to move towards our mission sustainably and at scale.  As a Data Scientist, you will drive key components of TRM's blockchain attribution efforts and develop solutions that allow TRM to scale rapidly and effectively. You will collaborate with an experienced team of blockchain experts, data scientists, and engineers to ensure TRM provides best in class attribution and intelligence while delivering cutting-edge support to TRM's clients. The impact you will have here: Participate in the review and validation of existing + new attribution to increase throughput and quality of raw attribution data. Develop and executing strategies for maintaining state-of-the-art Intelligence Accuracy. Develop custom code and interactive visualizations that will be consumed to monitor quality Respond to ad-hoc client research requests. Collaborate with data and blockchain intelligence teams to enhance the TRM product. What we’re looking for: Your academic background is in a quantitative field such as Computer Science, Statistics, Engineering, Economics or Physics. Advanced degree preferred. You have 4+ years of experience working in an analytical role. You have proven experience with at least one programming language (Python preferred) and are comfortable developing code in a team environment (e.g. git, notebooks, testing). You have a working knowledge of relational databases, (e.g. SQL) You think about data in terms of statistical distributions and have a big enough analytics toolbox to know how to find patterns in data and identify targets for performance Practical experience with virtual currencies and blockchain is a plus; excitement to learn about these topics is essential. Critical thinking. You are a problem solver who appreciates hard work and enjoys operating in an autonomous environment. Exceptional and consistent attention to detail, integrity and work ethic. Adaptable. Goals can change fast. You anticipate and react quickly. You own what you work on. You move fast and get things done.   Life at TRM Labs Leadership Principles Our Leadership Principles are foundational element of our strategy, guiding how we make decisions, how we treat each other, and how we behave day-to-day. Impact-Oriented Trailblazer: We put customers first, driving for speed, focus, and adaptability. Master Craftsperson: We prioritize speed, high standards, and distributed ownership. Inspiring Colleague: We value humility, candor, and a one-team mindset. Build a Career  Joining TRM means being part of a mission-driven team comprised of industry leaders. At TRM, you'll experience: Purpose and Mission: Have a real-world impact, from disrupting terrorist networks to returning stolen funds. Inspiring Colleagues: Collaborate with industry leaders and learn something new daily. Personal Growth: We're not just using technology; we're inventing it and taking category-defining products to market. Work Environment Remote First: Our HQ is online. Tools like Zoom and Slack ensure seamless collaboration, but we also value in-person interactions, organizing regular meetups and offsites for team bonding. Clear communication is key in our decentralized setup. With tools like Slack, Loom, and voice notes, we document meetings and decisions, promoting transparency and efficiency. Ownership & TRM Speed: Small teams drive big goals at TRM. Every team member has significant ownership and responsibility, fostering an environment of initiative and direct impact. While there's no strict clocking in or out, we expect team members to balance personal schedules and team needs. We move “surprisingly fast” while maintaining a high bar in service of our customers and mission. This can feel both intense and rewarding. Our unique approach to projects emphasizes quick wins, rapid iterations, and constant feedback. Diversity and Inclusion: Diversity at TRM encompasses backgrounds, experiences, and perspectives. Every day is an opportunity to learn from a colleague, whether they're a law enforcement expert or a tech pioneer. Annual Company Offsite: Once a year, TRMers come together from around the world to attend a 1-week mandatory company offsite. This is designed to foster in-person relationships, creativity, and strategic alignment. Employee attendance is required of all TRMers.   Benefits and Perks At TRM, we know that supporting our team members can take many forms. Our goal is to enable you to care for yourself, your family, and your community while eliminating stress through our diverse and curated benefits package for full-time employees. Remote-first work environment Competitive salaries and stock options Health insurance Life & disability coverage Generous paid time for vacation, holidays, and parental leave Join Us We're looking for team members who love building from the ground up and want to work hard in a fast-paced and ambitious environment. We are remote-first, with exceptionally talented team members located around the world. If you like solving tough problems quickly and seeing your work improve the lives of billions of people, we want you at TRM. We encourage you to reach out even if your experience doesn't precisely match the job description. Don't worry about picking exactly the right job; we can always explore other options after starting the conversation. Your passion and interests will set you apart, especially if your background or career is unconventional.   To all recruitment agencies: TRM Labs does not accept unsolicited agency resumes. Please do not forward resumes to TRM Labs employees. TRM Labs is not responsible for any fees related to unsolicited resumes and will not pay fees to any third-party agency or company that does not have a signed agreement with the Company.