Pion

Affiliate Analyst

Pion

full-time

Posted on:

Location Type: Remote

Location: Remote • 🇬🇧 United Kingdom

Visit company website
✨ AI Apply
Apply

Job Level

Mid-LevelSenior

Tech Stack

BigQuerySQLTableau

About the role

  • Analyse and reconcile affiliate network data against internal metrics to identify tracking discrepancies, revenue leakage, and commission inaccuracies.
  • Conduct performance and commission audits, ensuring correct CPA rates, sub-ID tracking, and overall partner integrity.
  • Build models and insights to uncover revenue opportunities, optimise conversion paths, and recommend strategic upsells or product/technical fixes.
  • Develop and maintain reporting and dashboards covering key operational metrics such as decline rates, tracking-error volume, and post-transaction conversion.
  • Partner with Product, Engineering, and Data teams to diagnose tracking issues, build automated alerting and improve data quality
  • Support Commercial teams with data-driven business cases and predictive models to identify opportunities for affiliate growth and/or leakage recovery

Requirements

  • Strong analytical background working with affiliate marketing data or high-volume transactional datasets.
  • Advanced SQL skills and solid experience using BI/visualisation tools such as Lightdash, Tableau, or Power BI.
  • Proven ability to reconcile and validate external affiliate performance data against internal transaction logs.
  • Solid understanding of affiliate tracking methods (S2S, cookies, sub-IDs) and common causes of tracking failure.
  • Skilled in building predictive models and forecasting the impact of operational or partnership changes.
  • Experience with event-level analytics platforms (e.g., Snowplow, GA360/BigQuery, Adobe Analytics) and a proactive, investigative approach to identifying issues, risks, and opportunities.
Benefits
  • 💰 Competitive salary.
  • 🌴 30 days annual leave, plus bank holidays.
  • 🏆 Accredited 'Great Place To Work’ company in three categories.
  • 🧠 Commitment to personal development and career growth, coaching workshops and progression plans.
  • 👩🏽‍💻Remote-first working environment. This means you’re not obligated to come into the office, you can choose the environment you think you excel best in.
  • 📅Flexible working hours (start between 8-10am and finish between 4:30-6:30pm).
  • ❤️ Focus on welfare. We offer a monthly wellness allowance, gym memberships, access to mental health first aiders, a health cash plan and more.
  • 🛍️ Access to incredible partnership discounts for the biggest brands in the world. Think Google, Apple, GymShark, Domino's, Uber and loads more!
  • 💻 £200 work from home set up allowance to put towards your at-home working space.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQLdata analysispredictive modelingdata reconciliationaffiliate tracking methodsevent-level analyticsperformance auditingdata validationconversion optimizationrevenue analysis
Soft skills
analytical skillsproblem-solvingcommunicationcollaborationinvestigative approach