Data & BI Engineer - Odos
DE'CIRCLE LLC
San Francisco, United States of America
yesterday
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
IntermediateJob location
San Francisco, United States of America
Tech stack
Query Performance
API
Data analysis
Business Intelligence
Databases
Information Engineering
Data Infrastructure
Data Integrity
ETL
Python
PostgreSQL
Raw Data
Redis
Blockchain
Tableau
Transaction Data
Scripting (Bash/Python/Go/Ruby)
Data Analytics
Job description
We are seeking a Data & BI Engineer responsible for the design, reliability, and scalability of Odos's transaction data pipelines, Business Intelligence metrics, and Tableau dashboards. This role will bridge on-chain trade data with user and loyalty program analytics, enabling the product, growth, and finance teams to make data-driven decisions.
You will own the transaction database layer and help build a unified analytics view of Odos operations - from trade volume and fee revenue to wallet activity, rewards, and partner performance., * Data Infrastructure
- 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.
- Business Intelligence & Reporting
- Define and track key metrics (eg, 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.).
- Loyalty & User Analytics
- 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.
- Cross-Functional Collaboration
- Partner with Back End 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 (eg, 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 Have
- 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.