Publicis Media
Manager Advanced Analytics Media
Publicis Media, Chicago, Illinois, United States, 60290
Job Description
Is this the next step in your career Find out if you are the right candidate by reading through the complete overview below.Overview:
Can help evolve the Data Sciences/Advanced Analytics/Modeling capability within the practice
Can help provide expertise on Advanced Analytics/Modeling techniques to enhance our capabilities and bring new opportunities, approaches, ideas, perspectives, etc. to clients.
Has a combination of advanced analytical/modeling expertise, business acumen, a strategic/ technical mindset, client relationship and project management proficiency, together with a passion for building new capabilities
Can structure ambiguous problems, own and drive projects from start to finish, apply sound business judgment, and communicate complex information effectively
Has a genuine curious nature, desire to dive deep in the numbers to discover context and make the business case, and goes beyond usual approaches to solve problems and seize opportunities
Has the willingness to “have an opinion” backed up by insight and analytics and the confidence to influence key stakeholders in meetings
Role Objectives:
Work with complex data structures, cleanse data, and perform statistical analyses such as: marketing mix models (MMM), digital multi-touch attribution (MTA), TV attribution, media response analysis, time series analysis, predictive modeling, cluster analysis, user overlap analysis, path to conversion analysis, website analytics, lifetime value (LV) analysis, discrete choice/conjoint analysis, latent class & other clustering techniques (segmentations), multivariate & logistic regressions (ex. multivariate creative analysis), decision trees (e.g. CHAID/CART), factor & correspondence/MDS analysis, simulation & optimization, forecasting, etc.
Leverage advanced analytic techniques to drive marketing performance (ex. site traffic, application volume, conversion rates, CPA, revenue, ROAS, LTV, etc.), isolate key KPI trends and performance pacing, optimize consumer online/offline experiences, predict consumer behaviors, maximize sales conversion, drive optimizations (across media investment and mix, target audiences, and creative messages) and forecast critical business outcomes
Support senior team members in advanced analytics engagements from start-to-finish, including:
Stakeholder interviews/fact-finding to uncover client issues
Propose solution /analytical approach / methodology, with supporting rationale
Manage project timeline throughout, escalating potential roadblocks when necessary
Conduct modeling and analyses
Generate insights
Formulate strategic implications and recommendations
Produce easy-to-understand, error-free, and timely reports
Deliver final presentation of results
Effectively work across the advanced analytics/modeling lifecycle:
Definition of business questions and hypotheses
Data 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 development
Conduct 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 analysis
Creating and optimizing models including validation and interpretation
Data visualization (Excel, Tableau, R Shiny etc.)
Insights generation
Communication of results in a clear and succinct fashion
Qualifications:Qualifications
Must Have:
3+ years of work experience in a quantitative business environment
Experience 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 structure
Experience 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
Nice 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)
Experienced working with aggregate, cookie, user-, and event-level datasets and ad/mar technologies like:
* Ad Servers (Google/DCM, Innovid, Flashtalking, etc.)
Programmatic Media & Exchanges (DSPs, DMPs, SSPs, etc.)
Marketing Clouds (Adobe, Salesforce, Oracle, SAP Hybris, IBM, etc.)
Digital & Broadcast Analytics (Google, Adobe, Mixpanel, comScore, Quantcast, Nielsen, etc.)
ETL tools (Alteryx)
Web Analytics (Google Analytics, Adobe Analytics, etc.)
Experience working web analytics platforms (Adobe Analytics, Google Analytics, etc.)
ETL processing
Knowledge of database structure
Experience 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
Additional Information
All your information will be kept confidential according to EEO guidelines.
24-8994
Qualifications
**Must Have:**
* 3+ years of work experience in a quantitative business environment* Experience 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 structure* Experience 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
**Nice 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)* Experienced working with aggregate, cookie, user-, and event-level datasets and ad/mar technologies like:* * Ad Servers (Google/DCM, Innovid, Flashtalking, etc.)* Programmatic Media & Exchanges (DSPs, DMPs, SSPs, etc.)* Marketing Clouds (Adobe, Salesforce, Oracle, SAP Hybris, IBM, etc.)* Digital & Broadcast Analytics (Google, Adobe, Mixpanel, comScore, Quantcast, Nielsen, etc.)* ETL tools (Alteryx)* Web Analytics (Google Analytics, Adobe Analytics, etc.)* Experience working web analytics platforms (Adobe Analytics, Google Analytics, etc.)* * ETL processing* Knowledge of database structure* Experience 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
Additional Information
All your information will be kept confidential according to EEO guidelines.
**24-8994**
#J-18808-Ljbffr
Is this the next step in your career Find out if you are the right candidate by reading through the complete overview below.Overview:
Can help evolve the Data Sciences/Advanced Analytics/Modeling capability within the practice
Can help provide expertise on Advanced Analytics/Modeling techniques to enhance our capabilities and bring new opportunities, approaches, ideas, perspectives, etc. to clients.
Has a combination of advanced analytical/modeling expertise, business acumen, a strategic/ technical mindset, client relationship and project management proficiency, together with a passion for building new capabilities
Can structure ambiguous problems, own and drive projects from start to finish, apply sound business judgment, and communicate complex information effectively
Has a genuine curious nature, desire to dive deep in the numbers to discover context and make the business case, and goes beyond usual approaches to solve problems and seize opportunities
Has the willingness to “have an opinion” backed up by insight and analytics and the confidence to influence key stakeholders in meetings
Role Objectives:
Work with complex data structures, cleanse data, and perform statistical analyses such as: marketing mix models (MMM), digital multi-touch attribution (MTA), TV attribution, media response analysis, time series analysis, predictive modeling, cluster analysis, user overlap analysis, path to conversion analysis, website analytics, lifetime value (LV) analysis, discrete choice/conjoint analysis, latent class & other clustering techniques (segmentations), multivariate & logistic regressions (ex. multivariate creative analysis), decision trees (e.g. CHAID/CART), factor & correspondence/MDS analysis, simulation & optimization, forecasting, etc.
Leverage advanced analytic techniques to drive marketing performance (ex. site traffic, application volume, conversion rates, CPA, revenue, ROAS, LTV, etc.), isolate key KPI trends and performance pacing, optimize consumer online/offline experiences, predict consumer behaviors, maximize sales conversion, drive optimizations (across media investment and mix, target audiences, and creative messages) and forecast critical business outcomes
Support senior team members in advanced analytics engagements from start-to-finish, including:
Stakeholder interviews/fact-finding to uncover client issues
Propose solution /analytical approach / methodology, with supporting rationale
Manage project timeline throughout, escalating potential roadblocks when necessary
Conduct modeling and analyses
Generate insights
Formulate strategic implications and recommendations
Produce easy-to-understand, error-free, and timely reports
Deliver final presentation of results
Effectively work across the advanced analytics/modeling lifecycle:
Definition of business questions and hypotheses
Data 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 development
Conduct 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 analysis
Creating and optimizing models including validation and interpretation
Data visualization (Excel, Tableau, R Shiny etc.)
Insights generation
Communication of results in a clear and succinct fashion
Qualifications:Qualifications
Must Have:
3+ years of work experience in a quantitative business environment
Experience 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 structure
Experience 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
Nice 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)
Experienced working with aggregate, cookie, user-, and event-level datasets and ad/mar technologies like:
* Ad Servers (Google/DCM, Innovid, Flashtalking, etc.)
Programmatic Media & Exchanges (DSPs, DMPs, SSPs, etc.)
Marketing Clouds (Adobe, Salesforce, Oracle, SAP Hybris, IBM, etc.)
Digital & Broadcast Analytics (Google, Adobe, Mixpanel, comScore, Quantcast, Nielsen, etc.)
ETL tools (Alteryx)
Web Analytics (Google Analytics, Adobe Analytics, etc.)
Experience working web analytics platforms (Adobe Analytics, Google Analytics, etc.)
ETL processing
Knowledge of database structure
Experience 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
Additional Information
All your information will be kept confidential according to EEO guidelines.
24-8994
Qualifications
**Must Have:**
* 3+ years of work experience in a quantitative business environment* Experience 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 structure* Experience 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
**Nice 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)* Experienced working with aggregate, cookie, user-, and event-level datasets and ad/mar technologies like:* * Ad Servers (Google/DCM, Innovid, Flashtalking, etc.)* Programmatic Media & Exchanges (DSPs, DMPs, SSPs, etc.)* Marketing Clouds (Adobe, Salesforce, Oracle, SAP Hybris, IBM, etc.)* Digital & Broadcast Analytics (Google, Adobe, Mixpanel, comScore, Quantcast, Nielsen, etc.)* ETL tools (Alteryx)* Web Analytics (Google Analytics, Adobe Analytics, etc.)* Experience working web analytics platforms (Adobe Analytics, Google Analytics, etc.)* * ETL processing* Knowledge of database structure* Experience 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
Additional Information
All your information will be kept confidential according to EEO guidelines.
**24-8994**
#J-18808-Ljbffr