Business Intelligence Analyst

Role Overview

We're seeking a Business Intelligence Analyst to combine 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.

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
• Experience migrating or rebuilding reporting environments (e.g., Datorama to Tableau) preferred
• Strong understanding of KPI development and performance measurement frameworks
• Able to manage multiple projects simultaneously and meet tight deadlines
• Excellent communication skills with the ability to translate technical findings into business insights

Priorities (Nice-to-Have)

• Experience migrating reporting platforms (e.g., Datorama → 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

Crossmedia Benefits

• Flexibility to work in hybrid manner with in-office and work from home options (depending on role)
• Open/Flexible PTO with US & UK specific policies
• Sponsored healthcare options and agency-wide physical & mental health support
• 401k with company match (USA), and generous Pension (UK)
• Paid sabbatical at significant milestone anniversaries
• Generous paid parental leave policy
• Life milestone recognition & support
• The Pursuit of Happiness Fund devoted to helping Crossmedians find their happy (be it travel, enrichment class, fitness membership or professional development)
• Cell phone/tech reimbursement
• Student Loan payment plan (US)
• Tuition reimbursement
• Learning & Development and training programs
• And burgers – lots and lots of burgers

Diversity & Inclusion Commitment

As a minority-owned company, our commitment to an inclusive environment has long been embedded into agency practices and at every level. Diversity is in our DNA. We have active mentoring & internship programs that create opportunities for underrepresented groups. Internal agency programming is anchored by XMEquity365, a permanent, year-round initiative fostering acknowledgement and support of marginalized communities within five pillars – Excellence, Voices, Education, Giving & Representation.

Equal Employment Opportunity

All job requirements are subject to possible revision to reflect changes in the position requirements, business necessities and/or to reasonably accommodate individuals with disabilities. Essential and other job functions are subject to modification. This job description in no way states or implies that these are the only duties to which will be required in this position. Employees will be required to follow other job-related duties as requested by their supervisor/manager (within guidelines and compliance with laws in the US and UK ). Continued employment remains on an “at-will” basis.” Reasonable accommodations may be provided to enable individuals with disabilities to perform essential functions in compliance with the Americans with Disabilities Act of 1990 (US based)

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job:

• Prolonged periods of sitting at a desk and working on a computer. Must be able to remain in a stationary position 50% of the time.
• Ability to stand, bend, and reach
• Constantly operates a computer and other office productivity machinery, such as a calculator, copy machine, and computer printer.
• The ability to communicate information and ideas so others will understand. Must be able to exchange accurate information in these situations.
• The ability to observe details at close range (within a few feet of the observer).