ADVANCED DATA ANALYST _

Description

Position Summary: Advanced Data Analyst responsible for analyzing commercial, sales, and market information, participating in ETL processes and automation to support decision-making. Key Highlights: 1. Strategic analysis of commercial data for the fast-moving consumer goods (FMCG) sector 2. Process automation and generation of key insights 3. Development of data models and executive dashboards **Advanced Data Analyst – 100% ON-SITE WORK** **Location:** Santiago de Surco, Lima \- Peru **Job Objective** Analyze commercial, sales, and market information for clients in the fast-moving consumer goods (FMCG) sector, participating in ETL processes, information automation, and insight generation to support strategic and operational decision-making. **Main Requirements** **Education and Experience** Bachelor's degree in Engineering, Statistics, Economics, Computer Science, or related fields. Minimum 4–5 years of experience in data analysis. Proven experience or knowledge in commercial data analysis for FMCG companies. Experience in ETL processes, report automation, and commercial information processing. Experience with Sell-In, Sell-Out, coverage, distribution, market share, quota attainment, and performance metrics by channel, customer, region, or category. Experience working in FMCG distributors and/or corporate companies. Experience in both modern and traditional FMCG channels. Experience in Sell-In and Sell-Out analysis. **Technical Skills** Advanced Excel. Advanced SQL for data extraction, transformation, and analysis. Proficiency in handling large-scale databases and commercial data models. Experience with Google BigQuery. Python for data analysis, automation, and information processing. Knowledge of ETL processes, integration of data sources, and data validation. Familiarity with Power BI, Tableau, or other visualization tools is desirable. **Main Responsibilities** Analyze commercial information for FMCG sector clients. Participate in commercial information extraction, transformation, and loading (ETL) processes. Automate analytical processes, validation, reporting, and indicator generation. Develop SQL queries, data models, and analytical processes in BigQuery. Evaluate Sell-In, Sell-Out, coverage, market share, inventory turnover, and commercial performance indicators. Create executive dashboards and reports for commercial users and management. Respond to internal and external user requests, providing analytical support to commercial departments. Work Location: SANTIAGO DE SURCO \- 100% ON-SITE Working Hours: Mon\-Fri 08:30 AM \- 05:30 PM \- Salary: S/.1,426\.45 \- S/.4,351\.68 per month Workplace: On-site employment