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 #J-18808-Ljbffr Mediaocean