Campaign Analyst

OUTFRONT Media

. Analyze campaign data and generate reports to manage campaign performance .

Posted 11/12/2026full-timeUnited StatesJunior💰 $65,000 - $70,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates strong analytical capabilities and proficiency in SQL, VBA, and advanced Excel for data analysis and reporting. Effective communicator with the ability to create succinct reports and presentations while managing campaign performance in a fast-paced environment.

Highest-signal resume keywords

SQL ProficiencyVBA ProficiencyAdvanced Excel SkillsAnalytical CapabilitiesEffective Communication Skills

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLVBAAdvanced ExcelPowerQueryPythonPowerBiData AnalysisCampaign Performance ReportingProcess AnalysisBusiness Case Development

Soft Skills

Problem SolvingDecision-MakingAttention to DetailSelf-MotivatedOrganizational Skills

Tools & Technologies

AWSMicrosoft FabricPowerPointWord

Industry Keywords

OOH AdvertisingProof of Performance ReportingCampaign Management

Tech Stack

Tools & technologies

AWSPythonSQLVBA

About the role

Key responsibilities & impact

Analyze campaign data and generate reports to manage campaign performance
Create, analyze, and summarize data from multiple sources for accurate Proof of Performance reporting
Test, challenge, and verify data and processes
Escalate campaign problems
Create effective and succinct reports and presentations
Assist with training users on Proof of Performance systems, reports, and tools
Partner with the Manager to provide 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

Requirements

What you’ll need

1+ years using SQL and VBA
Ability to successfully work under tight project deadlines
Skills in scheduling, prioritizing, organizing, planning, problem solving, decision-making, financial savvy, attention to detail, and follow through
Self-motivated, action-and-results oriented and proactive in researching solutions
Well organized, effective communicator/presenter to groups of all sizes and levels of management
Strong interpersonal skills
B.S. Computer Science, or equivalent work experience in the requested field (preferred)
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 (preferred)
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

Benefits

Comp & perks

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)