Excel: Proficiency level 8/10, including V-lookups and other advanced functions.
Python: Good to have.
Supply Chain Background: Expertise in Material Demand Forecasting, Segmentation, Replenishment, Purchase Orders, and other supply chain processes.
AWS Cloud Services: Knowledgeable about AWS cloud services including S3, Redshift, Dynamo DB, and API Gateways.
ETL Workflows: Ability to analyze ETL workflows, including experience with tools such as Abinitio, DataStage, Informatica, and Palantir.
Responsibilities:
Utilize SQL skills to extract, manipulate, and analyze data from various databases to support supply chain decision-making processes.
Employ advanced Excel functions to organize, analyze, and visualize large datasets, creating insightful reports and dashboards for stakeholders.
Utilize Python for data analysis tasks, automation, and development of custom scripts for enhancing analytical capabilities.
Apply supply chain expertise to develop and maintain accurate demand forecasts, segment customers/products, optimize replenishment strategies, and manage purchase orders effectively.
Utilize AWS cloud services such as S3, Redshift, Dynamo DB, and API Gateways to build scalable and efficient data pipelines, storage solutions, and analytics platforms.
Analyze ETL workflows to identify bottlenecks, improve performance, and ensure data integrity across various data integration processes.
Collaborate with cross-functional teams including supply chain, IT, and business stakeholders to understand requirements, provide analytical insights, and drive data-driven decision-making.
Stay updated with industry trends, emerging technologies, and best practices in data analytics, supply chain management, and cloud computing to continuously enhance skills and contribute to the growth of the organization.
