Data & Analyst - Pipelines,SQL & Bl

• reporting, built to survive schema drift, API changes, and month-end without breaking.
• The Snowflake data model that becomes the single source of truth behind the Innovid/Prisma consolidation process
• PowerBI delivery - dashboards and self-service executive views the Pipelines,SQL & Bl team and business partners actually trust.
• Claude integration in production - the “Ask Finance” layer of our AI-powered database, built with real guardrails so AI-assisted numbers are accurate, explainable, and traceable back to source.
• Integrate open web data from third party marketing sources, financial results & analyst reports from our public company clients into structured data that feeds our Snowflake predictive modeling tools that generates cutting-edge insights for our most senior business leaders.
• Help turn the Pipelines,SQL & Bl team into an AI-first department that is conducive for an agentic environment

• Strong hands-on Snowflake experience - modeling, performance, and production pipelines, not just querying.
• PowerBI fluency - building reports people rely on, not just connecting a data source.
• Real production experience with Claude or another LLM in a live workflow, including how you validate output before it reaches someone else’s decision.
• NetSuite, Snowflake and SAP data integration experience and comfort partnering directly with finance stakeholders and business unit leaders.

3.63.6 out of 5 stars Chicago, IL Hybrid work $24 - $26 an hour - Full-time, Pulled from the full job description

• Referral program
• Tuition reimbursement
• Pet insurance
• Paid parental leave
• Parental leave
• 401(k)
• Health insurance, * Work-Life Balance: Open Paid Time Off (PTO), Flexible schedule, Company holidays, 12 weeks of paid parental leave (after 6 months of employment)
• Total Rewards: 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
• Comprehensive Benefits: 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
• Wellness Focus: Eligible employees get up to 100% company paid annual subscriptions to Peloton, Maven Clinic, BetterUp Care, Walkingspree, Bikeshare (Divvy in Chicago/Citibike in IL), Wellness Seminars (physical, mental, financial, social) as well as opportunities to compete in companywide health challenges with prizes
• Award-Winning Company Culture: 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: Enjoy fresh bagels and company-paid lunches in-office twice a week

Our budgeted compensation range for this opportunity is $24-$26 Per Hour + bonus, commensurate with experience and skills. This position will be hybrid in our office.

We would hate to miss out on your application because you do not meet every requirement - transferrable skills and education will also be considered, so please do not hesitate to apply!

Mediaocean recognizes our true strength and value shine when all our team members feel there is space in the conversation for their voices, thoughts, ideas, perspectives, and concerns. Mediaocean is committed to being an equal opportunity employer, and we consider all applicants regardless of their age, race, color, gender, sexual orientation, ethnicity, religion, national origin, disability, or veteran status.

Pay: $24.00 - $26.00 per hour

Benefits:

• 401(k)

Mediaocean provides end-to-end software and AI for advertising, making content more accessible around the world. Our vision is a perpetually thriving media industry where marketing drives sustainable growth for the global economy. With over $200 billion in annualized ad spend running through its platforms, the company supports 100,000 users across the globe. Mediaocean owns and operates Prisma, the industry’s trusted system of record for media management and finance; Innovid, the leading independent ad tech platform for creative, delivery, measurement, and optimization; and Protected by Mediaocean, an integrated solution for ad verification and brand safety. Visit www.mediaocean.com for more information.

What You Will Do:

You’ll be the technical backbone turning Mediaocean’s Pipelines,SQL & Bl team into a governed, AI-powered data operation - owning the pipeline from ERP and other data sources through Snowflake to the tools the whole finance org and business leaders use every day.