Data & Analytics Engineer, FP&A
About The Position
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.
Requirements
- Strong hands-on Snowflake experience (modeling, performance, and production pipelines).
- PowerBI fluency (building reports people rely on).
- Real production experience with Claude or another LLM in a live workflow, including output validation.
- NetSuite, Snowflake and SAP data integration experience.
- Comfort partnering directly with finance stakeholders and business unit leaders.
Responsibilities
- Own the end-to-end data pipeline: NetSuite → Snowflake → reporting, built to survive schema drift, API changes, and month-end without breaking.
- Own the Snowflake data model that becomes the single source of truth behind the Innovid/Prisma consolidation process.
- Deliver PowerBI dashboards and self-service executive views for the FP&A team and business partners.
- Manage Claude integration in production, creating the "Ask Finance" layer of our AI-powered database with guardrails for accuracy, explainability, and traceability.
- Integrate open web data from third-party marketing sources, financial results & analyst reports from public company clients into structured data for Snowflake predictive modeling tools.
- Help turn the FP&A team into an AI-first department conducive for an agentic environment.
Benefits
- Open Paid Time Off (PTO)
- Flexible schedule
- Company holidays
- 12 weeks of paid parental leave (after 6 months of employment)
- 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
- 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
- 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)
- Companywide health challenges with prizes
- 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
- Fresh bagels and company-paid lunches in-office twice a week (for hybrid employees in NYC and Chicago)
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
