Senior Analyst Data Operations, Central Activation

Publicis Groupe; New York, Providence (NY, RI); On-site; USD 73,000 - 117,000; Full time

Job summary

A leading company in the media sector is seeking a Senior Analyst for their Data Operations team. This role involves building robust reporting systems and providing actionable insights to internal and external clients. Candidates should possess strong technical skills in data analytics and programming, along with excellent communication abilities. The position offers competitive compensation and a comprehensive benefits package, fostering an inclusive work environment.

Benefits

Medical coverage

Dental

Vision

Disability

401K

Paid time off

Tuition reimbursement

Qualifications

• 2+ years of experience in Data Analytics or Data Engineering.
• Proficiency with analytics software and related education.

Responsibilities

• Lead reporting and analytical project initiatives.
• Develop data pipelines and automate reporting dashboards.
• Communicate analytical findings to various audiences.

Skills

SQL

Python

Data Visualization

Analytical Skills

Education

Undergraduate degree in Math

Graduate degree in Statistics

Tools

Tableau

PowerBI

Alteryx

AWS

Job description

Company Description

Publicis Media Exchange (PMX) is the global media platform for Publicis Groupe [Euronext Paris FR0000130577, CAC 40]. PMX is an omnichannel activation powerhouse that drives smart application of investment through leveraging scale, marketplace innovation, deeper partnerships and intelligence. PMX is at the forefront of the converging marketplace executing data-informed, tech-enabled media to help marketers connect with consumers in a measurable way.

Job Description

As a Senior Analyst on the Data Operations team, you will help our team build a robust foundation of reporting and analytics and help internal and external clients make better decisions by taking advantage of known data-driven techniques. This role is cross-functional in nature as not only will you be responsible for generating end-to-end insights but also will be managing several resources to take on already structured processes. In addition, one of the most important requirements is driving bottom-line growth through ensuring operational efficiencies.

The candidate must have strong technical skills in relational databases, API data extraction, programming in various analytics software such as R or Python, automate data pipelines, build aesthetic / analytically profound / easy to understand visualizations using software such as Tableau to tell stories and provide recommendations that can help end-users to optimize on their key performance indicators.

In order to succeed the candidate must have sound technical knowledge as well as outstanding soft skills.

Responsibilities

• Lead reporting / analytical end-to-end project initiatives including project management, executive communication, defining deliverables, designing data pipelines, task delegation, resource management
• Collaborating 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 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

Qualifications

Education:

• 2+ years of experience in Data Analytics or Data Engineering, proficiency with analytics software and related education
• Undergraduate degree in Math, Analytics/Business Intelligence, Statistics, Software Engineering or other quant related field
• Preferred Graduate degree in Statistics, Business Intelligence, Software Engineering or related field

Skills:

• 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
• 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 in AWS tools such as S3, Redshift, Lambda, Amazon WorkMail, EC2

Experience:

• Excellent quantitative and analytical skills including pipelining, cleansing, structuring, manipulating, automating, and analyzing data of various types
• Have applied analytics and reporting experience implementing and supporting data platforms to support internal stakeholders and clients
• Excellent verbal and written communication skills, able to share technical results and recommendations to audiences at varying levels of analytic understanding.
• Experience in report scheduling / automation using tools ranging from Alteryx / Databricks / Crontab / Stored Procedures

Additional Information

Our Publicis Groupe motto “Viva La Différence” means we’re better together, and we believe that our differences make us stronger. It means we honor and celebrate all identities, across all facets of intersectionality, and it underpins all that we do as an organization. We are focused on fostering belonging and creating equitable & inclusive experiences for all talent.

Publicis Groupe provides robust and inclusive benefit programs and policies to support the evolving and diverse needs of our talent and enable every person to grow and thrive. Our benefits package includes medical coverage, dental, vision, disability, 401K, as well as parental and family care leave, family forming assistance, tuition reimbursement, and flexible time off.

If you require accommodation or assistance with the application or onboarding process specifically, please contact [e-mail].

All your information will be kept confidential according to EEO guidelines.

Compensation Range: $73,910 - $116,380 annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. For this role, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 04/20/2025