Business Analyst 3

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:

• 2-5 years of experience in pricing, financial analysis, or a related field.

Technical Skills:

• Advanced proficiency in Power Query (data transformation and automation).

• Intermediate skills in VBA (automation, macros) and DAX (data modeling, Power BI).

• Strong Excel skills (pivot tables, advanced formulas).

• Familiarity with ERP systems and pricing tools is desirable.

Soft Skills:

• Strong analytical and problem-solving abilities.

• Detail-oriented with a focus on accuracy.

• Ability to manage multiple tasks in a fast-paced environment.

Performance Metrics:

• Accuracy and timeliness of price sheet updates.

• Effectiveness of promotional campaigns (sales uplift, profitability).

• Quality of data analysis and insights provided