Data & BI Engineer - Odos

Summary

Merciv is the company behind Odos, an advanced Smart Order Routing protocol in DeFi. The Data & BI Engineer will design and maintain data pipelines and business intelligence metrics, enabling teams to make data-driven decisions and optimize operations.

Responsibilities

• Maintain and scale the Odos transaction and event database (Redis, PostgreSQL, or equivalent)
• Build ETL pipelines from on-chain data sources, APIs, and internal services
• Ensure data integrity, consistency, and query performance across chains and order types
• Define and track key metrics (e.g., total volume, route count, fee revenue, average slippage, gas savings, wallet activity)
• Develop and maintain Tableau dashboards and automated reporting for the leadership team
• Collaborate with product and growth teams to design campaign and feature-specific analytics (Protected Swaps, Multi-Token Swaps, etc.)
• Integrate and analyze loyalty program data — wallet tiers, reward distribution, retention, and ROI
• Work with marketing and growth teams to attribute traffic and measure referral or loyalty campaigns
• Partner with backend engineers on event schemas and pipeline performance
• Support finance and ops with data exports for audits, investors, and DAO reporting

Skills

• 3+ years experience in data engineering or BI development (preferably in fintech, crypto, or trading)
• Strong SQL proficiency and familiarity with Redis, PostgreSQL, and time-series data
• Experience with Tableau (or equivalent BI tool) — data modeling, calculated fields, dashboard automation
• Proficiency in Python or similar scripting language for ETL and data analysis
• Familiarity with on-chain data, DEX trade logs, or blockchain analytics tools (e.g., Dune, Flipside, The Graph)
• Understanding of DeFi protocols, swaps, liquidity pools, and wallet behavior
• Strong communication skills, ability to turn raw data into clear business insights
• Experience integrating blockchain indexers or running custom subgraphs
• Familiarity with The Graph protocol and decentralized data indexing
• Experience designing metrics for revenue forecasting and incentive programs

Qualifications

Must Haves

• 3+ years experience in data engineering or BI development (preferably in fintech, crypto, or trading)
• Strong SQL proficiency and familiarity with Redis, PostgreSQL, and time-series data
• Experience with Tableau (or equivalent BI tool) — data modeling, calculated fields, dashboard automation
• Proficiency in Python or similar scripting language for ETL and data analysis
• Familiarity with on-chain data, DEX trade logs, or blockchain analytics tools (e.g., Dune, Flipside, The Graph)
• Understanding of DeFi protocols, swaps, liquidity pools, and wallet behavior
• Strong communication skills, ability to turn raw data into clear business insights

Nice to Haves

• Experience integrating blockchain indexers or running custom subgraphs
• Familiarity with The Graph protocol and decentralized data indexing
• Experience designing metrics for revenue forecasting and incentive programs