Data & BI Engineer - Odos

Merciv is a company focused on advanced Smart Order Routing protocols in DeFi, and they are seeking a Data & BI Engineer to enhance their data and analytics capabilities. The role involves designing and maintaining transaction data pipelines, business intelligence metrics, and Tableau dashboards to support product and growth teams in making data-driven decisions.

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

Requirements:

• 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