Data & Analytics Engineer, FP&A

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

Benefits offered by this job

Open Paid Time Off (PTO)

Flexible schedule

Company holidays

12 weeks of paid parental leave

Competitive salary

Full benefits package starting on your

first day

401(k) with company match

Company HSA contribution

Medical/Dental/Vision/Pharmacy

HSA / FSA options

Mental health support

Life & Disability insurance

Pet insurance

Retirement planning

Professional training / Tuition reimb

Job summary

Mediaocean is building a governed, AI-powered data operation for FP&A, owning 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 sources so the FP&A team and senior leaders can access reliable consolidation, reporting, and predictive modeling insights.

Qualifications

• Hands-on Snowflake experience with data modeling and production pipelines.
• Proficiency in PowerBI for executive dashboards.
• Experience deploying Claude or similar LLM in production with validation.
• Experience integrating NetSuite, SAP, and other ERP sources with finance stakeholders.

Responsibilities

• Own end-to-end data pipeline from ERP to Snowflake and BI dashboards.
• Develop Snowflake data model serving as single source of truth for the consolidation process.
• Deliver PowerBI dashboards and executive self-service views for FP&A and partners.
• Integrate Claude in production with guardrails for accuracy, explainability, and traceability to sources.
• Ingest open web data and third-party sources for Snowflake predictive modeling.

Skills

Snowflake modeling & pipelines

PowerBI reporting

Claude / LLM production use

ERP integrations (NetSuite & SAP)

Tools

Snowflake

PowerBI

NetSuite

SAP

Job description

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