"Alerted.org

Company description

On the day Fallon opened its doors without a single client, it did so under the headline, “A new advertising agency for companies that would rather outsmart the competition than outspend them.” More than 40 years later, and this mantra is unwavering. We are a creatively-led agency who pinned our public reputation on our commitment to smarts. Smart brands create something of value in the world. Smart brands add to peoples’ lives and to culture; they help build ideas in the world, and they leave something behind. See fallon.com for more information and examples of our work.

Fallon strives to ensure diverse perspectives, backgrounds, and experiences are represented—and that everyone feels seen, heard, and has a sense of belonging. Whether that be through recruiting and retaining diverse talent, creating a dialogue around systemic issues and obstacles for diverse individuals, or ensuring our work reflects diverse perspectives, our efforts focus on enacting change through acknowledgment, education, accountability, action, and celebration.

Overview

The Media Measurement and Analytics team supports the planning and investment teams in the measurement, analysis, and actionable insight work for both digital and traditional paid media campaigns. We’re looking for a detail-oriented and data-savvy Data Operations Analyst to join our team. This role is ideal for someone who thrives in a fast-paced environment, loves solving data puzzles, and has deep expertise in SQL and Google BigQuery. You’ll be the backbone of our data infrastructure—ensuring data integrity, optimizing queries, and enabling teams across the company to make data-driven decisions.

Responsibilities

This role will leverage data mining, organization, and visualization skills to help develop and manage client-facing dashboards and presentation materials. These will be used to help communicate complex data in an easily digestible and action-oriented manner.

+ Develop, maintain, and optimize complex SQL queries and scripts for data extraction, transformation, and loading (ETL).

+ Work with infrastructure developer to manage and monitor API data pipelines (e.g., Snowflake, The Trade Desk) to BigQuery, ensuring timely and accurate data availability.

+ Conduct data cleansing and organization to support accurate creative and audience analytics, while maintaining scalable data infrastructures tailored to media content workflows and reports/dashboards.

+ Perform data quality checks, troubleshoot anomalies, and implement validation processes.

+ Maintain documentation for data processes, schemas, and workflows.

+ Support reporting needs by designing, developing, automating and maintaining reports with the aim of generating insights and fixes using BigQuery and connected BI tools (e.g., Looker, Tableau).

+ Identify opportunities for automation and performance improvements in data operations.

+ Willingness to fearlessly dive in and conduct analyses across various data sources to find insights and provide actionable recommendations to client and internal teams

+ Coordinate with team members to aggregate data, design custom reports, and present findings/related insights

+ Advise on pixel/tagging implementation

Qualifications

+ 2+ years of previous experience in a marketing analytics or business intelligence role.

+ Proficiency in Word/Excel/PowerPoint/Outlook

+ Strong written and verbal communication skills

+ Proficiency in SQL with experience writing complex queries and optimizing performance.

+ Hands-on experience with Google BigQuery in a production environment.

+ Experience with data mining and data visualization tools (e.g. Tableau, PowerBI, Google Data Studio, Google Big Query)

+ Working knowledge of media measurement & analytical tools (e.g. Google/Adobe Analytics, Google Campaign Manager, Facebook Ads, Google Ads, etc.)

+ Knowledge of digital media ecosystems and working knowledge of media buying platforms is a plus

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.

Compensation Range: $49,305 - $65,415 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. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. Temporary roles may also qualify for participation in our 401(k) plan after eligibility criteria have been met. For regular roles, 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 12/16/2025.

If you require accommodation or assistance with the application or onboarding process specifically, please contact [email protected]. All your information will be kept confidential according to EEO guidelines.

\#LI-JR2