FP&A Manager-US Shift

FP&A Analyst Job Description

PART A | Domain Skills & Responsibilities

1. Revenue Planning & Forecasting

• Maintain a rolling 24-month revenue forecast across subscriber, newsstand, advertising (print + digital), and CPG/retailer streams refreshed weekly from automated data feeds.
• Build and update subscriber revenue models applying churn, growth, and rate-tier assumptions across all newspaper and magazine titles.
• Gather weekly qualitative intelligence from ad managers and division directors; layer onto statistical base forecasts.
• Forecast weekly copy volumes across multiple stores and multiple publishers using secular-decline baselines seasonal indices, and merchandiser capacity constraints.

2. Annual Budgeting

• Own the full budget cycle — kickoff through lock-down — across necessary back n forth iteration rounds for the BU’s build input templates, consolidate submissions, and present to senior leadership.
• Build line-by-line headcount and compensation budgets from payroll exports, covering all employee types including temp-agency DC labor.
• Produce departmental opex budgets from AP actuals and contract-change inputs; build COGS, D&A, and newsprint cost models.
• Run the freight model against volume assumptions (box-consolidation optimization); build and negotiate the store-level merchandising budget with external vendors.

3. Variance Analysis & Reporting

• Pull month-end actuals; build bridge schedules and draft tailored variance narratives for each BU leadership/ executive
• Compile and publish the weekly leadership slide deck — actuals vs. forecast and 24-month forward view — plus the CFO KPI metrics deck (20+ metrics) for board cycles.
• Process outside-printing reconciliations (12–15 vendors), advertising commission statements, and royalty agreements (~31 SIP partners) monthly.
• Review POs; validate G/L codes, approver chains, and budget alignment; support period-close journal-entry creation as needed.

4. Scenario Planning & Ad-Hoc Analysis

• Model leadership-directed scenarios — subscriber repricing, ad-channel rationalization, headcount restructuring, publisher volume cuts — accounting for non-linear cost responses.

PART B | Technology Literacy

Data & Analytics

• Snowflake — navigate schemas; read and modify SQL queries across revenue and cost pipelines
• Sigma Computing — build/modify dashboards, self-serve reports, and store-level drill-downs
• Google Sheets / Apps Script — advanced modelling, scenario toggles, macro automation

Planning & ERP

• Adaptive Insights — budget/forecast load, lock-down workflow, Office Connect actuals pull
• NetSuite — GL account mapping, report extraction, summary budget uploads
• D365 — dual-entity coding for MRN operating units alongside NetSuite

Revenue & Ops Systems

• NCS — subscriber management data via Snowflake feed
• Naviga Ad — ad revenue actuals by channel (print + digital)
• Computac / Magcor — MRN weekly distribution volume feeds
• SAP — CPG retailer revenue feed into Sigma
• UKG — payroll data export for headcount modelling

Workflow & Collaboration

• Tipalti — PO review, approval workflow, G/L validation
• Google Workspace — Slides, Docs, Drive, Meet as primary output layer
• Adaptive Office Connect — live actuals pull into Sheets/Excel
• SQL (read/modify) — interpret and adjust queries; production code not required