Juan - Business Intelligence Analyst

Experiencia demostrada en SQL.

Experiencia demostrada en Snowflake.

Experiencia demostrada en Python.

Experiencia demostrada en Power BI.

Experiencia demostrada en Excel.

Analyze operational and commercial product, cost, and supplier data across LATAM markets using SQL queries in Snowflake.. Validate and maintain catalog master data, including EANs, billing codes, costs, pack sizes, categories, and product attributes, ensuring alignment with internal standards.. Build queries and controls to identify data inconsistencies, unusual cost variations, missing billing codes, and catalog classification errors.. Automate recurring reviews and operational processes with Python, reducing manual work and strengthening the monitoring of critical data.. Perform quality assurance checks before and after publication to verify that commercial and operational requirements are implemented correctly.. Coordinate incident resolution and process improvements with Category Management, Supply, Commercial, Operations, and Technology teams, documenting findings and priorities.

Founded and manages a coffee boutique and café created with support from Fondo Emprender to promote Huila coffee brands and local producers.. Oversees sales, costs, inventory, suppliers, staff, and daily operations, using business information to prioritize commercial actions.. Built partnerships with eight coffee distributors and coordinated campaigns, events, and marketing initiatives to strengthen local positioning.. Supervises service standards, product quality, and customer experience while coordinating day-to-day execution with a multidisciplinary team.

Analyzed eCommerce sales and campaign performance to support commercial tracking and business decision-making.. Managed strategic requests from Key Account Managers through Hybris and Jira, coordinating implementation with technical and commercial teams.. Performed QA testing to ensure campaigns, content, and platform features worked correctly before publication.. Monitored key metrics and prepared campaign performance reports, identifying opportunities to improve traffic and conversion.. Supported digital marketing execution and cross-functional coordination across business, platform, and technology teams.