BI Analyst

LimeChain is a leading Blockchain & Web3 solutions company, home to 150+ engineers, architects, and researchers building some of the most exciting and complex projects in Web3. We dive deep into blockchain infrastructure, AI, decentralized applications (dApps), tokenization, and advanced Web3 integrations – delivering 250+ next-gen solutions for enterprises, startups, and protocols such as Ethereum Foundation, Solana, Polkadot, Hedera Hashgraph and more. From low-level protocol design and architecture to full-scale product development, we push the boundaries in DeFi, supply chain, oracles, Layer 1 & 2 scaling, and real-world asset (RWA) ecosystems – on a mission to build, explore, and expand the future of the Internet.

What you will be doing:

Dashboard Development & Visualisation

• Develop, update, and maintain interactive dashboards in Looker Studio Pro, connected to BigQuery as the primary data source
• Collaborate with stakeholders to translate business questions into technical reporting requirements
• Ensure dashboards are user-friendly, visually clear, and focused on the metrics that matter most to the team

Data Analysis & Quality Assurance

• Regularly audit reports against source data to ensure accuracy. Investigate and resolve discrepancies before they reach management
• Write intermediate-to-complex SQL queries in BigQuery to explore data, validate logic, and prepare datasets for reporting
• Flag missing data or inconsistent formatting to Data Engineering to improve future reporting

Process Design & Standards

• Define and own the team’s reporting standards — what a good dashboard looks like, how metrics should be documented, and how requests should be handled end-to-end
• Maintain a glossary of metrics to ensure consistent definitions across the business (e.g. „Revenue“, „Churn“)
• Create clear documentation (mock-ups, logic definitions, data dictionaries) to align Data Engineering on what data is needed and why

Collaboration & Enablement

• Conduct training sessions and walkthroughs for business users to ensure effective dashboard adoption
• Work closely with Data Engineering on pipeline requirements, communicating data needs clearly and proactively

AI-Assisted Analytics

• Leverage AI tools to accelerate analysis, generate SQL, surface insights faster, and improve reporting workflows
• Stay current with emerging AI capabilities relevant to BI and analytics

What you bring to the table:

• Strong SQL skills for data extraction and manipulation in BigQuery (joins, aggregations, CTEs, window functions)
• Proven experience building dashboards in Looker Studio Pro (experience with other tools like Power BI or Tableau is a plus)
• Familiarity with n8n or similar ETL/automation tools — enough to understand data pipelines and communicate effectively with the team building them
• Working knowledge of data modeling concepts (star schema, fact/dimension tables) — you don’t need to build the model, but you must know how to query it effectively
• Demonstrated ability to define and communicate what „good“ looks like in reporting — standards, templates, and repeatable processes
• Comfort using AI tools (e.g. Claude, ChatGPT, Gemini) to assist with SQL generation, analysis, and documentation
• Ability to challenge a metric request: „Does this data actually answer the business question?“
• Strong communicator — able to explain technical concepts clearly to non-technical stakeholders
• High attention to accuracy — you double-check your numbers before publishing
• Genuine curiosity about how the business works across Finance, Ops, and Sales

Benefits:

Ready to enter the exciting world of Blockchain and Web3? We know that your best work happens when you feel your best. Here is what we offer to make that happen:

• Reshape industries by working on the most exciting Blockchain & Web3 projects using the latest technologies.
• Own your schedule with flexible hours and work-from-home allowance.
• Stay at your peak with fully covered premium medical and dental care.
• Train anywhere using a Multisport card with minimal employee contribution, or join our internal run and football clubs.
• Recharge fully by unlocking up to 25 days of annual leave as your tenure grows.
• Connect offline at epic team-building events, plus monthly socials and fiery game nights.
• Enjoy the daily perks of office snacks, our signature Wednesday Team Feast, and exclusive branded swag.
• Drive in style with a car allowance unlocked after your second year.