Senior Analyst Data Operations, Central Activation
Publicis Media · New York, NY · 4 wk ago
HybridInformation Technology$73k/yrFull-time
Responsibilities
- Lead reporting / analytical end-to-end project initiatives including project management, executive communication, defining deliverables, designing data pipelines, task delegation, resource management
- Collaborate with agency, product, campaign management teams to define, plan, delegate processes for end deliverables
- 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 relational databases to organize, store, process clean data prepared for internal and client stakeholders
- 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
Qualifications
- 2+ years of experience in Data Analytics, proficiency with analytics software and related education
- Undergraduate degree in Math, Analytics/Business Intelligence, Statistics or other quant related field
- PREFERRED: Graduate degree in Analytics, Statistics, Business Intelligence or related field
Skills
- Experience with platforms such as Adobe Analytics, Google Analytics, Social Platforms (Facebook / Twitter etc.), Big Data cloud environments and other similar CRM platforms
- 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)
- Alyyx data cleansing/pipelining is a plus
- Experience implementing and supporting data platforms to support internal stakeholders and clients
- Excellent quantitative and analytical skills including pipelining, cleansing, structuring, manipulating, automating, and analyzing data of various types
- Excellent verbal and written communication skills, able to share technical results and recommendations to audiences at varying levels of analytic understanding
- Experience in analytics and report scheduling / automation using tools ranging from Alteryx / Databricks / Crontab / Stored Procedures