FP&A Analyst
JobsInMass.com · Westwood, MA · 2 wk ago
FinanceFull-time
Responsibilities
- Track and report Key Performance Indicators (KPIs).
- Work with large data sets to conduct financial analysis. Advanced Excel skills including formulas, v-lookup, and pivot tables required to build models and what-if scenarios.
- Assist in gathering monthly forecast/outlook information from department heads. Ensure data properly flows into all templates, reports, and models properly.
- Provide support during the Annual Operating Plan, 6+6 and 9+3 Forecasts
- Maintain BPC (Business Planning & Consolidation system) throughout planning processes to ensure all relevant planning factors and system drivers are updated and included.
- Track monthly marketing spend and league contractual spend. Meet regularly with key stakeholders to align forecast to actuals and identify issues.
- Run reports to confirm plan inputs with department heads, communicate gaps and issues in the input data or the system calculations.
- Assist in creating monthly and quarterly consolidated management reports for leadership.
- Work cross-functionally to support Accounting and month end close tasks including COGS analysis and inventory turns.
- Understand business drivers and anticipate financial impacts of strategic initiatives.
- Maintain & manage ad hoc data and analysis requests to aid in decision making
- Keeps all sensitive matters confidential, Process confidential data and information according to guidelines
Knowledge, Skills, and Abilities
- Experience with physical inventory required. CPG, apparel, footwear, or durable goods.
- Ability to research new and unfamiliar topics objectively
- Ability to extract and analyze large amounts of data using standard, fact-based procedures and identify trends and insights; recommend a solution if applicable
- Ability to input data accurately and efficiently
- Excellent written and oral communication skills, including the ability to explain moderately complex information to others in a straightforward manner.
- Ability to solve problems in straightforward situations with critical thinking.
- Ability to learn new tasks quickly with a willingness to provide feedback for process improvement.
- Excellent interpersonal skills
- Possesses a “continuous improvement” mind-set
- Ability to juggle multiple assignments and prioritize activities in fast paced environment.
- Enthusiastic, positive outlook, acts with a sense of urgency
- Ability to deal with and manage change
- Organized and detail-oriented with excellent follow through
- Resourceful, Innovative and Creative Thinker
- Proficient in MS Office – Word, Excel, PowerPoint and Outlook – prefer SAP experience
- Advanced knowledge of Excel and Power Point
- Knowledge of D365 and BPC a plus
- Experience using AI in data analysis a plus
Education and Experience
- Bachelor’s Degree preferred in Finance or Accounting; or a related field; MBA is an asset
- 3-5 years’ work experience in a finance related field
Travel Requirement
- 5%