Data Analyst

Description

Job Summary: We are seeking a Data Analyst focused on the commercial area (Retail, B2B, Wholesale) to analyze sales trends, manage inventory, and collaborate on demand planning. Key Highlights: 1. Job stability and professional work environment 2. Performance-based bonuses 3. Subsidized cafeteria service At **Perfect Choice**, we are looking for a **Data Analyst / Focused on the Commercial Area (Retail, B2B, Wholesale)** What We Offer: * Benefits exceeding legal requirements (Savings Fund, Year-end Bonus, Vacation Premium, IMSS). * Job stability and professional work environment * Performance-based bonuses. * Working hours Monday to Friday (8:00 am to 5:30 pm) * Cafeteria Service (Subsidized) * Gross Monthly Salary * Biweekly Payment The profile of the talent we seek: \* Bachelor's degree in Industrial Engineering, Actuarial Science, Mathematics, Business Administration, or related field. \* Minimum 3 years of experience in CPFR-related roles, specifically within the commercial area. \* Knowledge of: \- Advanced Excel (pivot tables, complex formulas, macros, etc.); an advanced proficiency test will be administered. \- Demand forecasting methodology (statistical, historical, and seasonal models). \- Required: Google Suite/Google Workspace, SQL, and data analytics tools (Power BI, Looker, Qlik, etc.). \- Familiarity with supply chain processes, planning, and replenishment. \* Competencies: Analytical thinking and problem-solving orientation, effective communication across multiple internal departments and external stakeholders, results-driven mindset with continuous improvement focus, proactivity and time management, collaborative teamwork. Responsibilities: \- Collect and consolidate sell-out sales and inventory data from each wholesale, retail, and e-commerce platform client. \- Maintain, for each client, detailed information on pending orders, as well as the 4-month forecast, to develop collaborative demand forecasting models and ensure forecast compliance based on current inventory levels and ongoing production orders. \- Analyze sales velocity trends per product to issue alerts to the sales force and anticipate potential issues: inventory imbalances, stockouts, slow-moving items, product discontinuation, etc. \- Analyze inventory levels and aging per product across wholesale and retail accounts. \- Collaborate with internal teams to develop data-driven sales forecasts based on historical data, promotions, and seasonality, to monitor and adjust plan adherence. \- Plan demand for new products using historical data when replacing existing ones, or leveraging market potential information for entirely new products. Employment Type: Full-time Salary: $20,000\.00 \- $25,000\.00 per month Benefits: * Discounts and preferential pricing * Major medical expense insurance * Life insurance * Discounted cafeteria service Experience: * Microsoft Excel: 3 years (Mandatory) * Power BI: 3 years (Mandatory) Work Location: On-site employment