Data Analyst, AI & Financial Automation

About the role

Mediaocean provides end‑to‑end software and AI for advertising, making content more accessible around the world. The company supports over $200 billion in annualized ad spend and serves 100,000 users globally through platforms such as Prisma, Innovid, and Protected by Mediaocean.

You will 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 finance organization and business leaders use every day.

Responsibilities

• Own the end‑to‑end data pipeline: NetSuite → Snowflake → reporting, built to survive schema drift, API changes, and month‑end without breaking.
• Develop and maintain the Snowflake data model that serves as the single source of truth for the Innovid/Prisma consolidation process.
• Deliver PowerBI dashboards and self‑service executive views that the FP&A team and business partners trust.
• Implement Claude integration in production—the “Ask Finance” layer of our AI‑powered database—ensuring AI‑assisted numbers are accurate, explainable, and traceable to source.
• Integrate open‑web data from third‑party marketing sources, financial results, and analyst reports into structured data that feeds Snowflake predictive‑modeling tools for senior leadership insights.
• Help transform the FP&A team into an AI‑first department that supports an agentic environment.

Requirements

• Strong hands‑on Snowflake experience—including modeling, performance tuning, and production pipelines.
• PowerBI fluency: building reliable reports that users depend on, not just connecting data sources.
• Real production experience with Claude or another LLM in a live workflow, including validation of output before it informs decisions.
• Experience integrating NetSuite, Snowflake, and SAP data, and comfort partnering directly with finance stakeholders and business unit leaders.

Benefits

Work‑Life Balance

• Open Paid Time Off (PTO) and flexible schedule
• Company holidays
• 12 weeks of paid parental leave (after 6 months of employment)

Total Rewards

• Competitive salary
• Full benefits package starting on day one
• Referral bonuses and recognition awards
• 401(k) with company match
• Company HSA contribution up to $2,400

Comprehensive Benefits

• Medical, dental, vision, and pharmacy coverage
• Health Savings Account (HSA) / Flexible Spending Account (FSA)
• Mental health support
• Life & disability insurance
• Family planning & fertility benefits
• Pet insurance
• Legal & ID theft protection
• Retirement planning and Medicare assistance
• Employee Assistance Program (EAP)
• Professional training / tuition reimbursement

Wellness Focus

• Up to 100 % company‑paid annual subscriptions to Peloton, Maven Clinic, BetterUp Care, Walkingspree, and bike‑share programs (Divvy in Chicago, CitiBike in New York)
• Wellness seminars covering physical, mental, financial, and social health
• Company‑wide health challenges with prizes

Award‑Winning Company Culture

• Dedicated Talent Development team for professional growth
• Employee Resource Groups (ERGs) and mentorship programs
• Philanthropy, awareness programs, and volunteer opportunities
• In‑office and virtual events, celebrations, and innovative collaborative environment

Hybrid Employee Perks (NYC & Chicago)

• Fresh bagels and company‑paid lunches in the office twice a week

Pay

Budgeted compensation range: $150,000 – $175,000 plus bonus, commensurate with experience and skills.

Schedule

This position is hybrid, based in the New York City office.