Financial Analyst

Posted 9hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Financial Analyst supporting FP&A, forecasting, and KPI reporting for RugsUSA, an online area-rug and home-accessories retailer. Automating Finance analytics with Excel, Sigma, and Snowflake.

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 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 for forecasting, scenario planning, business cases, and strategic decision-making
  • Analyze performance across brands, channels, customers, and product categories
  • Perform driver-based variance analysis across price, volume, mix, channel, customer, and product
  • Analyze eCommerce performance drivers including traffic, conversion, units, pricing, promotions, returns, fulfillment costs, inventory, and profitability
  • Partner with Finance, Commercial, Merchandising, Marketing, and Operations teams to understand performance and answer business questions
  • Support pricing, promotional, inventory, margin, and profitability analyses
  • Develop scenario and sensitivity analyses for management decision-making
  • Create driver-based models connecting operational metrics to revenue, margin, EBITDA, cash flow, working capital, and inventory outcomes
  • Translate financial and operational data into concise insights, risks, opportunities, and actionable recommendations
  • Build and maintain automated reporting solutions using Excel, Power Query, Power Pivot, Sigma, and Snowflake
  • Reduce manual reporting and data preparation through automation and standardized processes
  • Develop and maintain Finance dashboards and reusable reporting models
  • Design scalable Excel-based models and analytical templates with assumptions, outputs, sensitivities, and documentation
  • Validate and reconcile financial and operational data across multiple systems
  • Help transition spreadsheet-based reporting into scalable reporting and BI solutions
  • Support standardized Finance KPI definitions, reporting hierarchies, and data models
  • Identify opportunities to simplify and automate FP&A processes
  • Document reporting processes, data sources, definitions, and controls
  • Help establish consistent Finance metrics and reporting standards
  • Support implementation and adoption of new FP&A tools, dashboards, and data models

Requirements:

  • 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
  • NetSuite or similar ERP experience preferred
  • Experience with Power BI, Sigma, SQL, or Snowflake preferred
  • Experience in retail, consumer products, eCommerce, or an omnichannel business preferred
  • Experience building or maintaining models for demand planning, margin analysis, inventory, cash flow, customer profitability, or promotional effectiveness preferred

Benefits:

  • A culture that promotes a healthy work/life balance
  • Benefits package offered to all eligible full-time employees (including medical, dental, vision, PTO, 401(k)
  • Exposure to career advancement opportunities across all departments
  • Generous employee discount that can be used across our house of brands!