Manager, Advanced Analytics Media
Publicis Groupe - Chicago, Illinois, United States, 60290Work at Publicis Groupe
Overview
- Apply
Overview
Stakeholder interviews/fact-finding to uncover client issuesPropose solution /analytical approach / methodology, with supporting rationaleManage project timeline throughout, escalating potential roadblocks when necessaryConduct modeling and analysesGenerate insightsFormulate strategic implications and recommendationsProduce easy-to-understand, error-free, and timely reportsDeliver final presentation of results
Effectively work across the advanced analytics/modeling lifecycle:
Definition of business questions and hypothesesData acquisition from different sources (ensuring adequacy, accuracy, and legitimacy of data)Data integration (merge, join, subset)Data preparation and cleanup (missing data, outlier detection, duplications)Model developmentConduct descriptive statistical and diagnostic techniques to determine model validity, accuracy and goodness-of-fit, such as: p-values, MAPE, Variance Inflation factor (VIF), Durbin-Watson, etc.Exploratory data analysisCreating and optimizing models including validation and interpretationData visualization (Excel, Tableau, R Shiny etc.)Insights generationCommunication of results in a clear and succinct fashion
Qualifications
Must Have:3+ years of work experience in a quantitative business environmentExperience in:
SAS, R or Python (Must have worked and created codes from scratch on several projects – not merely running someone else’s code by changing parameters)SQL (Must have worked and created codes from scratch on several projects – not merely running someone else’s code by changing parameters)
Experience working with various advanced statistical modeling and other forms of quantitative analysis
Experience in multi-variate regression in projects and understand regressions thoroughly
P-value, VIF, T-score, R2, MSE, Durbin-Watson should all be familiar terms
ETL processing
Knowledge of database structureExperience with data manipulation
Statistical/analytical software packages (SAS, R, Python) and coding/programming languages (SQL, Python)Proficiency in Microsoft Office, particularly Excel (have the ability to sort, analyze, import, export, clean data, work with pivot tables, and know how to do V and H lookups, etc.) and PowerPointNice to Have:Experience working with marketing mix modeling (MMM), (digital; TV, radio, OOH, etc.) attribution and measurement companies: including Neustar, MMA (IPSOS), Analytic Partners, Nielsen (mROI; Visual IQ), (m)PHASIZE (Publicis Media), Hudson River Group (HRG), Marketing Evolution, Google Attribution 360, Abakus (SAP), Conversion Logic, TVSquared, iSpot, C3 Metrics, Data Plus Math, IRI, etc.Business Intelligence (BI) / Visualization tool experience (Datorama, Domo, Tableau, Microstrategy, Microsoft Power BI, Data Studio)ETL tools (Alteryx)Experience working web analytics platforms (Adobe Analytics, Google Analytics, etc.)ETL processing
Knowledge of database structureExperience with data manipulation
Statistical/analytical software packages (SAS, R, Python) and coding/programming languages (SQL, Python)Proficiency in Microsoft Office, particularly Excel (have the ability to sort, analyze, import, export, clean data, work with pivot tables, and know how to do V and H lookups, etc.) and PowerPoint
#J-18808-Ljbffr