Business Intelligence Analyst

WHO WE ARE

Crossmedia is the global media independent. We’re committed to doing media and business the right way, guided by the principles of TRUST, REASON and the Pursuit of HAPPINESS. Crossmedia US was founded in NY in 2000 and is one of the largest minority-owned full-service media planning & buying agencies in the nation. We are 500+ Cross medians worldwide with big ambitions to continue to grow with soul.

We focus on what media agencies should do: create innovative connections between brands and people regardless of channel or budget. And we do it in an honest way. We are and always have been a values-based organization. We earn our clients TRUST by ensuring media transparency in our business model and objectivity in decision-making. We apply REASON & logic to finding solutions to our clients’ greatest business challenges.

The Pursuit of HAPPINESS matters to us. Big time. We invest in each colleagues’ professional & personal wellbeing and growth. It’s why we have countless initiatives, clubs & cultural events dedicated to our people and why we have been the top ranked media agency named to Ad Age’s Best Places to Work for the past seven years in a row.

We have offices in the US in New York and Philadelphia, with employees across 25+ states, as well as in London and Germany. Our client roster includes U.S. Bank, Invesco, Newell Brands, NASCAR, Planet Fitness, American Cancer Society, Ricola, Herschend Family Entertainment, Edible Arrangements and more.

We’re seeking a Business Intelligence Analyst
, a role that combines strong technical expertise with strategic thinking and a deep understanding of how data drives business decisions. The ideal candidate is comfortable owning projects end-to-end — from translating business questions into data requirements to delivering polished, executive-ready dashboards and insights.

You should be highly analytical and detail-oriented, with the ability to manage multiple high-priority initiatives simultaneously. You must be confident working with complex, multi-source datasets and capable of identifying discrepancies, troubleshooting issues, and ensuring data integrity. Just as important, you should be able to communicate findings clearly to non-technical stakeholders, translating data into actionable recommendations.

In a media and marketing analytics environment, we’re looking for someone who understands campaign performance metrics, audience measurement, and cross-channel reporting. You should have experience building client-facing dashboards and be comfortable operating in fast-paced, deadline-driven settings where accuracy and presentation quality are critical.

• 2+ years of experience in Business Intelligence, Data Analytics, or Marketing/Media Analytics
• Highly proficient with Tableau (dashboard development, calculated fields, LOD expressions, performance optimization)
• Strong SQL skills, including writing complex queries and joining multiple data sources
• Experience working with marketing/media data
• Proven experience building executive- or client-facing dashboards
• Experience migrating or rebuilding reporting environments (e.g., Datorama to Tableau) preferred
• Strong understanding of KPI development and performance measurement frameworks
• Ability to manage multiple projects simultaneously and meet tight deadlines
• Excellent communication skills with the ability to translate technical findings into business insights

• Experience migrating reporting platforms (e.g., Datorama → Tableau)
• Experience embedding dashboards into web platforms or proprietary systems
• Familiarity with data warehousing tools (Snowflake, Big Query, Redshift)
• Experience working in an advertising agency or client-service environment
• Exposure to ETL tools or API-based data integrations
• Experience supporting new business pitches or building demo-ready dashboards
• Experience mentoring junior analysts or reviewing others’ work
• Experience building and managing standardized dashboard templates

Our principles of Trust, Reason, and the Pursuit of Happiness are brought to life through benefits that recognize and support the diversity and…