Campaign Analyst

OUTFRONT Media, LLC

Phoenix (AZ)

On-site

USD 65,000 - 70,000

Full time

7 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/FSA plans
Family benefits
401(k) Plan with Employer Match
Paid Time Off
Commuter Benefits
Educational Assistance
Diversity & Inclusion program

Job summary

OUTFRONT Media is seeking a Campaign Analyst to join the Proof of Performance monitoring and reporting team. The role focuses on analyzing campaign data and generating reports to manage campaign performance, using SQL and VBA to pull data from multiple sources.

You will test and verify data, escalate issues, and help train users on POP systems while collaborating with the Manager on end-to-end analytics solutions and ad hoc tools creation in a dynamic, fast-paced environment.

Qualifications

  • 1+ years using SQL and VBA.
  • Ability to meet tight project deadlines.
  • Strong scheduling, prioritizing, organizing and problem-solving skills.
  • Proactive in researching solutions and following through.
  • Effective communicator/presenter to groups of all sizes.

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.

Skills

SQL
VBA
Excel
Analytical thinking
Communication
Python

Education

BS Computer Science or equivalent

Tools

PowerBI
PowerPoint
Word
AWS
Microsoft Fabric

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
  • 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 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.

At OUTFRONT, we’re in the business of growing our people, the places we touch, and our partners’ businesses. As the most visible platform in America, we have a profound opportunity, and more importantly responsibility, to positively impact the people and businesses within the communities in which our canvases exist.

  • We are everywhere. We empower smart brands to take advantage of our ubiquity across 500,000 canvases, our national footprint across 25 top markets, and targeted relevance that can be achieved through our local dominance.
  • We are front and center in the places where people live, work, and travel; from urban centers, to busy highways, to transit hubs, to neighborhoods.
  • We provide the permanent in a media landscape overwrought with the transient. The IRL to fuel the URL. The confluence of, and flexibility between, screens. Truth, trust, and visibility.
  • We are Intelligent OOH. We leverage new technology to make OOH more relevant, responsive, and rewarding to make your existing digital investments work harder.

OUTFRONT. We Get You America.

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. • Phoenix (AZ)

On-site
USD 60,000 - 75,000
Medical, Dental, Vision
HSA and FSA plans
401(k) Employer Match
+2
Ship-In Specialist
Ship-In Specialist

OUTFRONT Media, LLC • Chicago (IL)

On-site
USD 60,000 - 90,000
Medical
Dental
Vision
+7
Sales Coordinator
Sales Coordinator

OUTFRONT Media, LLC • Detroit (MI)

On-site
USD 40,000 - 60,000
Medical benefits
Dental & Vision
401(k) Plan
+4
Sales Coordinator
Sales Coordinator

OUTFRONT Media, LLC • Los Angeles (CA)

On-site
USD 36,000 - 39,000
Medical, Dental, Vision
HSA and FSA plans
401(k) Plan
+3
Ship-In Specialist
Ship-In Specialist

Outfront Media • San Diego (CA)

On-site
USD 80,000 - 85,000
Medical benefits
Dental benefits
Vision benefits
+4
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
Associate Producer
Associate Producer

Outfront Media • City of Rochester (NY)

On-site
USD 80,000 - 85,000
Medical
Dental
Vision
+8
Sales Coordinator
Sales Coordinator

Outfront Media • New York (NY)

On-site
USD 36,000 - 39,000
Medical
Dental
Vision (including domestic partners)
+8
Charting Coordinator
Charting Coordinator

Outfront Media • Sacramento (CA)

On-site
USD 33,000 - 37,000
Medical
Dental
Vision
+6