Freelance Power Query Jobs (NOW HIRING)

About OUTFRONT

We build brands in the real world! As one of 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 media powers brands to break through, be relevant, and connect with audiences like never before.

OUTFRONT understands its role in driving cultural impact. We are embedded into the fabric of our communities and trusted by the millions who engage with our media every day, driving a strong relationship between brands and audiences.

We are leading the industry, bringing intelligence to out of home by deploying digital at scale and embracing new technologies. 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 is seeking a datadriven, operationally minded Photography Field Operations Manager to lead theplanning, optimization, and delivery of highquality visual assets. This role is ideal for someone with a stronganalytical background, advanced Excel skills, and a passion for building efficient, scalable logistics workflows.Equally important, this person must be a strong peopleperson and natural facilitator-skilled at building trust,guiding conversations, and fostering collaboration across teams and with freelance photographers.

You will play a central role in evolving OUTFRONT's photography operations by enhancing schedulingsystems, improving data visibility, and leveraging automation tools-including Power Automate, AIassistedrouting, and workflow integrations-to increase speed, accuracy, and market coverage. This position partnersclosely with Regional Management and the Operations Quality Manager to develop KPIs, analyzeperformance, and uncover databacked opportunities for operational improvement. With deep knowledge ofOUTFRONT inventory and market dynamics, you will shape longterm strategy, strengthen asset managementprocesses, and champion continuous improvement initiatives that support automation, scalability, and futuregrowth.

Key Responsibilities
Lead the optimization of the Photographer Scheduler and related systems, with a focus on datamodeling, Excelbased analysis, and integration of AIenhanced routing, forecasting, and resource
allocation.
Build and automate workflows using tools such as Power Automate, SharePoint, and other lowcodesolutions to streamline scheduling, asset intake, and communication processes.
Identify and implement process efficiencies that improve operational speed, accuracy, and marketcoverage.
Oversee the planning and prioritization of photo and video capture in partnership with Sales, Marketing,Operations, and other crossfunctional teams, acting as a facilitator who ensures alignment, clarity, andsmooth communication.
Codevelop KPIs and performance dashboards with Regional Management, ensuring alignment withbusiness priorities and market needs.
Monitor operational performance, analyze trends, and recommend datadriven improvements toenhance productivity and coverage.
Serve as a strategic partner in shaping the longterm vision for photography operations, technologyadoption, and workflow evolution.
Guide internal teams and freelance photographers to ensure timely, highquality coverage aligned withclient expectations and campaign timelines, leveraging strong interpersonal skills to motivate, support,and influence others.
Develop deep expertise in OUTFRONT inventory to support strategic route planning, forecasting, andproactive coverage recommendations.
Oversee the review, validation, and organization of incoming visual assets to ensure accuracy,consistency, and adherence to quality standards.
Drive continuous improvement initiatives that position OUTFRONT's photography program for scale,automation, and future growth.

Your Qualifications
Strong leadership, communication, and operational strategy skills; must be an effective facilitator andrelationshipbuilder who thrives in collaborative environments.
Advanced proficiency in Excel (pivot tables, Power Query, complex formulas, data modeling) andcomfort working with large datasets.
Experience with workflow automation tools such as Power Automate, or similar platforms.
Experience with digital asset management systems; familiarity with Adobe Creative Suite is a plus.
Proven ability to manage complex logistics workflows in a fastpaced, deadlinedriven environment.
Detailoriented, proactive, and passionate about operational efficiency and datasupporteddecisionmaking.
2-5 years of experience in operations, data analysis, logistics coordination, creative operations, or a related field.

The salary range for this role is $70,000-$75,000 per year. 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. Please note that the foregoing compensation information is a good-faith assessment associated with this position only and is provided pursuant to the New York City Salary Transparency Law.

OUTFRONT Media is not responsible for any fees related to unsolicited resumes.

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. Please refer to the OUTFRONT Media Affirmative Action policy statement.