Business Analyst 3 (Pricing Analyst)

Job ID : 25-10288

Pay rate range - $40 / hr. to $42 / hr. on W2

Schedule : Hybrid, 4 days in office, Friday WFH / remote

Top skills : Comprehensive Excel (Power Query, VBA, DAX), Communication, Organization

KEY RESPONSIBILITIES / REQUIREMENTS :

Job Purpose :

The Pricing Analyst will be responsible for managing price sheets and developing promotional roadmaps for home appliance retail customers. This role requires strong analytical skills, attention to detail, and the ability to translate data into actionable pricing strategies.

Key Responsibilities :

1. Price Sheet Management :

o Maintain and update price sheets for home appliance products.

o Ensure accuracy and consistency in pricing across all retail channels.

o Collaborate with Sales and Product teams to align pricing with market trends and business objectives.

2. Promotional Roadmap Development :

o Assist in designing and implementing promotional strategies for retail customers.

o Analyze historical sales and promotional data to optimize future campaigns.

o Support Marketing and Sales in executing promotions effectively.

3. Data Analysis & Reporting :

o Utilize Power Query (advanced) for data extraction, transformation, and automation.

o Apply VBA (intermediate) and DAX (intermediate) to enhance reporting and modeling.

o Generate reports and dashboards to monitor pricing and promotional performance.

o Identify trends and provide insights to improve profitability.

4. Cross-functional Collaboration :

o Work with Finance, Sales, and Marketing teams to align pricing strategies.

o Communicate pricing changes and promotional plans to stakeholders.

Qualifications & Skills :

Education :

• Bachelor's degree in Data Analytics, Economics, Statistics, or a related field.

Experience :

Technical Skills :

Soft Skills :

Performance Metrics :