Financial Planning and Analysis Specialist

Role Overview

As a

Revenue Reporting Analyst , you will be responsible for ensuring accurate, timely, and insightful reporting of the company’s revenue performance. This role requires a strong analytical mindset, attention to detail, and close collaboration with cross-functional teams to ensure data accuracy, highlight trends, and support strategic business decisions.

Key Responsibilities

1. Daily & Monthly Revenue Reporting

Prepare, validate, and publish daily revenue performance reports with variance commentary.

Support monthly revenue freeze and closure activities ensuring all data is accurate and reconciled.

Maintain dashboards and trackers to provide real-time visibility into sales and revenue performance.

2. Revenue Data Validation & Reconciliation

Validate data across multiple systems (CRM, Finance, and Operations) to ensure consistency and completeness.

Identify revenue mismatches or discrepancies and work with relevant teams for resolution.

Reconcile gross and net revenue metrics with finance books and internal MIS.

3. Trend & Variance Analysis

Perform periodic trend analysis across channels, destinations, and product categories.

Highlight key drivers influencing revenue movement and support management with actionable insights.

Prepare detailed variance reports vs. forecast, plan, and prior periods.

4. Business Insights & Reporting

Generate structured MIS reports and dashboards for leadership review.

Provide analytical support for strategic decisions such as pricing, promotions, and product mix optimization.

Collaborate with FP&A and commercial teams to track revenue KPIs and performance ratios.

Skills & Attributes

Advanced Excel / Google Sheets skills (Pivot, Lookups, Conditional formulas, Automation).

Working knowledge of SQL for data extraction and validation (Optional).

Familiarity with BI tools (Power BI / Tableau / Looker) preferred (Optional).

Strong analytical, problem-solving, and data interpretation abilities.

High attention to detail with an ownership mindset.

Effective communication and cross-functional collaboration skills.

Performance Outcomes

Accuracy and timeliness of daily revenue reports.

Effectiveness in identifying data issues and driving resolutions.

Quality of business insights and variance commentary.

Contribution to improving revenue visibility and reporting automation.

Strong collaboration ensuring alignment between finance, sales, and operations.