Marketing Operations Analytics Resource

About the Role: Marketing Operations Analytics Resource at Braintrust

As a Marketing Operations Analytics Resource, you will play a crucial role in enhancing Braintrust's marketing effectiveness by transforming raw data into actionable insights. This 1-month contract position, with potential for extension, focuses on consolidating, auditing, and reporting marketing project data to provide clear visibility for leadership and improve operational processes.

Key Responsibilities

• Consolidate and normalize marketing intake and project data from Workfront and Excel into a single, reliable reporting dataset, resolving inconsistencies in project IDs, markets, timelines, and status.
• Audit all intake forms to differentiate planned vs. unplanned work, flagging requests that bypassed standard intake processes or were added midstream without approved scope, timing, or resourcing adjustments.
• Identify and report on missed submission dates where deadlines were not formally shifted, highlighting downstream impacts to schedules, resourcing, and delivery timelines.
• Track creative revision cycles by project, surfacing work that exceeds the standard three rounds of creative development and quantifying the incremental effort tied to additional rounds.
• Produce a total project count view, broken down by market, request type, and priority, enabling leadership to clearly see demand distribution and workload drivers.
• Calculate and report estimated hours by market, comparing projected effort against available creative and production capacity to highlight over-allocation, underutilization, and potential resourcing gaps.
• Develop a repeatable stakeholder-facing report (dashboard or structured summary) that translates operational data into clear insights on volume, variance, and risk—designed for monthly or quarterly review.
• Identify systemic intake or process breakdowns (e.g., chronic late submissions, high-revision markets) and provide data-backed recommendations to improve intake discipline and workload forecasting.
• Partner with marketing operations and project management leads to validate assumptions, refine definitions (e.g., “unplanned,” “missed,” “out of scope”), and ensure reporting aligns with how teams actually work.
• Document data definitions, logic, and reporting methodology to support consistency, transparency, and handoff at the end of the contract engagement.

Timeframe & Required Outcome

This is a 1-month contract, with potential for extension. The primary outcome is a leadership-ready dashboard, clearly and easily presenting key metrics that deliver visibility for objective management. The dashboard must be built for continuous use and management by internal teammates.

Key skills/competency

• Data Consolidation
• Data Normalization
• Workfront
• Excel Data Analysis
• Marketing Operations
• Project Data Reporting
• Dashboard Development
• Process Improvement
• Stakeholder Communication
• Analytical Thinking