AI-Driven Data & Analytics Engineer (Snowflake + PowerBI)

Mediaocean

New York (NY)

Hybrid

USD 150,000 - 175,000

Full time

10 days ago

Get more replies from employers

Send a job-specific resume in minutes.

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.