Data & Analytics Engineer, FP&A

Mediaocean is building a governed, AI-powered data operation for FP&A, and this role owns the technical backbone that moves data from ERP and other sources into Snowflake, then into PowerBI and an AI-enabled “Ask Finance” experience with guardrails for accuracy, explanation, and traceability.

Based in New York, NY (hybrid), you will help integrate NetSuite, SAP, and open web or third-party sources (including public company financial and analyst reports) so the FP&A team and senior business leaders can access reliable consolidation, reporting, and predictive modeling insights.

Compensation: USD 150,000 - 175,000 per year.

What you will do

• Own the end-to-end data pipeline, including NetSuite to Snowflake reporting, designed to remain stable through schema drift, API changes, and month-end activity.
• Build and maintain the Snowflake data model that serves as the single source of truth for the Innovid/Prisma consolidation process.
• Deliver PowerBI dashboards and executive self-service views that FP&A and business partners can trust.
• Integrate Claude in production for the AI-powered “Ask Finance” layer, with real guardrails so AI-assisted numbers are accurate, explainable, and traceable back to source.
• Ingest open web data from third-party marketing sources, plus client public-company financial results and analyst reports, and convert them into structured data feeding Snowflake predictive modeling tools.
• Support the FP&A team in becoming AI-first and well-suited for an agentic environment.

What you bring

• Strong, hands-on Snowflake experience, including modeling, performance, and production pipelines (not just querying).
• PowerBI fluency with the ability to build reports people rely on, not just connect data sources.
• Real production experience using Claude (or another LLM) in a live workflow, including how you validate output before others use it for decisions.
• Experience integrating NetSuite, Snowflake, and SAP, plus comfort partnering directly with finance stakeholders and business unit leaders.

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
• Eligible employees can receive up to 100% company-paid annual subscriptions to Peloton, Maven Clinic, BetterUp Care, Walkingspree, and Bikeshare (Divvy in Chicago / Citibike in New York)
• Wellness Seminars (physical, mental, financial, social)
• Opportunities to compete in 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
• For hybrid employees in NYC and Chicago: fresh bagels and company-paid lunches in-office twice a week

Technologies: Snowflake, PowerBI, Claude, LLM, NetSuite, SAP, ERP, API