Senior Associate, Business Intelligence

EssenceMediacom

3mo ago

Job
Full-time
Junior & Mid Level
Data
$45K - $90K
New York
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.

Requirements

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.

Responsibilities

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.

FAQs

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.

EssenceMediacom

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

Marketing & Advertising

Industry

5001-10,000

Employees

1986

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.