Data Lead fo SocialFi
Budget: $50 – $0 USD
Solus Keycard Pro generates wallet mnemonics with TRNG on an STM32H573 and supports QR‑based flows for onboarding and signing. We need analytics to understand device health, onboarding success, fraud indicators, and usage patterns — without collecting any PII or secrets (mnemonics/private keys). You will design the data model, implement a processing pipeline prototype, and produce dashboards and a short report with recommendations.
Deliverables (what to submit)
Data model & schema (JSON/DDL) for telemetry events and aggregated tables.
A short ETL prototype (Python + notebook or scripts) that:
Ingests a provided sample event stream (CSV/NDJSON, anonymized—see sample below).
Performs validation, enrichment, and aggregation.
Produces daily cohorts, onboarding funnel, Keycard health metrics, anomaly detection flags.
Two lightweight dashboards (static HTML or screenshots) showing:
Onboarding funnel (impressions → QR scans → mnemonic generation → successful wallet activation).
Device health & risk indicators (TRNG entropy health, failed QR sign rate, firmware version distribution, geographic regions by anonymized shard).
A 1–2 page findings & recommendations report (PDF/MD) describing insights, privacy safeguards used, and actions to improve retention/fraud mitigation.
Deliverables (what to submit)
Data model & schema (JSON/DDL) for telemetry events and aggregated tables.
A short ETL prototype (Python + notebook or scripts) that:
Ingests a provided sample event stream (CSV/NDJSON, anonymized—see sample below).
Performs validation, enrichment, and aggregation.
Produces daily cohorts, onboarding funnel, Keycard health metrics, anomaly detection flags.
Two lightweight dashboards (static HTML or screenshots) showing:
Onboarding funnel (impressions → QR scans → mnemonic generation → successful wallet activation).
Device health & risk indicators (TRNG entropy health, failed QR sign rate, firmware version distribution, geographic regions by anonymized shard).
A 1–2 page findings & recommendations report (PDF/MD) describing insights, privacy safeguards used, and actions to improve retention/fraud mitigation.