FP&A Analyst

Role Overview

The FP&A Analyst is a vital contributor within our Finance Department, dedicated to supporting the Merchandising team through the creation of financial models and data-driven analyses. This support aids in shaping key merchandising strategies aligned with the company’s strategic goals. The role involves close collaboration with fellow finance analysts who concentrate on other core business units, and active engagement in the company's budgeting and forecasting activities.

Merchandising Financial Analysis

• Assess category and product performance by analyzing sales, gross margin, and inventory productivity.
• Track important retail key performance indicators, including sell-through rates, margin trends, inventory turnover and aging, and product lifecycle.
• Evaluate how pricing strategies, promotions, and markdowns impact financial outcomes.
• Detect risks and opportunities that could affect category profitability and performance.

Performance Reporting and Analytics

• Design and update dashboards and reports to monitor merchandising financial performance and product trends.
• Provide consistent performance analyses that reveal trends, deviations, and potential growth areas across categories.
• Convert intricate datasets into simple insights that aid merchandising decisions.
• Prepare comprehensive reports for merchandising leadership and operational business reviews.

Financial Modeling and Forecasting

• Create and manage financial models evaluating category sales, pricing, promotions, and margin optimization scenarios.
• Assist in forecasting and financial predictions relating to merchandising activities and changes in product assortments.
• Analyze historical business trends to inform future decisions.
• Conduct scenario analyses concerning pricing modifications, cost variations, and promotional tactics.

Merchandising Decision Support

• Collaborate with Buyers and Planners to enhance savings on inventory procurement and reduce time-to-market.
• Perform on-demand analyses regarding vendor efficiency, product profitability, and category trends.
• Support line reviews and merchandising meetings by providing data-supported insights.
• Offer suggestions aimed at improving margins and inventory efficiency.

Process Improvement and Data Optimization

• Identify and implement opportunities to enhance merchandising report generation, analytics workflows, and dashboard accessibility.
• Support automation and standardization efforts for recurring merchandising reports.
• Work towards improving data precision and usability within merchandising tools and systems.

Candidate Profile and Requirements

• Highly analytical with strong problem-solving capabilities to interpret complex data and translate findings into actionable business recommendations.
• Curious and commercially minded with a focus on product performance, pricing dynamics, and customer behaviors.
• Effective communicator, capable of delivering clear insights to cross-functional teams and leadership.
• Detail-oriented and adept at managing multiple priorities in a fast-paced environment.
• Advanced proficiency in Microsoft Excel and experience handling large datasets.
• Preferred familiarity with data visualization software, such as Power BI.
• Experience with SQL or related data querying tools is desirable.
• Knowledge of retail KPIs including sales tracking, gross margin, sell-through rates, and inventory productivity is advantageous.
• A Bachelor's degree in Finance, Accounting, Economics, Business, Data Analytics, or a related discipline is required.
• Minimum of 3 years' experience in financial analysis, FP&A, or retail analytics within a physical retail setting.

Compensation

Annual salary ranges between $85,000 and $120,000 USD.