Principal Data Analyst
Rovo - Do more sport
BigQueryPythonSQLTableau
Product Analytics Lead, Loyalty and Incentives
franki
full-time
Posted on:
Origin: • 🇺🇸 United States • California
Visit company websiteJob Level
Senior
Tech Stack
BigQueryPandasPythonSQL
About the role
- Own the end-to-end measurement engine for Franki’s rewards ecosystem across cashback, Adventures/Gigs, and action-based rewards.
- Build source-of-truth dashboards and metric definitions for TPV, D7/D30 repeat, time-to-2nd purchase, cost % of TPV, LTV and ROI by cohort & merchant.
- Diagnose funnel leaks across onboarding, activation, and reward redemption; quantify impact and recommend fixes.
- Model cost curves for cashback vs. points/miles and recommend cost-efficient mixes to maintain retention.
- Define and maintain metric definitions and data quality SLAs with Data Engineering; oversee instrumentation and data quality.
- Set annual/quarterly reward budgets and guardrails (cost as % of TPV) by segment and merchant tier; publish monthly Rewards P&L with variance analysis.
- Build redemption, breakage, and outstanding liability forecasts; reconcile with Finance (accruals, revenue recognition, P&L impact).
- Design and run A/B tests and holdouts; apply CUPED/uplift models and geo-splits to estimate incrementality; ensure power and clean launches.
- Create an experiment backlog with hypotheses, expected lift, cost, and success criteria; publish decision-ready weekly and monthly readouts.
- Define abuse/fraud heuristics and partner with Trust & Safety on mitigations; monitor partner attribution and CPA integrity for external programs.
- Partner closely with Product, Data Engineering, Finance, BD, and Trust & Safety.
Requirements
- BS/BA in a quantitative field (Statistics, Economics, Computer Science, engineering, Data Science) or equivalent. MS a plus.
- 3+ years in product/growth analytics, incentives/loyalty analytics, travel loyalty or data science, with 1+ years in a lead/ownership role.
- Advanced SQL and Python (pandas, statsmodels/causal inference); cohorting and retention analytics.
- Experimentation design (A/B, CUPED, geo experiments), power analysis, uplift modeling.
- Big Data & BI: Hands-on experience with BigQuery and large-scale datasets; building efficient queries, pipelines, and dashboards in Looker.
- Experimentation Platforms: Familiarity with modern experimentation and feature-flagging platforms (Eppo, Statsig, LaunchDarkly).
- Strong product sense; ability to translate insights into ideas for the product team.
- Bonus: Comfortable in a fast-paced startup; able to manage multiple experiments simultaneously.
- Bonus: Excellent written storytelling; exec-ready visuals and concise recommendations.
- Bonus: Ability to collaborate with cross-time zone teams.
- Preference: Candidates residing in CA will be given first consideration.
