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+ Crossmedians 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. YOUR ROLE 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. 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 Ability to manage multiple projects simultaneously and meet tight deadlines Excellent communication skills with the ability to translate technical findings into business insights PREFERRED QUALIFICATIONS (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 Our principles of Trust, Reason, and the Pursuit of Happiness are brought to life through benefits that recognize and support the diversity and physical, emotional, and professional well-being of our people, including: 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 COMMITMENT TO DIVERSITY AND INCLUSION Diversity is in our DNA. As a minority-owned company, our commitment to an inclusive environment has long been embedded into agency practices and at every level. Almost one third of senior leadership identifies as a person of color and over half of our executive leadership are women. 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. Crossmedia is committed to providing equal employment opportunities and creating a diverse and inclusive company culture and that does not discriminate against candidates and employees because of their disability, sex, race, gender identity, sexual orientation, religion, national origin, age, veteran status, or any other basis prohibited by applicable federal, state, or local law. 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 American 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). In compliance with the current Americans with Disabilities Act and state and local laws, if you have a disability and would like to request an accommodation to apply for a position with Crossmedia, please email [email protected] . (US based candidates).