Business Intelligence Analyst (Marketing)

TL;DR

Business Intelligence Analyst (Marketing): Translating business questions into data requirements and delivering executive-ready dashboards with an accent on media and marketing analytics. Focus on building client-facing dashboards, optimizing Tableau performance, and ensuring data integrity across multi-source datasets.

Location: Hybrid (New York, NY)

Company

A global minority-owned media planning and buying agency committed to transparency, objectivity, and professional growth.

What you will do

• Own BI projects end-to-end, from defining data requirements to delivering polished executive dashboards.
• Build and maintain client-facing dashboards to communicate campaign performance and audience measurement.
• Analyze complex, multi-source datasets to identify discrepancies and ensure data integrity.
• Translate technical findings into actionable business recommendations for non-technical stakeholders.
• Manage multiple high-priority initiatives simultaneously in a fast-paced, deadline-driven environment.

Requirements

• 2+ years of experience in BI, Data Analytics, or Marketing/Media Analytics.
• High proficiency in Tableau, including calculated fields, LOD expressions, and performance optimization.
• Strong SQL skills for writing complex queries and joining multiple data sources.
• Proven track record of building executive- or client-facing dashboards.
• Strong understanding of KPI development and performance measurement frameworks.

Nice to have

• Experience migrating reporting platforms (e.g., Datorama to Tableau).
• Familiarity with data warehousing tools such as Snowflake, BigQuery, or Redshift.
• Experience working in an advertising agency or client-service environment.
• Exposure to ETL tools or API-based data integrations.
• Experience mentoring junior analysts or managing standardized dashboard templates.

Culture & Benefits

• Hybrid work flexibility with in-office and work-from-home options.
• Open/Flexible PTO and paid sabbatical at significant milestone anniversaries.
• Comprehensive healthcare, 401k with company match (USA), and Pension (UK).
• Pursuit of Happiness Fund for travel, fitness, or professional development.
• Tuition reimbursement and student loan payment plans for US employees.