Data Analyst, AI & Financial Automation

Mediaocean; New York (NY); Hybrid; USD 150,000 - 175,000; Full time

Benefits offered by this job

Open PTO

Flexible schedule

Company holidays

Parental leave (12 weeks)

Job summary

Mediaocean is seeking a data-driven engineer to own the end-to-end FP&A data pipeline from NetSuite through Snowflake to reporting. You will build a robust Snowflake model and deliver trusted PowerBI dashboards for executives and finance partners.

You will also productionize Claude integration with guardrails to ensure accurate, explainable outputs linked to source data, and integrate external data for predictive insights for senior leadership.

Qualifications

• Strong hands-on Snowflake modeling, production pipelines, and schema drift handling.
• PowerBI reports built for executive decision-makers and trusted by users.
• Experience deploying Claude or another LLM in live workflows with output validation.

Responsibilities

• Own end-to-end data pipeline from NetSuite to Snowflake to reporting.
• Develop Snowflake data model serving as single source of truth for consolidations.
• Deliver PowerBI dashboards and self-service views for FP&A and business partners.
• Integrate Claude in production with guardrails for AI-assisted numbers.

Skills

Snowflake

PowerBI

Claude

NetSuite

SAP

Tools

Snowflake

PowerBI

Claude

NetSuite

SAP

Job description

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 www.mediaocean.com for more information.

What You Will Do:

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: NetSuite → 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

Who You Are:

• 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.
• NetSuite, Snowflake and SAP data integration experience and comfort partnering directly with finance stakeholders and business unit leaders.

Why Mediaocean?

• 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 & ID theft 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, BetterUp Care, Walkingspree, Bikeshare (Divvy in Chicago/Citibike in New York), Wellness Seminars (physical, mental, financial, social) as well as opportunities to compete in companywide 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 employees in NYC and Chicago: Enjoy fresh bagels and company-paid lunchesin-officetwice a week

Our budgeted compensation range for this opportunity is $150,000–$175,000 + bonus, commensurate with experience and skills. This position will be hybrid in our New York City office.

We would hate to miss out on your application because you do not meet every requirement – transferrable skills and education will also be considered, so please do not hesitate to apply!

Mediaoceanrecognizes our true strength and value shine when all our team members feel there is space in the conversation for their voices, thoughts, ideas, perspectives, and concerns.Mediaoceanis committed to being an equal opportunity employer, and we consider all applicants regardless of their age, race, color, gender, sexual orientation, ethnicity, religion, national origin, disability, or veteran status.