Santiago Gustavo Ayala

Data Consultant @EXL - Analytics Engineer - Data Engineer

Bogota, D.C., Capital District, Colombia

About

Data Engineer & Analyst with experience in Microsoft Fabric, PySpark, Tableau, and Snowflake. I design and optimize data pipelines and dashboards for stakeholders that improve efficiency, ensure data quality, and enable data-driven decisions across teams. Skilled in SQL, databases, and business modeling. My experience also includes leading and working with multicultural teams in the U.S., strengthening my leadership, communication, and problem-solving skills. I bring a blend of technical expertise and business understanding to deliver impact at the intersection of data and strategy. Key Skills: - Data Engineering: Microsoft Fabric, PySpark, ETL, Data Pipelines, dbt - Data Analytics & Visualization: Tableau, Snowflake, SQL, Business Modeling - Programming: SQL, Java, Python (PySpark) - Leadership & Communication: Team Management, Cross-functional Collaboration, Teaching & Mentoring - Other: Data Quality, Process Optimization, Problem Solving, Customer Service

Experience

  • Data Consultant at EXL
    Dec 2024 - Present · 1 yr 8 mos

    •     Designed and automated end-to-end ETL pipelines in Microsoft Fabric using PySpark, reducing data refresh times by 60%+. •     Optimized Snowflake views and tables handling 4B+ daily records, enabling significantly faster aggregation and business insights. •     Built and maintained dbt models with full documentation — column definitions, transformation logic — setting an org-wide standard. •     Integrated data from multiple upstream source systems via APIs and ETL routines into the data warehouse and data lake. •     Diagnosed root-cause data inconsistencies in Snowflake across upstream sources and transformation logic, implementing correct handling to restore data integrity and prevent recurrence. •     Developed dynamic exclusion tables in Snowflake to toggle test users in/out of dashboards on demand, enabling clean QA workflows without polluting production metrics. •     Developed Tableau and Power BI dashboards for cross-functional stakeholders; standardized dashboard design across the organization. •     Partnered with product, ops, and analytics teams to collect requirements, define KPIs, and adapt to shifting business demands. •     Received Early Trailblazer Award Q3 2025 for end-to-end ownership of a high-impact data project.

  • Jefe de servicios de alimentación at Cedar Fair Entertainment Company
    Jun 2024 - Aug 2024 · 3 mos

    Managing and leading a multicultural team keeping in mind planning, budgeting and teamwork to ensure efficient and profitable business, and always providing the best service to guests. In addition to solving guest issues and proposing ideas to better the bussines.

  • Teacher Assistant - Databases and Transactional Systems at Universidad de los Andes - Colombia
    Aug 2023 - Dec 2023 · 5 mos

    Help the teacher with grading, solving student doubts and explaining topics, related to databases, business modeling and transactional systems. Main laguages: SQL and Java

  • Empleado de servicios de alimentación at Cedar Fair Entertainment Company
    Jun 2023 - Aug 2023 · 3 mos

    Working with a multicultural team ensuring efficient and profitable business, and always providing the best service to guests

  • Teacher Assistant - IT in Enterprises at Universidad de los Andes - Colombia
    Jan 2023 - Jun 2023 · 6 mos

    Help the teacher with grading, solving student doubts and explaining topics, related to business modeling, understanding and IT solutions.