Juan Sebastián Fontalvo Zapata

Juan Sebastián Fontalvo Zapata  new_releases

About

Detail

Senior Data & Analytics Engineer
Colombia

Timeline

work
Job
school
Education
folder
Project

Résumé

Jobs verified_user 0% verified
  • Valtech
    Data Analytics & Optimization Lead public Remote experience
    Valtech
    Mar 2024 - Current (2 years 3 months)
    -Architected and owned data strategy across enterprise clients; designed scalable data platforms using Databricks, BigQuery, and Fabric that reduced dashboard load times by 50%+ and warehouse query runtimes by 55%. -Delivered 7x improvement in ELT pipeline velocity, enabling stakeholders to act on data 24+ hours faster. - Optimized cloud data tables from 100K+ scans per query to <10K through partitioning and clustering strategy; annualized cost savings: $100K+ across clients. -Automated reporting and transformation workflows in Databricks, improving delivery times for key business reports by 3x. -Delivered AI-driven proofs of concept using LangChain and vector databases for semantic search and intelligent summarization across structured and
  • Whip Around
    Data Engineer public Remote experience
    Whip Around
    Nov 2023 - Mar 2024 (5 months)
    -Designed and deployed automated data pipelines in SQL Server; optimized 12+ slow-running queries, improving report generation time by 65%. -Built personalized Metabase reports aligned with customer specifications; delivered 20+ production dashboards with SLA compliance of 99.5%. -Managed SQL Server databases, ensuring high availability and implementing backup/recovery strategies that achieved zero unplanned downtime.
  • Vozy
    Business data analyst
    Vozy
    Nov 2021 - Current (4 years 7 months)
    -Designed and implemented dbt semantic layer from scratch; standardized 40+ KPIs across product, sales, and operations teams, reducing metric definition conflicts by 95%. -Built and maintained Snowflake data warehouse; engineered ELT pipelines (dbt) that consolidated data from 6+ sources and reduced reporting cycle time from 3 days to 4 hours. - Created 15+ interactive dashboards in Looker; dashboards directly informed quarterly pricing decisions and user retention initiatives, impacting $2M+ in revenue. -Partnered with stakeholders to define business requirements and identify reporting gaps; proactively suggested 8+ KPI improvements that prevented erroneous decision-making. - Established data quality frameworks and monitoring; trained 20+
  • Sykes
    Business Intelligence analyst
    Sykes
    Feb 2020 - Nov 2021 (1 year 10 months)
    -Built and maintained real-time operational dashboards; enabled 30+ stakeholders to identify process bottlenecks and implement continuous improvements. Conducted root cause analysis for revenue leakage and ghost call reduction; identified $500K+ in recoverable value through data-driven process recommendations. -Applied Lean Six Sigma methodology to operationalize data insights; trained 15+ team members on metric interpretation and decision-making frameworks. -Developed quality tracking processes and dashboards enabling rapid decision-making; generated trend reports and coordinated cross-functional action plans for process improvement.
  • S
    Market Analyst
    Segmenta
    May 2019 - Dec 2019 (8 months)
    • Developed in-depth competitor analysis identifying key areas of differentiation, enabling better market positioning and strategy formulation. • Conducted market research to identify customer needs and preferences; findings drove successful launch of new product lines. • Led client negotiation processes and managed stakeholder expectations across market research initiatives.
  • Universidad del Norte
    Auxiliar administrativo
    Universidad del Norte
    Feb 2018 - Dec 2018 (11 months)
    • Conducted profitability analysis of administration projects; delivered insights enabling better project selection and resource allocation decisions. •Analyzed project data to support stakeholder decision-making regarding ongoing and future initiatives. • Performed database analysis and data organization supporting project portfolio management.
Education verified_user 0% verified
  • Pluralsight
    Big Data Analytics with Pyspark
    Pluralsight
    Feb 2026
  • Pluralsight
    Streamline Data Queries with LangChain
    Pluralsight
    Oct 2025
  • Pluralsight
    Implement LangChain Solutions in Your Data Workflow
    Pluralsight
    Oct 2025
  • Pluralsight
    Introduction to LangChain for Data Professionals
    Pluralsight
    Sep 2025
  • Google
    Extend Agentspace assistant capabilities
    Google
    Jun 2025
  • Platzi
    Curso de Manipulación y Transformación de Datos con Pandas y NumPy
    Platzi
    Jun 2023
  • Platzi
    Curso de Métricas para Startups en Etapa Temprana
    Platzi
    May 2023
  • Platzi
    Curso de Análisis de Datos con Power BI
    Platzi
    Apr 2023
  • Universidad del Norte
    Bachelor of Business Administration - BBA, Administración y gestión de empresas, general
    Universidad del Norte
    Jan 2013 - Jun 2017 (4 years 6 months)
Projects (professional or personal) verified_user 0% verified
  • C
    Consultoria de Datos
    Jul 2022 - Current (3 years 11 months)
    -Advised 8+ SMBs on data strategy, analytics automation, and reporting infrastructure; helped clients transition from manual reports to automated, scalable BI systems. -Designed and delivered 12+ training programs (Power BI, SQL, Excel) to early-career analysts; 95%+ course completion rate and positive feedback on practical applicability. - Built end-to-end ETL/ELT solutions for clients in e-commerce and logistics; reduced their manual reporting overhead by 40+ hours per month.