Publicis Media Exchange (PMX) is looking to build a robust foundation of reporting and analytics to help internal and external clients make better decisions by taking advantage of known data-driven techniques, and drive bottom-line growth through ensuring operational efficiencies.
Requirements
- Fluency in SQL with strong understanding of relational database constructs
- Proficiency in programming software (Python)
- Proficiency with data visualization tools such as PowerBI / Tableau
- Proficiency with MS Office products in particular Excel skills (Macros, Pivot Tables, Power Pivot)
- Alteryx data cleansing/pipelining is a plus
- Preferred Experience with platforms such as Display Platforms (DV360, The Trade Desk), Social Platforms (Facebook / Instagram / Tiktok), Search Platforms (Google / Bing), Big Data cloud environments and other similar CRM platforms
- Preferred Experience in AWS tools such as S3, Redshift, Lambda, Amazon WorkMail, EC2
Responsibilities
- Lead reporting / analytical end-to-end project initiatives including project management, executive communication, defining deliverables, designing data pipelines, task delegation, resource management
- Develop data pipelines with processes ranging from mining, extracting, cleansing, transforming to building automatable reporting and analytics dashboards
- Deliver complex actionable analytical solutions involving heavy data sets
- Contribute in the discovery and expansion of new and existing methodologies, tools, and algorithms
- Manage limited data engineering initiatives including setup relational databases, store, process clean data
- Manage / coach / train offshore reporting and analytics resources to ensure already outlined project tasks are fulfilled and solid communication with key stakeholders is taking place
- Communicate / present analytical findings and recommendations to audiences ranging from executives to working level team members
Other
- Excellent verbal and written communication skills, able to share technical results and recommendations to audiences at varying levels of analytic understanding
- Undergraduate degree in Math, Analytics/Business Intelligence, Statistics, Software Engineering or other quant related field
- 2+ years of experience in Data Analytics or Data Engineering, proficiency with analytics software and related education
- Preferred Graduate degree in Statistics, Business Intelligence, Software Engineering or related field
- Excellent quantitative and analytical skills including pipelining, cleansing, structuring, manipulating, automating, and analyzing data of various types
