Data Analyst, AI & Financial Automation

Mediaocean provides end-to-end software and AI for advertising, making content more accessible around the world. Our vision is a perpetually thriving media industry where marketing drives sustainable growth for the global economy. With over $200 billion in annualized ad spend running through its platforms, the company supports 100,000 users across the globe. Mediaocean owns and operates Prisma , the industry’s trusted system of record for media management and finance;

Innovid , the leading independent ad tech platform for creative, delivery, measurement, and optimization; and Protected by Mediaocean , an integrated solution for ad verification and brand safety. Visit for more information.

You'll be the technical backbone turning Mediaocean's FP&A team into a governed, AI-powered data operation — owning the pipeline from ERP and other data sources through Snowflake to the tools the whole finance org and business leaders use every day.

What You Will Own:

• The end-to-end data pipeline:
  Net Suite → Snowflake → reporting, built to survive schema drift, API changes, and month-end without breaking.
• The Snowflake data model that becomes the single source of truth behind the Innovid/Prisma consolidation process
• PowerBI delivery — dashboards and self-service executive views the FP&A team and business partners actually trust.
• Claude integration in production — the "Ask Finance" layer of our AI-powered database, built with real guardrails so AI-assisted numbers are accurate, explainable, and traceable back to source.
• Integrate open web data from third party marketing sources, financial results & analyst reports from our public company clients into structured data that feeds our Snowflake predictive modeling tools that generates cutting-edge insights for our most senior business leaders.
• Help turn the FP&A team into an AI-first department that is conducive for an agentic environment

• Strong hands-on Snowflake experience — modeling, performance, and production pipelines, not just querying.
• PowerBI fluency — building reports people rely on, not just connecting a data source.
• Real production experience with Claude or another LLM in a live workflow, including how you validate output before it reaches someone else's decision.
• Net Suite, Snowflake and SAP data integration experience and comfort partnering directly with finance stakeholders and business unit leaders.

• Work-Life Balance:Open Paid Time Off (PTO),Flexible schedule,Company holidays,12 weeks of paid parental leave (after 6 months of employment)
• Total Rewards:Competitive salary,Full benefits package starting on your first day,Referral bonuses,Recognition awards,401(k) with company match,Company HSA contribution up to $2,400
• Comprehensive Benefits:Medical/Dental/Vision/Pharmacy,Health Savings Account (HSA)/Flexible Spending Account (FSA),Mental health support,Life & Disability insurance,Family planning & fertility benefits,Pet insurance,Legal &  protection,Retirement planning,Medicare assistance,Employee Assistance Program (EAP), Professional training/Tuition reimbursement
• Wellness Focus:Eligible employees get up to 100% company paid annual subscriptions to Peloton, Maven Clinic, Better Up Care, Walkingspree, Bikeshare (Divvy in Chicago/Citibike in New York), Wellness Seminars (physical, mental, financial, social) as well as opportunities to compete in company wide health challenges with prizes
• Award-Winning Company Culture:Professional development with a dedicated Talent Development team,Employee Resource Groups (ERGs),Philanthropy & awareness programs,Mentorship programs, In-office and virtual events & celebrations,Various volunteer & donation opportunities, Innovative and collaborative work environment
• For hybrid…