Marketing Operations Analytics Contractor

Marketing Operations Analytics Contractor

As a Marketing Operations Analytics Contractor, you will play a crucial role in enhancing visibility and insights into Braintrust's marketing operations. This contract position focuses on consolidating and analyzing key data to drive informed decision-making and optimize marketing processes.

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

This is a 1-month contract, with possibility for extension pending scope changes.

Required Outcome

• Leadership-ready dashboard, clearly and easily presenting key metrics that deliver visibility for objective management.
• Dashboard must be built for continuous use and management by internal teammates.

Key skills/competency

• Data Consolidation
• Workfront Expertise
• Excel Data Analysis
• Marketing Operations
• Project Data Management
• Reporting & Dashboarding
• Data Auditing
• Capacity Planning
• Process Improvement
• Stakeholder Communication