FP&A Analyst: Forecasting, Modeling & Automation

Jobless; New York (NY); On-site; USD 70,000 - 100,000; Full time

Benefits offered by this job

Medical, dental, vision

PTO

401(k)

Employee discount

Job summary

RugsUSA seeks a Financial Analyst to join the FP&A team, supporting planning, reporting, forecasting, business analysis, and the modernization of finance analytics.

Reporting to the Senior Manager of FP&A, the role owns recurring reporting, builds models, analyzes performance across brands and channels, and helps automate finance reporting using Excel, Power Query, Sigma, and Snowflake.

Qualifications

• Bachelor's degree in Finance, Accounting, Economics, Business Analytics, or related field.
• 2–5 years of experience in FP&A, Financial Analysis, Corporate Finance, or a related analytical role.
• Advanced Microsoft Excel skills.
• Experience with Power Query, Power Pivot, or similar analytical tools.
• Ability to build well-structured, auditable models with clear assumptions, formulas, outputs, and version control.
• Strong financial modeling and analytical capabilities, including experience building driver-based forecasts, scenario analyses, and sensitivity models.
• Working knowledge of financial statements and fundamental accounting principles.
• Ability to analyze large datasets and identify meaningful business drivers.
• Strong problem-solving, communication, and organizational skills.

Responsibilities

• Own recurring weekly and monthly financial and KPI reporting, including data preparation, validation, variance analysis, and management commentary.
• Support monthly close and analyze performance versus Forecast, Budget, and prior year.
• Support annual Budget, periodic Forecast, Long-Range Planning, and related financial model development processes.
• Maintain reporting across key financial and operational metrics including Revenue, Demand, Units, ASP/AOV, Gross Margin, Variable Contribution, EBITDA, Cash Flow, Inventory, and Operating Expenses.
• Support preparation of executive and Board reporting and analysis.
• Track forecast performance and help identify emerging risks and opportunities.
• Build, update, and maintain financial models to support forecasting, scenario planning, business cases, and strategic decision-making.
• Translate financial and operational data into concise insights, risks, opportunities, and actionable recommendations.

Skills

Advanced Excel

Power Query/Power Pivot

Financial modeling

Data analysis

Attention to detail

Education

Bachelor's degree in Finance, Accounting, Economics, Business Analytics, or related field

Tools

Sigma

Snowflake

Power Query/Power Pivot

SQL

Excel

Job description

RugsUSA seeks a Financial Analyst to join the FP&A team, supporting planning, reporting, forecasting, business analysis, and the modernization of finance analytics.

Reporting to the Senior Manager of FP&A, the role owns recurring reporting, builds models, analyzes performance across brands and channels, and helps automate finance reporting using Excel, Power Query, Sigma, and Snowflake.