FP&A; Analyst

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

📌 FP&A Manager-US Shift (Chennai)
🏢 Winfort
📍 Chennai