Business Intelligence Analyst

Responsibilities

• Translate business questions into data requirements
• Deliver polished, executive-ready dashboards and insights
• Manage multiple high-priority initiatives simultaneously
• Identify discrepancies, troubleshoot issues, and ensure data integrity
• Communicate findings clearly to non-technical stakeholders
• Build client-facing dashboards and manage campaign performance metrics

Requirements

• 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
• Strong understanding of KPI development and performance measurement frameworks
• Excellent communication skills

Preferred Qualifications

• Experience migrating reporting platforms (e.g., Datorama to Tableau)
• Experience embedding dashboards into web platforms or proprietary systems
• Familiarity with data warehousing tools (Snowflake, BigQuery, 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

Benefits

• Hybrid work flexibility
• Open/Flexible PTO
• Sponsored healthcare and mental health support
• 401k with company match
• Paid sabbatical at significant milestones
• Generous paid parental leave
• The Pursuit of Happiness Fund for personal enrichment
• Cell phone and tech reimbursement
• Student Loan payment plan
• Tuition reimbursement
• Learning & Development programs

About the Company

Crossmedia is a global media independent and one of the largest minority-owned full-service media planning & buying agencies in the nation. We focus on creating innovative connections between brands and people through transparency, reason, and logic.