Marketing Operations Analyst

Marketing Operations Analyst

Industry: Fortune 500 Telecom company

Location: Philadelphia, PA (4 days onsite, 1 day remote)

Duration: contract until EOY (w/ potential for extension)

Pay rate: $26-$30/hr

Position Overview

Reporting to the Director of Resource & Workflow Operations, the Marketing Operations Analyst will support reporting, data analysis, workflow management, and operational initiatives across the Marketing and Creative organization. This role will primarily pull and analyze data from Workfront and other platforms, transform raw data into meaningful reporting, and identify trends, discrepancies, and insights related to projects, resources, and hours.

The ideal candidate is a highly organized, data-oriented analyst with strong Excel skills, experience working with project management or workflow systems, and an understanding of how creative and advertising teams operate. This person should be comfortable balancing multiple priorities while supporting reporting, project coordination, Workfront administration, and workflow troubleshooting.

Core Responsibilities

• Pull reporting and raw data from Workfront and other platforms to support Marketing and Creative operations.
• Clean, manipulate, organize, and analyze data in Excel to create clear and usable reports for stakeholders.
• Analyze resource and hours data to identify trends, discrepancies, potential issues, and actionable insights.
• Create and maintain recurring and ad hoc reporting to support resource planning, workflow management, and operational decision-making.
• Utilize Excel functions including pivot tables, VLOOKUP/XLOOKUP, formulas, and other data cleansing and manipulation techniques.
• Leverage AI tools to improve analysis, reporting, efficiency, and overall productivity.
• Support Workfront administration, reporting, workflow management, system data, and troubleshooting as needed.
• Identify and help resolve quality-control issues within workflows, reporting, and system data.
• Support project and workflow coordination across multiple Marketing and Creative projects, priorities, and stakeholders.
• Develop and maintain process documentation, instructions, and training materials as needed.
• Assist with operational process improvements and help prioritize workflow and reporting needs.
• Serve as a resource for Marketing teams regarding workflows, systems, reporting, and operational processes.
• Collaborate with Marketing, Creative, Project Management, and other cross-functional stakeholders to ensure accurate reporting and efficient workflows.

Required Skills & Experience

• Strong Excel skills, including pivot tables, VLOOKUP/XLOOKUP, formulas, data cleansing, and data manipulation .
• Experience analyzing raw data and translating it into meaningful reports, trends, and insights.
• Experience working with resource, capacity, hours, project, workflow, or operational data .
• Experience with Workfront strongly preferred ; experience pulling reports from a similar project management or workflow platform will also be considered.
• Experience using AI tools to support data analysis, reporting, or productivity.
• Strong organizational and project coordination skills with the ability to manage multiple projects, priorities, and stakeholders simultaneously.
• High attention to detail with a strong sense of accountability and follow-through.
• Ability to identify data or workflow discrepancies and assist with troubleshooting and resolution.
• Strong communication, listening, and interpersonal skills with the ability to collaborate across different teams and levels of the organization.
• Basic understanding of marketing, advertising, and creative agency workflows ; previous creative agency or marketing operations experience is preferred.
• Ability to learn new systems quickly and work effectively with data in a fast-paced environment.
• Proficiency with Microsoft Office applications, particularly Excel and Word ; experience with tools such as Workfront, SharePoint, OneDrive, Smartsheet, and Tableau is beneficial.

The salary range for this position is $26/hr to $30/hr. Benefits available to contract/temporary professionals, include medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information. Our specialized recruiting professionals apply their expertise and utilize our proprietary AI to find you great job matches faster.