Logo of Huzzle

Senior Associate, Business Intelligence

  • Job
    Junior & Mid Level
  • Data
  • $45K - $90K
  • New York City
  • Quick Apply

AI generated summary

  • You need a Bachelor’s degree or equivalent experience, 1-3 years in data management/analytics, Tableau/Power BI skills, Alteryx proficiency, digital marketing data familiarity, SQL/Python knowledge, and excellent communication and problem-solving abilities. A collaborative spirit is a must.
  • You will collect, manage, and analyze data, develop databases, and create visualizations for insights to optimize campaigns and ensure data accuracy.


  • Bachelor’s degree in Marketing, Advertising, Economics, Computer Science, Information Systems, Business Analytics, or related field. OR equivalent professional work experience.
  • 1 – 3 years of work experience in data management, data visualization and data analytics preferably in a marketing and/or media agency.
  • Experience in database structure work and in building dashboards with Tableau and/or Power BI, Google Data Studio, Datorama, Domo is required; knowledge of visual techniques for data analysis and presentation is a plus.
  • Experience with Alteryx for business logic design required as well as ability to operate in Cloud environment (Azure. GCP, AWS, IBM data cloud pack).
  • Experience working with SQL or Python.
  • Experience with digital data from ad serving platforms (e.g. Google Campaign Manager, Other adservers), campaign planning tools (e.g. Prisma, Lumina, MediaOcean), website analytics software (e.g. Adobe Analytics, Google Analytics), paid search engine marketing data sources (e.g. Adwords, Marin, …) and others is strongly preferred.
  • Strong speaking and written professional communication skills.
  • Strong analytical, critical thinking, and problem-solving skills.
  • The ability to thrive in a fast-paced and deadline-driven environment.
  • Collaborative with a partnership mindset.


  • Collect data requirements from client teams including the Analytics and Insights team to understand the measurement framework, the most critical metrics to implement for database build and business logic for data stitching.
  • Manage data provisioning.
  • Define the taxonomy for the activation team to implement to ease data retrieval.
  • Manage the retrieving, compiling, and formatting of large volumes of data (ETL).
  • Manage data cleaning.
  • Assist in the set-up of the clients’ environment (Cloud infrastructure and data lakes …)
  • Assist in the build and development of custom databases on the reporting platform.
  • Assist in the strategy and development of the data visualization layer of the business intelligence platforms (Tableau) for insight generation for use in campaign monitoring and optimization.
  • Help the development of automated QA processes to ensure data accuracy and timeliness.
  • Communicate technical terms to non-technical people and help them understand why change might be required to achieve a specific goal or to complete a project.


What is the role of a Senior Associate, Business Intelligence?

The Senior Associate, Business Intelligence is responsible for building, developing, and maintaining the reporting infrastructure, business intelligence, and data visualization to deliver campaign reporting insights and competitive insights. They will retrieve, compile, cleanse, and transform data to create the intelligence layer for analysis and optimization of media investments.

We are EssenceMediacom. GroupM’s newest and largest agency, committed to delivering marketing breakthroughs for brands.

Marketing & Advertising
Founded Year

Mission & Purpose

Hello. We are EssenceMediacom. GroupM’s newest and largest agency, committed to delivering marketing breakthroughs for brands. We have disrupted the old models across media, creative, innovation and analytics to find new opportunities for advertisers and deliver truly integrated media solutions. Born out of two pioneering agencies, EssenceMediacom fuses Essence’s performance, data, analytics and creative technology DNA with MediaCom’s scaled multichannel audience planning and strategic media expertise. Our ‘breakthrough’ ambition is underpinned by our commitment to ‘continuous learning’. We aim to ensure our people fulfil their potential by investing their whole-person wellbeing, careers and capabilities, which in turn helps grow our clients’ businesses. With 10,000 people across 120 offices in 96 markets, we are one of the world’s leading communications specialists with billings of more than US$22 billion (Source: COMvergence, 2022). Our global client roster includes adidas, Coca-Cola (TCCC), Dell, Google, Hasbro, Mars, NBC Universal, P&G, Richemont, Shell, Sony and Uber.