FP&A Analyst

Minis; West Covina (CA); On-site; USD 85,000 - 120,000; Full time

Job summary

Minis in West Covina, CA seeks an FP&A Analyst to support the Merchandising team with financial modeling and data-driven analyses aligned to the company roadmap. You will partner with Finance to participate in budgets and forecasts, delivering insights to improve margin and inventory productivity.

The role emphasizes analytical thinking, cross-functional communication, and advanced Excel skills, with familiarity in Power BI and SQL preferred to drive decision-making.

Qualifications

• Bachelor’s degree in finance, accounting, economics, business, or related field.
• 3+ years of FP&A, financial analysis, or retail analytics in brick-and-mortar retail.
• Advanced Excel skills and experience with large datasets.
• Experience with Power BI and SQL preferred.

Responsibilities

• Analyze merchandising financial performance across sales, gross margin, and inventory productivity.
• Develop dashboards and reports to track merchandising financials and product trends.
• Build and maintain financial models for category sales, pricing, promos, and margins.
• Support forecasting and financial projections for merchandising initiatives.
• Provide data-driven insights to merchandising leadership and reviews.
• Identify risks, opportunities, and optimization ideas to improve margin and inventory productivity.

Skills

Advanced Excel

Power BI

Education

Bachelor's Degree in Finance/Accounting/Economics/Business/Data Analytics

Tools

Excel

Power BI

SQL

Job description

Job Summary

The FP&A Analyst, a key position in the Finance Department, is primarily responsible for supporting the Merchandising department by formulating financial models and data-driven analyses to drive the department in developing key merchandising strategies and delivering results in line with the Company strategic roadmap. This position partners closely with other analysts in the Finance Department, who support other core business units, and will actively participate in budget and forecast processes of the Company.

Essential Job Functions

Merchandising Financial Analysis

• Analyze category and product performance across sales, gross margin, and inventory productivity metrics
• Monitor key retail KPIs including sell-through, margin performance, inventory turnovers and aging, and product life cycle
• Evaluate the financial impact of pricing strategies, promotions, and markdown activity
• Identify risks and opportunities impacting category performance and profitability

Performance Reporting and Analytics

• Develop and maintain dashboards and reporting to track merchandising financial performance and product trends
• Deliver recurring performance analysis highlighting trends, variances, and opportunities across categories
• Translate complex data into clear insights that support merchandising decision-making
• Prepare reports and analysis for merchandising leadership and business reviews

Financial Modeling and Forecasting

• Build and maintain financial models to evaluate category sales performance, pricing and promotion strategies, and margin maximization scenarios
• Support forecasting and financial projections related to merchandising initiatives and assortment changes
• Analyze historical performance trends to support forward-looking business decisions
• Provide scenario analysis related to pricing, cost changes, and promotional strategies

Merchandising Decision Support

• Partner with Buyers and Planners to maximize savings in inventory procurement cost and shorten TTM.
• Conduct ad hoc analysis related to vendor performance, product profitability, and category trends
• Support line reviews and merchandising meetings with data-driven insights
• Provide recommendations that help improve margin performance and inventory productivity

Process Improvement and Data Optimization

• Identify opportunities to improve merchandising reporting, analytics processes, and dashboard visibility
• Support automation and standardization of recurring merchandising reports
• Help improve data accuracy and usability across merchandising tools and systems

Additional Qualifications

• Strong analytical and problem-solving skills with the ability to interpret complex data and translate insights into business recommendations
• Curiosity and commercial mindset with interest in understanding product performance, pricing, and customer behavior
• Ability to communicate insights clearly to cross-functional partners and leadership
• Strong attention to detail and ability to manage multiple priorities in a fast-paced environment
• Advanced Excel skills required; experience working with large datasets
• Experience with data visualization tools such as Power BI preferred
• Experience with SQL or similar data querying tools preferred
• Familiarity with retail KPIs including sales performance, gross margin, sell-through, and inventory productivity preferred

Education & Experience

• Bachelor’s Degree in Finance, Accounting, Economics, Business, Data Analytics, or a related field
• 3+ years of experience in financial analysis, FP&A, or retail analytics, within a brick-and-mortar retail environment.

Pay Range

USD $85,000.00 - USD $120,000.00 /Yr.