SUPPLY CHAIN INTELLIGENCE

Description

Job Summary: You will lead analysis and operational intelligence for the supply chain, enhancing decision-making through integration and automation of key data. Key Highlights: 1. Design and automate supply chain dashboards and key reports. 2. Build and optimize SQL queries to integrate and analyze information. 3. Collaborate on data-driven operational improvement. Farmacias del Ahorro is a 100% Mexican company dedicated to providing health and wellness services to all Mexicans. With a distinguished track record of over 30 years in the market, we have achieved steady and consistent growth, serving customers through our network of more than 1,500 stores and a workforce exceeding 20,000 employees. We are the leading national pharmacy chain. Join our team! **Job Mission** Lead analysis and generation of operational intelligence for the supply chain by integrating and automating key data to improve decision-making in areas such as inventory, distribution, procurement, and demand. Support with reports, predictive models, and analytical tools aimed at improving efficiency and profitability within the retail context. **Job Description** **Key Responsibilities:** * Design, automate, and maintain dashboards and reports on key supply chain metrics (fill rate, inventory turnover, lead times, OTIF, etc.). * Build and optimize SQL queries on data platforms such as BigQuery to integrate and analyze sales, inventory, purchasing, and logistics data. * Collaborate with planning, procurement, logistics, and commercial teams to identify data-driven operational improvement opportunities. * Automate data extraction, transformation, and loading (ETL) processes, minimizing manual tasks. * Develop early-warning alerts and forecasting models for demand, service levels, or logistics risks. * Support continuous improvement initiatives and digital transformation projects for the supply chain. * Ensure data quality, consistency, and availability for decision-making. **Requirements:** * Bachelor’s degree in Industrial Engineering, Logistics, Economics, Computer Science, Actuarial Science, or related field. * Proficiency in SQL (experience with BigQuery preferred). * Experience in process automation using tools such as R, Python, or KNIME (preferred). * Knowledge of visualization tools such as Tableau, Power BI, or Looker. * Familiarity with collaborative tools (Google Sheets, App Script, etc.) is desirable. * Minimum 2 years of experience in planning, data analysis, or supply chain intelligence within retail, consumer goods, or logistics sectors. **Skills:** * Analytical and strategic thinking. * Results-oriented mindset and commitment to continuous improvement. * Ability to communicate technical findings to non-technical audiences. * Teamwork and proactivity. * Basic knowledge of supply chain concepts. **Employment Type** Permanent **Work Model** On-site At Farmacias del Ahorro, we care about you — and want you to thrive! We promote and verify adoption of measures supporting equal opportunity and elimination of all forms of discrimination across our recruitment processes and workplaces. We will never request any payment as part of our recruitment process; please exercise caution and avoid falling victim to fraud.