Senior Analyst, Data Management & Visualization

IPG Mediabrands•New York, NY

About The Position

The Senior Analyst, Data Management position works within the Data Management team and manages the media performance data setup, maintenance and troubleshooting across a set of Mediahub clients. This role will be providing analytic direction to support clients and help guide more junior analysts to improve our clients' marketing programs as well as leading project/analysts. They will support all aspects of data processing for subsequent analysis and performance reporting. The Sr. Analyst, Data management collaborates with clients and internal teams to manage data logistics - including data specifications, structures, rules and transfers from numerous media channels and partners providing valuable insights to the Mediabrands team.

Requirements

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.

Nice To Haves

1+ years of experience in a professional services or corporate environment, preferably an agency.
Familiarity with media mix modeling and other forms of regression-based ROI; A/B and multivariate test design.

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.
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.
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.

Benefits

We offer a Total Rewards package that includes medical and dental coverage, 401(k) plans, flex spending, life insurance, disability, employee discount program, employee stock purchase program and paid family benefits to support you and your family.
To give you the ability to better meet your personal needs, and in support of your physical and emotional well-being, you will receive discretionary time off days and company-wide Appreciation Weeks and Wellness Days.
We also offer a competitive Total Compensation package, including a competitive salary and eligibility for an annual discretionary incentive award or a relevant incentive award.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume