Marketing / BI Analyst

ROIcamp is a media buying team in the dating vertical. We are hiring a Marketing/BI Analyst to build BI dashboards, run cohort analysis, and validate data for the buying team. The role is fully remote.

• Stitch the tracker and product analytics into a single pipeline, so that a click recorded in the tracker can be matched to the payment it eventually produced.
• Build BI dashboards that cross spend, revenue, and LTV by source, campaign, GEO, and individual buyer.
• Run cohort analysis covering conversion to subscription, retention, rebill dynamics, and LTV forecasts 3–6 months out.
• Validate bonus calculations and reconcile the underlying data before payout, so that no number reaches a buyer unchecked.
• Host weekly reviews with the buying teams on which cohorts pay back, which campaigns deserve more budget, and where LTV is sagging.
• Set up anomaly alerts for fraud patterns, discrepancies between tracker and product, and sudden drops in conversion.
• Agree with the tech lead on which events and parameters tracking has to pass through so that the two data sources reconcile.

• 2+ years in performance or product analytics.
• Confident SQL together with at least one BI tool such as Tableau, Looker, or Metabase.
• Hands-on cohort analysis and LTV forecasting from real work rather than coursework.
• A working command of subscription funnel unit economics, including why the rebill matters more than the first payment.