Contract Marketing Analytics Specialist

Overview

As a Contract Marketing Analytics Specialist at Braintrust, you will play a crucial role in enhancing the visibility and efficiency of marketing operations. This 1-month contract, with potential for extension, focuses on transforming raw marketing data into actionable insights and a leadership-ready dashboard.

Key Responsibilities

• Consolidate and normalize marketing intake and project data from Workfront and a supplemental Excel planning worksheet into a single, reliable reporting dataset, resolving inconsistencies in project IDs, markets, timelines, and status fields.
• 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 & Outcome

This is a 1-month contract, with possibility for extension pending scope changes. The required outcome is a leadership-ready dashboard, clearly and easily presenting key metrics that deliver visibility for objective management. The dashboard must be built for continued use and management by internal teammates.

Key skills/competency

• Data Consolidation
• Data Normalization
• Workfront
• Excel Analysis
• Reporting Development
• Process Auditing
• Marketing Operations
• Data Visualization
• Stakeholder Communication
• Project Management Support