Campaign Analyst

Outfront Media

Los Angeles (CA)

On-site

USD 65,000 - 70,000

Full time

7 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical, Dental, Vision
401(k) Plan with Employer Match
Paid Time Off
Commuter Benefits
Educational Assistance

Job summary

OUTFRONT Media in California is seeking a Campaign Analyst to join the Proof of Performance (POP) monitoring and reporting team. The role centers on analyzing campaign data and generating reports to manage campaign performance, partnering with the Manager on analytics solutions.

Responsibilities include creating reports from multiple sources, testing data accuracy, and delivering effective presentations. Ideal candidates possess SQL/VBA experience, strong Excel, and excellent communication

Qualifications

  • 1+ year of SQL and VBA experience required.
  • Strong analytical abilities and attention to detail.
  • Proficiency in Excel with PowerQuery and PowerBI skills preferred.
  • Solid communication and presentation capabilities.
  • Self-motivated and able to work under deadlines.

Responsibilities

  • Create reports and summarize data from multiple sources for POP reporting.
  • Test, verify, and validate data and processes.
  • Escalate campaign problems promptly as needed.
  • Produce concise reports and presentations for stakeholders.
  • Assist in training users on POP systems, reports, and tools.
  • Collaborate with the Manager to deliver end-to-end analytics solutions.

Skills

SQL & VBA
Analytical skills
Advanced Excel
Effective communicator
Problem solving

Education

B.S. Computer Science or equivalent

Tools

AWS
Microsoft Fabric
Python
PowerBi
PowerQuery
Excel
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 Inc. • Phoenix (AZ)

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

OUTFRONT Media, LLC • Phoenix (AZ)

On-site
USD 65,000 - 70,000
Medical
Dental
Vision
+7
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 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
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
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
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
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
Director of Product Management, Core Systems
Director of Product Management, Core Systems

Outfront Media • New York (NY)

On-site
USD 180,000 - 200,000
Medical, Dental, Vision
HSA & FSA
401(k) Employer Match
+4