Data-Driven Sales Analyst: Excel-Driven Forecasting (Remote)

Maine Tech Hub; Augusta (ME); Remote; USD 60,000 - 90,000; Full time

Job summary

Beacon Hill Solutions Group, LLC in Augusta, Maine, United States is seeking an experienced Sales Analyst for a 3-month remote temporary assignment supporting a consumer-facing business with significant physical product sales and inventory activity. The ideal candidate is highly analytical, exceptionally proficient in Excel, and comfortable working with large datasets and multiple reporting requirements.

You will build reports, forecast sales, and collaborate with Finance, Marketing, and

Qualifications

• 4+ years of experience in sales analytics or related analytic role.
• Expert-level Excel skills including XLOOKUP, VLOOKUP, INDEX/MATCH, PivotTables, and Power Query.
• Experience analyzing POS, revenue, inventory, and variance data.

Responsibilities

• Conduct large-scale data analysis and translate findings into actionable insights.
• Build, maintain, and refresh daily and weekly sales and operational reports.
• Analyze POS, revenue, sales trends, inventory data, and variance percentages.
• Maintain dashboards and KPI reporting for stakeholders and partners.
• Support sales forecasting, revenue projections, and related financial reporting.
• Maintain data integrity across multiple systems and data sources.
• Automate reporting using advanced Excel, Power Query, PivotTables, and VBA/macros.
• Coordinate timelines for new product releases, promotions, and retail programs.
• Partner cross-functionally with Finance, Marketing, Operations, and other teams.
• Identify opportunities to improve reporting workflows and data accuracy.
• Prepare reporting and presentations for leadership.

Skills

Excel advanced

XLOOKUP

VLOOKUP

PivotTables

Power Query

Data analysis

Power BI

Communication

Education

Bachelor's degree in Business/Finance/Economics/Data Analytics

Tools

Power BI

VBA/macros

Job description

Beacon Hill Solutions Group, LLC in Augusta, Maine, United States is seeking an experienced Sales Analyst for a 3-month remote temporary assignment supporting a consumer-facing business with significant physical product sales and inventory activity. The ideal candidate is highly analytical, exceptionally proficient in Excel, and comfortable working with large datasets and multiple reporting requirements.

You will build reports, forecast sales, and collaborate with Finance, Marketing, and