Forecasting Analyst

The Fountain Group; Village of Pelham (NY); Remote; USD 60,000 - 80,000; Full time

Job summary

An innovative firm is seeking a Forecasting Analyst for a fully remote role to enhance forecasting processes and reporting. This position involves developing automated solutions for daily volume forecasts, utilizing advanced Excel and Google Sheets skills. You will collaborate with internal and external teams to ensure accurate forecasts and historical performance analysis. This exciting opportunity offers a chance to contribute to data-driven decisions in a dynamic environment. If you have a background in data analytics or finance and a passion for improving processes, this role is perfect for you.

Qualifications

• 1-3 years of experience as an analyst with strong Excel and Google Sheets skills.
• Experience in data analytics or financial background preferred.

Responsibilities

• Develop and operate improved processes for refining daily volume forecasts.
• Automate reporting from Google Sheets, Excel, and other internal tools.

Skills

Data Analysis

Forecasting

Excel

Google Sheets

Automation

Education

Bachelor's Degree

Tools

Sigma

Job description

Forecasting Analyst

• Fully remote
• Monday-Friday; Hours are 9:00 am to 5:00 pm EST

$33-34 per hour W2

4-month project; can extend

Responsibilities:

• Develop and operate improved processes for refining and reporting on daily volume forecasts
• Own daily reporting to internal and external partners; automate reporting from Google Sheets/Excel, Sigma, and other internal tools
• Update forecasting models based on daily actuals and historical trends to better predict future volume levels and support needs
• Support internal and external teams with understanding volume forecast, actuals vs. forecast accuracy, and historical performance (especially as it relates to quality outcomes)
• Build more sustainable and automated processes to update forecasts on an intra-day basis going forward

What we’re looking for:

• 1 – 3 years of experience as an analyst
• Advanced proficiency in Excel/Google Sheets; create summaries, pivot tables, data cleaning operations/formulas, automate repeated calculations/tasks
• Preferred background: banking, data analytics, financial background
• Nice to have: Sigma