Junior Commercial Data Analyst (Sales Data Analyst Jr)

Description

Job Summary: We are seeking a Junior Commercial Data Analyst to support sales intelligence through processing and analyzing metrics to optimize point-of-sale execution. Key Highlights: 1. Development of commercial intelligence with dynamic reports and dashboards 2. Optimization of routes and coverage to improve sales efficiency 3. Collaboration with internal departments to align business processes and priorities We aim to acquire your talent and develop your expertise as a **Junior Commercial Data Analyst (Sales Data Analyst Jr)** **Company Description**: Tramontina is a Brazilian company with over 100 years of history, specializing in manufacturing household and other industry products. Its commitment to innovation, design, quality, functionality, product aesthetics, and sustainable development underpins its position as an industry benchmark worldwide. **Job Summary** We are seeking a **Junior Commercial Data Analyst (Sales Data Analyst Jr)** to support sales force intelligence. The primary function is to process, structure, and analyze sales, distribution, and market productivity metrics—transforming them into reports and interactive dashboards that guide commercial leaders and optimize point-of-sale execution. **Key Responsibilities and Functions** * **Commercial Operational Analysis:** Evaluate sales, distribution, coverage, execution, and internal sales team and representative productivity data. * Volume and Net Sales. * Numerical and weighted distribution. * Execution and compliance with pricing and promotional policies. * Stock availability and portfolio depth per channel. * **Commercial Intelligence Development:** Generate reports, executive summaries, and dynamic dashboards to support agile decision-making by commercial leaders. * **Route and Coverage Optimization:** Identify improvement opportunities in sales route planning, customer visit frequency, and point-of-sale execution standards. * **Launch Tracking:** Monitor performance, market penetration, and adoption of commercial initiatives, recent launches, and innovations. * **Institutional Synergy:** Collaborate with internal departments (Supply Chain, Trade Marketing, Finance) to align processes with business priorities. * **Action Plans:** Actively support the design of strategic plans aimed at improving commercial results and regional operational efficiency. **Job Requirements** * **Education:** Completed bachelor’s degree in Actuarial Science, Industrial Engineering, Mathematics, Economics, Business Administration, or another numerically intensive field. * **Experience:** Minimum 1–2 years in sales data analysis, Business Intelligence (BI), or commercial planning roles (preferably in FMCG, retail, or manufacturing companies). * **Intermediate Excel:** Proficiency in macros, Power Pivot, logical formulas, and complex cross-referencing of large-scale databases. * **Power BI / Tableau:** Experience building interactive dashboards from diverse data sources. * Basic/intermediate knowledge of **SQL** queries or experience with **CRM/ERP** systems (SAP or similar) is desirable. **Skills and Competencies** * **Analytical Thinking:** Ability to “make data speak” to uncover hidden deviations or commercial opportunities. * **Commercial Acumen:** Understanding of field sales environments to translate charts into practical business actions. * **Assertive Communication:** Skill in presenting executive summaries and insights clearly and persuasively to senior management. * **Attention to Detail:** Mathematical rigor to ensure reported information has zero margin of error. **Benefits and Compensation** * **Statutory Benefits:** Social Security, INFONAVIT, Profit Sharing (PTU), 30-day Christmas bonus, statutory vacation days. * **Health and Wellness:** Major Medical Expense Insurance (SGMM). * **Development:** Support for continuous professionalization (educational scholarships) and ongoing training. * **Tramontina Culture:** Employee discounts on brand products and commercial partnerships. * **Work-Life Balance:** Extended leave (medical, maternity, paternity, lactation). * **Work Tools:** Free parking, uniforms, and covered travel expenses (accommodation, meals, transportation). **Additional Information** * **Location:** Corporate offices at Paseo Interlomas, Huixquilucan, Méx. * **Work Mode:** On-site. * **Schedule:** Monday to Friday, 8:00 AM – 5:00 PM (Saturdays and Sundays off). **Salary:** $15,000 to $20,000 MXN monthly. Employment Type: Full-time, indefinite term Salary: $15,000.00 – $20,000.00 MXN per month Benefits: * Educational support * Discounts and preferential pricing * Company parking * Free parking * Major medical expense insurance * Free uniforms Application Question(s): * Our offices are located at Paseo Interlomas—do you have any concerns regarding commuting distance and on-site employment? * Please describe your experience and highlight significant achievements as a Data Analyst Work Location: On-site employment