Campaign Analyst

OUTFRONT Media Inc.

Phoenix (AZ)

On-site

USD 60,000 - 75,000

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical, Dental, Vision
HSA and FSA plans
401(k) Employer Match
Paid Time Off
Robust Diversity, Equity and Inclusion

Job summary

OUTFRONT Media is seeking a Campaign Analyst to join the Proof of Performance (POP) monitoring and reporting team. You will analyze campaign data, generate reports, and help optimize campaign performance across multiple data sources.

The role requires 1+ years in SQL and VBA, strong Excel and PowerQuery skills, and the ability to work under tight deadlines. Experience with AWS, Python, and PowerBi is a plus in a fast-paced, advertiser-facing environment.

Qualifications

  • 1+ years of SQL and VBA experience.
  • Ability to work under tight deadlines.
  • Strong problem-solving and communication skills.

Responsibilities

  • Create reports and summarize data from multiple sources for POP reporting.
  • Test and verify data and processes.
  • Escalate campaign problems as needed.
  • Create clear reports and presentations.
  • Assist training users on POP systems and tools.
  • Collaborate with Manager on end-to-end solutions including analytics support.
  • Create and maintain ad hoc tools as needed.

Skills

SQL
VBA
Excel
Analytical thinking
Problem solving
Communication
Organization

Education

B.S. Computer Science, or equivalent work experience

Tools

PowerBi
PowerQuery
Python
AWS
Microsoft Fabric
PowerPoint
Word

Job description

About OUTFRONT

We are one of North America’s most innovative media companies. We leverage the power of creative excellence, unbeatable locations and smart audience data to change the game for advertisers. Our purpose as a company is to help people, places and businesses grow stronger. To do this, we make meaningful connections between brands and people when they are outside of their homes through one of the largest and most diverse sets of out-of-home assets including billboards, transit and mobile displays across the U.S. We connect diverse audiences across over 150 markets and conduct our business considering all our stakeholders, from clients and employees, to the communities where we operate. We are committed to creating a diverse and inclusive work environment that promotes the growth of our people. Come join our industry-leading team!


What We Offer

OUTFRONT offers a comprehensive benefits program including:

  • Medical, Dental, Vision (including same and opposite-sex domestic partners)
  • HSA and FSA plans, Family Benefits, Pet Benefits
  • 401(k) Plan with an Employer Match
  • Paid Time Off, Commuter Benefits, Educational Assistance
  • Robust Diversity, Equity and Inclusion program including 7 Employee Resource Groups (ERGs)

Your Role

OUTFRONT Media is looking for a Campaign Analyst to join the Proof of Performance (POP) monitoring and reporting team. The Campaign Analyst is responsible for analyzing campaign data and generating reports to manage campaign performance.


Your Responsibilities
  • Create Reports, analyze and summarize data from multiple sources to ensure accurate POP reporting
  • Test, challenge and verify data and processes
  • Escalate campaign problems
  • Create effective and succinct reports and presentations
  • Assist with training users on POP systems, reports, and tools
  • Partner with Manager to offer end-to-end solutions including process analysis and design, business case development, analytics support and administration support
  • Create, maintain and provide ad hoc tools as needed

Knowledge & Experience
  • 1+ years using SQL and VBA
  • Ability to successfully work under tight project deadlines
  • Demonstrate a repertoire of skills such as scheduling, prioritizing, organizing, planning, problem solving, decision-making, financial savvy, attention to detail, and follow through
  • Self-motivated, action-and-results oriented and be proactive in researching solutions
  • Well organized, effective communicator/presenter to groups of all sizes and levels of management
  • Strong interpersonal skills

Preferred Qualifications
  • B.S. Computer Science, or equivalent work experience in the requested field
  • Strong analytic capabilities
  • Advanced Excel and PowerQuery Skills
  • Knowledge of AWS, Microsoft Fabric, or similar platforms
  • Proficient with Python, SQL, PowerBi, PowerPoint, Word
  • Self-motivated with 2-3 years of related work experience
  • Experience in OOH advertising a plus
  • Ability to work within a dynamic, high pressure and fast-paced environment
  • Goal-oriented with excellent oral and written communication skills

For California only: The salary range for this role is $65,000 t0 $70,000. Compensation is determined during our interview process by assessing a candidate’s experience and skills relative to internal peers and market benchmarks evaluated for the scope and responsibilities of the position, and collective bargaining agreement terms. Please note that the foregoing compensation information is a good-faith assessment associated with this position only and is provided pursuant to the California Salary Transparency Law.


OUTFRONT Media Is An Equal Opportunity Employer


All applicants shall receive equal consideration without regard to race, color, religion, gender, marital status, gender identity or expression, sexual orientation, national origin, age, veteran status or disability.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Campaign Analyst
Campaign Analyst

Outfront Media • Los Angeles (CA)

On-site
USD 65,000 - 70,000
Medical, Dental, Vision
401(k) Plan with Employer Match
Paid Time Off
+2
Campaign Analyst
Campaign Analyst

OUTFRONT Media Inc. • Arizona

On-site
USD 65,000 - 70,000
Medical, Dental, Vision
HSA/FSA plans
401(k) Plan with Employer Match
+3
Campaign Analyst
Campaign Analyst

OUTFRONT Media, LLC • Phoenix (AZ)

On-site
USD 65,000 - 70,000
Medical
Dental
Vision
+7
Enterprise Account Executive - New Business Development
Enterprise Account Executive - New Business Development

OUTFRONT Media Inc. • Los Angeles (CA)

On-site
USD 105,000 - 150,000
Medical, Dental, Vision
HSA and FSA plans
401(k) with Employer Match
+4
Campaign Analytics Analyst
Campaign Analytics Analyst

Outfront Media • Los Angeles (CA)

On-site
USD 65,000 - 70,000
Medical, Dental, Vision
401(k) Plan with Employer Match
Paid Time Off
+2
Campaign Analytics Analyst: POP Reporting
Campaign Analytics Analyst: POP Reporting

OUTFRONT Media, LLC • Phoenix (AZ)

On-site
USD 65,000 - 70,000
Medical
Dental
Vision
+7
Associate Producer
Associate Producer

Outfront Media • New York (NY)

On-site
USD 80,000 - 85,000
Medical, Dental, Vision
401(k) with employer match
Paid Time Off
+3
Campaign Analytics Analyst - Data-Driven Performance
Campaign Analytics Analyst - Data-Driven Performance

OUTFRONT Media Inc. • Phoenix (AZ)

On-site
USD 60,000 - 75,000
Medical, Dental, Vision
HSA and FSA plans
401(k) Employer Match
+2
Enterprise Account Executive – New Business Development
Enterprise Account Executive – New Business Development

Outfront Media • Los Angeles (CA)

On-site
USD 105,000 - 150,000
Medical, Dental, Vision
401(k) Plan with Employer Match
Paid Time Off
+1
Sales Coordinator
Sales Coordinator

OUTFRONT • Boston (MA)

On-site
USD 37,000 - 39,000
Health benefits
HSA/FSA
401(k) match
+4