Job Description
The Job
WarnerMedia seeks a Senior Financial Analyst for the Financial Planning & Analysis department. Drives data consolidation, reconciliation and financial schedule across multiple product lines and business units for monthly close & forecast cycles including Long Term Plan. High focus on developing and improving financial data models in order to efficiently run recurring data queries. Will often work directly with other FP&A and Finance Technology groups in order to create customized data reporting sets and ad-hoc reporting. Role requires a solution oriented, self-starter that consistently looks to improve upon what exists in order to help implement best practices.
The Daily
Planning Cycles
• Daily & Monthly Reports
• Set-up P&L reports to track actuals & forecasts through all cycles
• Set-up By-title reports in SAP using BOT functionality for all cycles
• Review schedules to maintain an ongoing understanding of variances across time periods/divisions
• Prepare Intercompany Schedules for Actuals, Forecasts and the Budgets
• Roll and maintain Excel model (including SAP links & pivot tables) for each cycle
• Synthesize high-volume of by-title data and perform reconciliations when necessary
• Update summary reports & create comparative analysis across time periods
• Coordinate data submissions with divisions for Budgets
• Prepare ad-hoc analysis as needed
• Drive process improvements related to data flows
• Maintain documents related to sox compliance and policies
• Financial Review Presentations
• Roll and maintain key release/content schedules & trending reports
• Utilize data queries directly in SAP & pivot tables in Excel to mine data appropriately
• Perform by-title reconciliations; ensure consistency across outputs and data sources
• Collect & review source schedules from other departments; resolve discrepancies when necessary
• Help draft comparative analysis, headlines and highlights when necessary
• Drive process improvements related to data flows & presentation of data
Other
• Maintain BDS calendar
• Roll & maintain file folders for all cycles for the BDS department
• Help with ad-hoc analysis when necessary
• Work directly with other divisions and Finance Technology group to troubleshoot system issues
• Regularly update Lead Analyst Procedure Manual
The Essentials
• Minimum of 4 years experience in FP&A/Budgeting/Financial Strategy or related environment required
• Previous experience in public accounting and/or the entertainment industry strongly preferred
• High School diploma or equivalent required.
• BA/BS degree in Accounting, Economics or related field required, advanced degree preferred
• CPA/CFA strongly preferred
• High level of accountability, self-initiative and resourcefulness in order to manage own calendar
• Ability to own several end-to-end processes, including working independently to investigate material differences, gaining understanding/knowledge of the entertainment business, WB divisional data sets and systems in order to problem solve and drive solid financial analysis
• Very strong knowledge of generally accepted accounting principles (GAAP) and financial statements
• Effective written / verbal communication skills in order to effectively coordinate with peers
• Advanced proficiency in Excel required including developing & utilizing complex formulas
• Nested 'IF' and 'SUMIF' statements, vertical/horizontal lookups, 'Index/Match', Array formulas, etc.
• SAP BW/BPS/Hyperion experience required
• Experience with by-title and/or high volumes of data preferred
• Knowledge of Intercompany activity preferred
Jobcode: Reference SBJ-dy7k53-54-205-238-173-42 in your application.