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
Top Skills
What We Do
Television remains a vibrant cultural influence and an essential source of entertainment and information worldwide. Tremendous growth in content choices, and viewing platforms that allow us to watch anything, anytime, on any screen, has actually made it harder for viewers to discover and keep up with all the great programming available. It’s also more competitive for content providers to keep your attention, and for marketers to make strong, measurable connections with their target consumers.
Technology that improves the viewing experience, enables content discovery, and addresses audience fragmentation across screens will strengthen television’s business model and relevance to consumers. Data is at the center of any solution to make TV better.
Samba TV's technology is built into Smart TVs and easily maps to smart phones and tablets. By recognizing what's on screen, Samba TV learns what viewers like and using machine learning algorithms, enables discovery of shows and actors in a whole new way. Likewise, our data and measurement products are transforming the way stakeholders across the media landscape are thinking about their business. Given the dramatic growth in streaming services, connected devices, time-shifting, and multi-screen viewership, our data products solve real problems and create a meaningful competitive advantage for our clients.
