Financial Planning and Analysis Specialist

Role Overview

Revenue Reporting Analyst

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.