Hybrid Reporting Analyst - Analytics at Mediabrands

Business Overview 

IPG Mediabrands is the media and marketing solutions division of Interpublic Group (NYSE: IPG). IPG Mediabrands manages over $47 billion in marketing investment globally on behalf of its clients across its full-service agency networks UM, Initiative and Mediahub and through its award-winning specialty business units Healix, Kinesso, MAGNA, Mediabrands Content Studio, Orion Holdings, Rapport, and the IPG Media Lab. IPG Mediabrands clients include many of the world’s most recognizable and iconic brands from a broad portfolio of industry sectors including automotive, personal finance, consumer product goods (CPG), pharma, health and wellness, entertainment, financial services, energy, toys and gaming, direct to consumer and e-commerce, retail, hospitality, food and beverage, fashion and beauty. The company employs more than 18,000 diverse marketing communication professionals in more than 130 countries. Learn more at www.ipgmediabrands.com. 

Position Summary

In this role, you will be a part of the centralized global office based in India and work closely with each of our markets globally to understand the client's communication objectives, access multiple data sources and visualize it using Tableau / Datorama, support on of ETL process using MSSQL / Alteryx Flow and has sound knowledge of Excel VBA.

Responsibilities

• Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards on the key drivers of our business.
• Partner with operations/business teams to consult, develop and implement KPIs, automated reporting/process solutions and data infrastructure improvements to meet business needs.
• Enable effective decision making by retrieving and aggregating data from multiple sources and compiling it into a digestible and actionable format.
• Manage on-time delivery of regular client reports including:
  • Building reports from data warehouse.
  • Review of completed reports for anomalies & discrepancies.
  • Troubleshooting data issues/discrepancies.
  • Ensure formatting & delivery parameters are met.
• Updating Tableau dashboards and Excel Dashboard as required for daily/weekly client reporting. 
• Investigate and understand the opportunities of new data sources in the context of integration into Tableau. 
• Updating Tableau/Excel/ or any similar dashboards for daily/weekly client reporting. 
• Support data cleansings & manipulation process including but not limited to:
  • Taxonomy classification
  • Conversion re-naming, grouping 
  • Removal of test/ghost impressions 

Required Skills & Experience

• Minimum 2+ years of experience in Analytics 
• Strong verbal/written communication and data presentation skills, including an ability to effectively communicate with both business and technical teams. 
• Hands on experience in creating complex Excel reports, SQL Queries joining multiple datasets 
• Data Visualization tools such as Quick Sight / Tableau / Power BI / Datorama 
• An ability and interest in working in a fast-paced, ambiguous and rapidly changing environment 
• Experience in developing requirements and formulating business metrics for reporting, familiarity with data visualization tools, e.g. Tableau, Power BI
• Willingness to work in night shifts

Desired Skills & Experience

Experience in Adtech industry will be preferred.