Sales Analyst

Beacon Hill Staffing Group; California; Remote; USD 55,000 - 96,000; Full time

Job summary

Beacon Hill Staffing Group is seeking an experienced Sales Analyst for a 3-month remote assignment focused on sales reporting, forecasting, and operational analytics. The role emphasizes Excel mastery, Power BI, and data integrity across multiple systems.

The ideal candidate will analyze POS and revenue trends, build dashboards, and partner with Finance, Marketing, and Operations to deliver actionable insights for leadership and external partners.

Qualifications

• 4+ years in sales analysis, analytics, revenue planning, or inventory analysis.
• Expert-level Excel skills including XLOOKUP, VLOOKUP, INDEX/MATCH, PivotTables, Power Query, and VBA.
• Experience analyzing POS, revenue, sales, inventory, and variance data.
• Strong project management and organizational skills with multiple deadlines and shifting priorities.
• Bachelor's degree in Business, Finance, Economics, Data Analytics, or related field preferred.

Responsibilities

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

Skills

Advanced Excel

Data analysis

Strong communication

Remote work adaptability

Education

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

Tools

Power BI

VBA

Job description

We are 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. This position will focus heavily on sales reporting, data analysis, forecasting, and operational reporting.

The ideal candidate is highly analytical, extremely proficient in Excel, and comfortable working with large datasets and multiple reporting requirements. Candidates from entertainment, CPG, e-commerce, retail, or other physical-product environments will be considered.

Key Responsibilities

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

Qualifications

• 4+ years of experience in sales analysis, business analytics, revenue planning, inventory analysis, or a related analytical role
• Expert-level Excel skills, including XLOOKUP, VLOOKUP, INDEX/MATCH, PivotTables, conditional formatting, charts, data validation, filters, Power Query, and VBA/macros
• Experience analyzing POS, revenue, sales, inventory, and variance data
• Strong project management and organizational skills with the ability to manage multiple deadlines and shifting priorities
• Ability to work independently in a remote environment with minimal oversight
• Strong communication skills and the ability to translate complex data into digestible insights
• Experience within entertainment, CPG, e-commerce, retail, or another physical-product environment preferred
• Experience with Power BI or similar business intelligence tools is a plus
• Bachelor's degree in Business, Finance, Economics, Data Analytics, or a related field preferred

Beacon Hill is an equal opportunity employer and individuals with disabilities and/or protected veterans are encouraged to apply.

California residents: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

Completion of this form is voluntary and will not affect your opportunity for employment, or the terms or conditions of your employment. This form will be used for reporting purposes only and will be kept separate from all other records.

Company Profile:

Founded by industry leaders to set a new standard in search, career placement and flexible staffing, we deliver coordinated staffing solutions with unparalleled service, a commitment to project completion and success and a passion for innovation, creativity and continuous improvement.

Our niche brands offer a complete suite of staffing services to emerging growth companies and the Fortune 500 across market sectors, career specialties/disciplines and industries. Over time, office locations, specialty practice areas and service offerings will be added to address ever changing constituent needs.

Learn more about Beacon Hill and our specialty divisions, Beacon Hill Associates, Beacon Hill Financial, Beacon Hill HR, Beacon Hill Legal, Beacon Hill Life Sciences and Beacon Hill Technologies by visiting www.bhsg.com.

Benefits Information:

Beacon Hill offers a robust benefit package including, but not limited to, medical, dental, vision, and federal and state leave programs as required by applicable agency regulations to those that meet eligibility. Upon successfully being hired, details will be provided related to our benefit offerings.

We look forward to working with you.

Beacon Hill. Employing the Future