Commercial Planning Analyst
Midea Latam North · Miguel Hidalgo, Mexico City, Mexico
Apply & track with Apply EdgeMidea Group is one of the world’s largest home appliance and air solutions groups. Every day, we work to make life easier, more efficient, and more connected. Our culture is rooted in innovation, collaboration, and operational excellence—and we believe in the power of our people to drive meaningful change.We are currently looking for a: Commercial Planning AnalystThe Commercial Planning Analyst is responsible for developing and executing strategic commercial plans that align with business objectives. This role involves conducting market analysis, sales forecasting, and performance monitoring to optimize commercial operations. The analyst will collaborate with cross-functional teams to enhance sales processes, identify growth opportunities, and support decision-making through data-driven insights.What will you do?
- Analyze Sell-Out by channel, customer, category, brand, and SKU.
- Identify trends, growth, declines, and variances versus the previous year, Budget, and Forecast.
- Prepare weekly and monthly Sell-Out estimates.
- Explain the main variances between Forecast and Actual results.
- Incorporate factors such as seasonality, promotions, pricing, distribution, and commercial events into the estimates.
- Monitor and track planned versus executed promotions.
- Measure promotional impact and uplift.
- Analyze the company’s and competitors’ pricing.
- Evaluate the impact of price changes on volume and value.
- Develop dashboards and commercial tracking tools.
- Identify risks and opportunities proactively.
- Turn data into actionable insights and recommendations for Sales, Marketing, Trade Marketing, and Commercial Planning.
- Business Understanding: Work with cross-functional teams to understand the business and make appropriate recommendations on how to use forecasting analytics to address business needs. Serve as the analytical expert for internal partners, such as Sales and Customer Logistics, by providing recommendations and communicating insights regarding order flow, planogram timing, shutdowns, and holiday strategies.What are we looking for?
- 3+ years of work experience in Sales, Commercial Planning, or related fields.
- Bachelor’s degree required.
- An MBA is a plus.
- Advanced English proficiency.
- Proficiency in Microsoft Office Suite (Outlook, Word, Excel, PowerPoint, Project, and/or Access).
- Power BI proficiency.
- Power Query / DAX proficiency.
- Experience managing large datasets.
- SQL knowledge is desirable.Knowledge, Skills, and Abilities
- Familiarity with data analysis software such as Microsoft Excel, Google Sheets, or more advanced tools like Power BI is essential for interpreting sales data and market trends.
- Ability to use software such as Microsoft PowerPoint or Google Slides to create and deliver compelling presentations that communicate the value of products or services.
- Familiarity with web conferencing tools such as Zoom, Microsoft Teams, or Cisco Webex for virtual meetings and presentations.
- Understanding of social media platforms for client engagement and staying updated on industry news and trends.
- Knowledge of e-commerce platforms, where relevant to the industry, to better understand client needs and challenges.
What We Offer
- Monday to Friday schedule.
- Grocery Vauchers
- Additional benefits above those required by law.
- Opportunity to be part of a global, fast-growing company.Why Midea?Because we are a global company with a regional mindset. Because your talent knows no boundaries. And because we are building a smarter, more connected, and more human future for millions of people around the world.Join us and be part of a team where your talent makes the difference!Midea LATAM North. is an equal opportunity employer. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.