Overview and Responsibilities

The Sr. Data Management Analyst will be a part of the Corporate Research Digital & Social analytics team and will support the day to day operations of data management tools and platforms. The role would help with data validation of new and existing data sources, translate data requirements to internal technology teams, basic ETL processes, and visualization of data. Ideally, they would have experience with digital and social platform datasets, knowledge of the data ingestion process, experience or familiarity with SQL and databases.

Conducts data validations and analysis to assess the completeness and accuracy of data
Assist with data extraction, manipulation, and transformation based on requirements from stakeholders.
Assist with the maintenance of data sources, accounts, and datasets as it pertains to our data platforms
Analysis will include cleansing, transforming, validating or modeling data for improving data quality, design and presentation.
Work closely with internal Research teams, Analytics, and Technology teams as well as external vendors to ensure that data requirements can be met and executed
Assist with visualizing data creatively and leverage various data sets/metrics in order to optimize surfacing insights and meaningful stories

Basic Qualifications

Requires a broad understanding of datasets from social and digital platforms including but not limited to Adobe Analytics, Facebook, Youtube, Twitter, Instagram etc. Familiarity with linear, SVOD, VOD, MVPD datasets a plus.

Additional Qualifications

Familiar with the data ingestion process via APIs, feeds, data warehouse, S3, FTP, etc.
Familiar with Domo or other BI tools a plus. Familiar with Tableau a plus
Experience with Excel utilizing advanced formulas, queries, plugins/add ons.
Experience with ETL tools, experience with SQL