Revenue FP&A Analyst
ExternalPrepare for this interview
EliteAI-generated questions, company research, and talking points tailored to this role
Benefits
Additional Information
Comcast Advertising is driving the TV advertising industry forward, from delivering ads to linear and digital audiences to pioneering the tech that makes it possible. We help brands connect with their audiences on every screen using advanced data, technology, and premium video content. Our media sales division helps local, regional, and national brands reach potential customers through multiscreen TV advertising. Our ad tech division FreeWheel provides comprehensive adtech that makes it easier to buy and sell premium video advertising across all screens, data types, and sales channels. Job Summary FreeWheel Finance needs a mission-driven, self-starting, quantitative thinker to own the initial calculation of several key monthly and quarterly revenue deliverables. This person must see challenges as opportunities and take initiative to explore issues to find innovative, scalable solutions. As a member of the FreeWheel Finance team, you will serve as a subject matter expert on your assigned revenue streams. You'll accomplish this by maintaining your assigned revenue models and ensuring their associated deliverables are performed on time and accurately. This role reports to the Manager, Finance. Job Description Core Responsibilities Revenue Close Support (Monthly) - Own the preparation and associated delivery of monthly revenue close deliverables for the international entities, including accrual calculations, journal entry preparation, and variance analysis - Execute revenue calculations and supporting schedules, ensuring accuracy and completeness prior to managerial review - Support monthly forecast and close activities by providing timely analysis of revenue performance and key drivers impacting current period results - Partner with FP&A and Accounting teams to ensure proper revenue recognition and accurate financial reporting Sales Commissions (Quarterly) - Support the quarterly commission process for approximately 110 employees across multiple regions and functions - Execute the consolidation and validation of commission inputs, including bookings, targets, plan mechanics, and revenue attainment calculations - Prepare individual commission calculation files and supporting documentation for managerial review - Maintain structured and auditable records to ensure consistency and transparency of commission calculations Data Management & Process Improvement - Maintain and update key revenue and commission mapping files, ensuring consistency and accuracy across reporting and calculation processes - Partner with cross-functional teams to improve data quality and support the transition toward more integrated and automated systems - Support the development and enhancement of reporting tools, dashboards, and automated processes that increase productivity and reporting efficiency Balance Sheet Reconciliation - Perform monthly reconciliation of revenue-related balance sheet accounts and investigate discrepancies to ensure timely resolution - Maintain clear, accurate , and well-documented reconciliation support files - Partner with Accounting teams to ensure balance sheet integrity and compliance with internal controls Ad Hoc Analysis & Special Projects - Support ad hoc financial analysis and reporting requests - Participate in special projects and process improvement initiatives as assigned - Provide analytical support to management and business partners to facilitate decision-making and operational effectiveness General Requirements / Skills and Qualifications: - Background in Accounting, Audit, or FP& A + 2years (studying towards a professional accounting qualification, ACCA, CIMA, ACA or equivalent, is an advantage) within a fast-paced and dynamic environment - Highly skilled in Excel and financial analysis, including experience working with large datasets, complex formulas, lookups, PivotTables, and data validation techniques; Power Query experience is a plus Employees at all levels are expected to: Understand our Operating Principles; make them the guidelines for how you do your job. Own the customer experience - think and act in ways that put our customers first, give them seamless digital options at every touchpoint, and make them promoters of our products and services. Know your stuff - be enthusiastic learners, users and advocates of our game-changing technology, products and services, especially our digital tools and experiences. Win as a team - make big things happen by working together and being open to new ideas. Be an active part of the Net Promoter System - a way of working that brings more employee and customer feedback into the company - by joining huddles, making call backs and helping us elevate opportunities to do better for our customers. Drive results and growth. Support a culture of inclusion in how you work and lead. Do what's right for each other, our customers, investors and our communities. Disclaimer: This information has been designed to indicate the general nature and level of wor