Publicis Groupe - New York, NY

posted 2 months ago

Full-time - Mid Level
New York, NY
Professional, Scientific, and Technical Services

About the position

As a Senior Analyst on the Data Operations team at Publicis Media Exchange (PMX), you will play a crucial role in building a robust foundation of reporting and analytics. Your primary responsibility will be to assist both internal and external clients in making informed decisions by leveraging data-driven techniques. This position is inherently cross-functional, requiring you to generate end-to-end insights while managing various resources to streamline structured processes. A key focus of this role is to drive bottom-line growth by ensuring operational efficiencies across the board. In this role, you will utilize your strong technical skills in relational databases and API data extraction, along with programming expertise in analytics software such as R or Python. You will be tasked with automating data pipelines and creating visually appealing, analytically profound, and easy-to-understand visualizations using tools like Tableau. These visualizations will help tell compelling stories and provide actionable recommendations to optimize key performance indicators for end-users. To excel in this position, you will need a combination of sound technical knowledge and outstanding soft skills, enabling you to effectively communicate complex analytical findings to diverse audiences, from executives to team members. Your contributions will not only enhance the analytical capabilities of the team but also support the overall mission of PMX in executing data-informed, tech-enabled media strategies.

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, and campaign management teams to define, plan, and 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 to the discovery and expansion of new and existing methodologies, tools, and algorithms
  • Manage relational databases to organize, store, and process clean data prepared for internal and client stakeholders
  • Manage, coach, and train offshore reporting and analytics resources to ensure outlined project tasks are fulfilled and solid communication with key stakeholders is maintained
  • Communicate and present analytical findings and recommendations to audiences ranging from executives to working-level team members

Requirements

  • 2+ years of experience in Data Analytics, proficiency with analytics software and related education
  • Undergraduate degree in Math, Analytics/Business Intelligence, Statistics or other quantitative related field
  • Preferred Graduate degree in Analytics, Statistics, Business Intelligence or related field
  • Preferred 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, particularly Excel skills (Macros, Pivot Tables, Power Pivot)
  • Alteryx data cleansing/pipelining is a plus
  • Excellent quantitative and analytical skills including pipelining, cleansing, structuring, manipulating, automating, and analyzing data of various types
  • Experience in analytics and report scheduling / automation using tools ranging from Alteryx / Databricks / Crontab / Stored Procedures

Nice-to-haves

  • Experience with Alteryx for data cleansing and pipelining
  • Familiarity with Big Data cloud environments
  • Experience in managing offshore resources

Benefits

  • Comprehensive health insurance
  • Dental insurance
  • Vision insurance
  • Disability insurance
  • 401k matching
  • Paid time off
  • Tuition reimbursement
  • Access to Business Resource Groups
  • Mentorship programs
  • Wellness and enrichment programming
  • Extensive benefits for caregivers and new parents
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service