Centralize data from multiple systems (Amazon SP-API, Facebook Ads manager, Smartsheet, Stripe, Pipedrive, QuickBooks, Google Sheets)
Build a command center dashboard covering B2B Marketing, Finance, Client results, Fulfillment & Ops
Design scalable reporting so insights hold true across 500+ clients
Deliver insights, not just charts; highlight leaks, risks, and growth opportunities
Set up automated alerts (Slack/email) for actionable insights
Ensure system is easy to maintain, expandable, and reliable
Work with teams to drive decisions daily and influence hundreds of brands worldwide
Requirements
Proven agency or consultancy experience building reporting systems at scale for 200+ clients
Built reporting systems that scaled and changed business decisions
Strong grasp of marketing funnels, CAC/LTV, retention, and ops metrics
Amazon data experience (SP-API, PPC, FBA KPIs) (nice to have)
Understanding of ACOS, TACOS, organic vs paid sales, ranking (nice to have)
Familiarity with AI/automation tools (Lovable, Cursor, Base44, Make.com, Zapier)
Technical SQL, API integrations, and data pipeline experience
Experience with BI tools (Looker Studio, Power BI, Tableau, Metabase)
Experience with automation tools and advanced Google Sheets
Proven ability to centralize data from multiple systems (Amazon SP-API, Facebook Ads manager, Smartsheet, Stripe, Pipedrive, QuickBooks, Google Sheets)