Programmatic Revenue Analyst

Samba TV tracks streaming and broadcast video across the world with our proprietary data and technology. We are on a mission to fundamentally transform the viewing experience for everyone. Our data enables media companies to connect with audiences for new shows and movies, and enables advertisers to engage viewers and measure reach across all their devices. We have an amazing story with a unique perspective on culture formed by a global footprint of data and AI-driven insights.

The Programmatic Revenue Analyst plays a pivotal role in driving financial accuracy and transparency across Samba TV's comprehensive programmatic portfolio, including Data Segments, PMP deals, Managed Service, and Open Exchange (OX) solutions. As the owner of the revenue reconciliation process, this position sits at the critical intersection of adtech platforms, revenue operations, and data analytics. The role demands a unique blend of technical prowess and deep programmatic advertising expertise to navigate complex platform relationships and revenue models.

The ideal candidate is a data-driven problem solver who can translate intricate programmatic metrics into actionable business insights. They thrive in a dynamic environment where they can tackle multiple high-stakes priorities while maintaining impression-level precision across billions of monthly transactions. This position offers the opportunity to build a streamlined revenue operations system at a company that's fundamentally transforming how brands leverage TV data across the entire media ecosystem.

Requirements: must live within 50 miles of a Samba Office in NYC. Required in office 3 days a week (Tuesday-Thursday) with a possibility of increasing in the future.

How You Will Grow:
• Own end-to-end monthly revenue reconciliation process across all programmatic offerings using Power BI and Azure
• Ingest, clean, and normalize usage reports from multiple activation platforms, including DMPs (Liveramp, Semasio), SSPs (Magnite, Freewheel, OpenX, Xandr Curate, Pubmatic), CTV AdServers (Springserve), and DSPs (The Trade Desk, Xandr Curate, DV360)
• Map all programmatic product usage data to Salesforce Opportunities and Product Line Items to ensure accurate revenue attribution
• Build and maintain comprehensive dashboards that provide visibility into programmatic revenue streams
• Analyze and validate impression data, CPMs, Traffic Acquisition Costs (TAC), and revenue share agreements across different usage reports
• Proactively investigate and resolve revenue discrepancies between platform usage reports and Salesforce opportunities to maintain data integrity and accurate forecasting
• Drive cross-functional alignment between Finance, Sales, and Operations teams to ensure timely and accurate revenue recognition, reporting, and billing processes
• Analyze platform performance metrics to deliver actionable revenue insights and growth opportunities to key stakeholders across Sales, Finance, and Executive teams
• Lead process automation initiatives and develop strategic recommendations for new tools and technologies to optimize the monthly reconciliation workflow.

Requirements:
• 5+ years of experience in programmatic advertising, adtech, or data analysis
• Degree in Business Analytics, Data Science, Computer Science, or related field
• Deep understanding of programmatic advertising metrics (impressions, CPMs, revenue shares) and usage reports across DMPs, SSPs, DSPs, and ad servers
• Advanced Excel and Google Sheets experience with experience writing scripts
• Experience with tools like Power BI, Tableau, Datorama, Looker
• Proficiency in Salesforce CRM and ability to understand complex data relationships
• Meticulous attention to detail and ability to investigate data anomalies
• Excellent problem-solving skills with the ability to work independently
• Strong communication skills to effectively collaborate with cross-functional teams

Preferred Qualifications:
• Experience with Python (Pandas) or R for data analysis and automation
• SQL proficiency for querying and analyzing large datasets
• Knowledge of APIs and data integration concepts
• Experience with version control systems like Git
• Experience with ETL processes and data warehousing concepts

Samba TV is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We strive to empower connection with one another, reflect the communities we serve, and tackle meaningful projects that make a real impact.

Samba TV may collect personal information directly from you, as a job applicant, Samba TV may also receive personal information from third parties, for example, in connection with a background, employment or reference check, in accordance with the applicable law. For further details, please see Samba's Applicant Privacy Policy. For residents of the EU , Samba Inc. is the data controller.