Data & Analytics Engineer, FP&A
Accounting
Analytics
APIs
Artificial Intelligence
Business Analytics
Business Intelligence
Data
Data Analysis
Data Analytics
Data Engineer
Data Integration
Data Pipeline
Data Processing
Data Visualization
Data Warehouse
Data Warehousing
Database
Databases
ERP
ERP Systems
FP&A
Integration
NetSuite
Power BI
Reporting and Analytics
Snowflake
Job Description
Own the end-to-end FP&A data platform that powers consolidation, predictive modeling, and an AI-assisted “Ask Finance” experience.
Responsibilities
- Build and maintain the end-to-end data pipeline from ERP and other data sources through Snowflake and onward to PowerBI.
- Deliver a pipeline based on NetSuite to Snowflake reporting that withstands schema drift, API changes, and month-end cutovers without breaking.
- Develop and own the Snowflake data model that functions as the single source of truth for the Innovid/Prisma consolidation process.
- Produce PowerBI dashboards and self-service executive views that FP&A and business partners actually trust and use.
- Integrate Claude into a production workflow for the Ask Finance layer, including guardrails to support accurate, explainable, and traceable AI-assisted numbers back to source.
- Ingest and structure open web and third-party marketing data, plus public company financial results and analyst reports, so they feed Snowflake predictive modeling tools.
- Support FP&A adoption of an AI-first operating model that is conducive for an agentic environment.
Requirements
- Hands-on Snowflake experience across data modeling, performance, and production pipelines (not limited to querying).
- PowerBI fluency with experience building reports people rely on, not just connecting data sources.
- Production experience with Claude or another LLM in a live workflow, including how you validate outputs before they influence someone else’s decisions.
- Integration experience with NetSuite, Snowflake, and SAP, plus comfort partnering directly with finance stakeholders and business unit leaders.
Technology Stack
- Snowflake
- PowerBI
- Claude
- LLM
- NetSuite
- SAP
- ERP
- API
Benefits
- Open Paid Time Off (PTO)
- Flexible schedule
- Company holidays
- 12 weeks of paid parental leave after 6 months of employment
- Competitive salary (USD 150,000 - 175,000 per year)
- 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, and Bikeshare (Divvy in Chicago/Citibike in New York) for eligible employees
- 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
Location
- New York, NY (hybrid)