Apply on Employer Site

IPG Mediabrands · 2 months ago

Senior Analyst, Data Management & Visualization

New York, New York, United States

Full-time

Onsite

Mid, Senior Level

$75K/yr - $85K/yr

1+ years exp

IPG Mediabrands is the media and marketing solutions division of Interpublic Group. The Senior Analyst, Data Management position involves managing media performance data, providing analytic direction to clients, and collaborating with teams to ensure effective data logistics and quality processes.

AdvertisingDigital MediaMarketing

Responsibilities

Understand our clients’ digital and non-digital media ecosystems including challenges of data tracking with cookies/SDK’s, website tagging options, impact of walled gardens, and basic TV and OOH measurement and attribution options available

Collaborate with internal/external stakeholders to manage data logistics – including data specifications, structures, rules and transfers from numerous media channels and partners. Proactively identify and communicate barriers to complete work requirements

Assist in the development of SQL stored procedures, views, functions, performance tables, and well-tuned queries. Analyze and profile data contained in relational databases using both SQL query language and DBMS business tools

Collaborate in the development of dynamic reports that enable end users to define numerous parameters that allow users to filter and aggregate data as required. Create custom reports that allow end users to drill down on dimensions for more detail

Monitor and manage data quality processes and data integrations. Perform corrective and evolutive maintenance of all the data exchange and data solution processes. Make sure the data platforms and processes are running well, both in data collection, integration and processing

Coach, guide and support analysts of data management and insights analysts. Make sure that knowledge transfer flows in both directions, establish the protocols to guarantee knowledge transfer

Qualification

SQLData ManagementAd-serving platformsPythonJavaExcelMedia analytics experienceMedia mix modelingCommunication skills

Required

Higher level of proficiency with the following tools - SQL, Excel, Adverity, Domo, Talend

Demonstrate a good level of proficiency with SQL as evidenced by the ability to: Execute advanced SQL queries and Stored Procedures to process and automate data

Optimize query performance, improve processes, diagnosis problems

Implement best-practices on database schemas and ETL processes using Talend ETL suite

Experience with ad-serving platforms such as Google Campaign Manager; web analytics tools such as Google Analytics and Adobe Analytics, and tag management tools such as DTM/Launch, GTM and Tealium

Excellent verbal and written communication skills

Familiarity with various online and offline media channels

Prior media analytics experience/knowledge

Greater ability to program in Python and Java