Portfolio Intern

Description

Job Summary: Provide operational and analytical support in portfolio management, sales analysis, pricing, and inventory management to contribute to commercial decision-making. Key Highlights: 1. Support in commercial portfolio analysis. 2. Assistance in pricing and price lists. 3. Automation of reports and processes using AI. **Portfolio Intern** Importer and distributor of technology, electronic security, connectivity, cabling, equipment, accessories, or technological solutions. Seeking a candidate to provide operational and analytical support to the Portfolio Management team in managing product lines, tracking sales, analyzing prices, controlling inventory, updating commercial information, coordinating with internal departments, automating tasks and processes using AI; thereby contributing to effective portfolio administration and commercial decision-making. **REQUIREMENTS** 8th-semester student in Business Administration, Industrial Engineering, Marketing, International Business, Economics, Commercial Engineering, Business Management, or related fields. Desirable knowledge of Claude and ChatGPT usage. Intermediate/advanced Excel skills (pivot tables, macros, Power Query). Knowledge of SQL and Python (desirable). Proficiency in Power BI, pivot tables, dashboards, or data visualization tools. Basic knowledge of commercial analysis, inventory management, margins, costs, and pricing is desirable. Intermediate English proficiency, especially for reading technical specifications, catalogs, and communicating with suppliers. Analytical thinking. Attention to detail. Proactivity and focus on efficiency. Numerical and commercial judgment. Ability to structure databases. Basic understanding of margins, pricing, costs, and inventory. Responsibility. Organization. Ability to prioritize tasks. **RESPONSIBILITIES** **1\. Support in commercial portfolio analysis** Assist in preparing sales reports by brand, category, customer, and channel. Analyze sales trends, margins, product turnover, portfolio mix, and achievement of commercial objectives. Identify high-, medium-, and low-turnover products, as well as growth opportunities or alerts regarding underperformance. Prepare comparative performance charts across brands, models, categories, and channels. **2\. Assistance in pricing and price lists** Support comparative price analysis between company and competitors. Assist in reviewing margins per product, channel, or customer, identifying significant deviations. Support loading, validation, and maintenance of prices in internal systems, catalogs, or commercial files. **3\. Automation of reports and processes using AI** Automate generation of commercial reports using artificial intelligence tools, optimizing margin analysis, pricing strategy, and market trend analysis. **4\. Product information management** **5\. Support in product launches and management of new lines** **6\. Benchmarking and competitive analysis** **7\. Inventory and supply tracking** Salary: Up to S/.1,130.00 per month Workplace: On-site employment