O SEU PRÓXIMO CAPÍTULO
Supply Chain Forecasting, Data Analyst
Sobre a vaga
• Analyze historical sales and order data to identify demand patterns and purchasing behavior
• Develop SKU-level and customer-level demand forecasts
• Build rolling 12–18-month demand forecasts using historical purchasing trends
• Analyze year-over-year demand and growth patterns
• Annualize year-to-date usage where appropriate
• Identify consistent, seasonal, sporadic, declining, and growing demand patterns
• Account for differences in units of measure, product categories, and customer purchasing behavior
• Identify unusual changes in demand, including spikes, drops, and zero-usage products
• Build scalable forecasting and inventory analysis models in Microsoft Excel
• Develop formulas, calculations, PivotTables, lookups, and analytical logic to support forecasting
• Create recommendation logic for stocking validation, maintaining stocking, and reduction evaluation
• Build exception reporting and alerts for products requiring additional review
• Test forecasting methodologies on representative datasets before broader implementation
• Document formulas, assumptions, calculations, and methodology
• Extract, organize, clean, and validate large datasets from ERP and other business systems
• Identify inconsistencies, missing information, duplicates, and data-quality issues
• Determine how data issues may impact forecasting and analytical results
• Establish data-cleaning and validation processes
• Communicate data-quality concerns to relevant stakeholders
• Analyze demand trends to support inventory and stocking decisions
• Identify SKUs requiring increased or reduced stocking levels
• Evaluate customer purchasing behavior and its impact on inventory requirements
• Support inventory planning and replenishment decisions through data-driven analysis
• Develop insights balancing product availability with inventory efficiency
• Create clear reports showing historical usage, demand trends, forecasts, and recommendations
• Translate complex analysis into practical commercial recommendations
• Present findings to non-technical stakeholders
• Highlight key trends, exceptions, risks, and opportunities
• Support customer-facing inventory and demand reports
• Work independently while collaborating with business and supply chain stakeholders
• Take ownership of analytical projects from raw data through final recommendations
• Clarify unclear requirements or datasets
• Explain analytical approach and reasoning clearly
• Adapt forecasting methodology when business requirements or data patterns change
• Communicate progress, challenges, and findings effectively
• 3+ years of experience in supply chain analytics, demand planning, forecasting, inventory planning, operations analytics, or a closely related analytical field
• Hands-on experience with demand forecasting and/or supply planning
• Advanced proficiency in Microsoft Excel
• Strong experience with PivotTables
• Strong experience with XLOOKUP / INDEX-MATCH
• Strong experience with SUMIFS and advanced Excel formulas
• Experience with data cleaning and transformation
• Experience with trend analysis
• Experience with growth-rate calculations
• Experience with forecasting models
• Experience working with large datasets
• Experience extracting, cleaning, and analyzing data from ERP systems
• Ability to build analytical models from raw transactional data rather than simply maintaining existing reports
• Strong understanding of SKU-level demand and inventory concepts
• Strong analytical reasoning and problem-solving skills
• Ability to work independently with incomplete, inconsistent, or imperfect data
• Strong written and spoken English
• Ability to communicate analytical findings clearly to non-technical stakeholders
• Premium Internet allowance
• Electricity allowance
• Wellbeing allowance
• Annual performance-based increments
• Structured career progression
• Individual performance-based bonuses
• Team-based target bonuses