Juan Pablo Vilchis Diaz Santana Data & AI Leader | Senior Data Architect |

Senior Consultant/Senior Data Architect

Sparq

Sep 2025 - Current (8 months)

At Sparq, I serve as a Senior Data Architect, playing a pivotal role in shaping high-performance data solutions. I design and implement scalable data pipelines in Snowflake and dbt, enabling the efficient processing of billions of records. By driving cost optimization and improving compute and storage performance, I’ve delivered measurable savings and faster processing speeds. Partnering closely with business and data teams, I translate evolving requirements into robust, future-ready solutions while embedding industry best practices into every layer of our data architecture. Additionally, I leverage my understanding of machine learning concepts, which, while not my primary focus, informs certain aspects of my current project, enhancing th

AI Data and Insights Manager/iBPA Architect

Ascendion

Feb 2025 - Aug 2025 (7 months)

Helping organizations implement AI-powered process transformation by integrating LLMs into business operations through intelligent automation strategies. Key Contributions: Designed and deployed intelligent business processes (iBPA) leveraging LLMs, RAG pipelines, and vector search to automate knowledge-intensive tasks. Mapped end-to-end data flows to support semantic enrichment, document understanding, and conversational AI experiences. Built secure, scalable AI architecture frameworks using Azure OpenAI and Power Platform tools. Acted as a strategic advisor to clients on aligning GenAI use cases with business KPIs and operational goals. Supported presales strategy and technical design for enterprise clients across LATAM, focusing on

Technical Project Manager@Microsoft

Ascendion

Apr 2024 - Dec 2024 (9 months)

Led AI-centric project delivery within Microsoft’s Hardware group, focusing on LLM-driven innovation, data governance maturity, and enhanced user experiences. Key Contributions: Managed cross-functional delivery of LLM-enhanced solutions for hardware telemetry, documentation synthesis, and automated knowledge retrieval. Oversaw integration of vector databases and RAG pipelines to power internal AI agents and improve technical support workflows. Implemented governance frameworks to ensure secure, traceable, and ethical use of training and inference data across teams. Partnered with UX and engineering teams to refine AI user flows, ensuring alignment between interface design and model capabilities. Drove agile project planning and stake

AI Data and Insights Manager/Senior Data Architect

Ascendion

Dec 2023 - Aug 2025 (1 year 9 months)

Led enterprise data architecture initiatives to support scalable analytics, AI-readiness, and cross-functional data transformation across LATAM clients. Key Contributions: Architected cloud-native data platforms and ingestion pipelines to enable AI/ML applications and real-time analytics. Defined data governance standards, metadata models, and lineage tracking to ensure data quality and regulatory compliance. Developed scalable, modular data lake and warehouse architectures using Azure, Spark, and Databricks. Collaborated with executives and engineering teams to align enterprise data strategy with evolving business and AI goals. Drove presales engagements and technical advisory for clients adopting modern data infrastructure across se

Data Manager/Analytics Architect

EY

Mar 2022 - Nov 2023 (1 year 9 months)

Led analytics architecture for a Fortune 100 client’s finance division, delivering AI-ready data platforms and aligning enterprise data strategy with business goals. Key Contributions: Designed and deployed scalable data pipelines supporting advanced analytics and LLM integration (e.g., retrieval-augmented generation, semantic search). Operationalized business-critical datasets using Azure Databricks, Power BI, and Spark to enable real-time insights and downstream AI applications. Drove data quality remediation and implemented governance frameworks to support secure and reliable AI model training. Partnered with cross-functional teams and leadership to advance data maturity and enable adoption of AI/ML capabilities across finance workf

Delivery Manager - Integration/Data Architect

Capgemini

Jul 2021 - Mar 2022 (9 months)

Served as a Data & Integration Architect for the largest insurance company in the Americas, designing scalable, secure architectures to support digital transformation across LATAM operations. Key Contributions: Architected and implemented system integrations using a hybrid cloud stack, including Azure PaaS, IBM App Connect, and WebMethods. Designed enterprise data models and APIs to support real-time data exchange and operational reporting across distributed systems. Conducted gap analysis and technical assessments to optimize performance, scalability, and security of integration layers. Created visual architecture artifacts using ArchiMate and UML to communicate complex integrations to stakeholders. Collaborated with product, securit

Lead Consultant Analytics and EPM

The Hackett Group

Sep 2020 - Jul 2021 (11 months)

Led enterprise data engineering and analytics initiatives for Fortune 500 clients, focusing on scalable finance and HR data platforms using modern Big Data tools. Key Contributions: Designed and implemented end-to-end data pipelines supporting financial planning, sales analytics, and self-service BI. Built and optimized data workflows using Spark, Python, Azure Databricks, and SSIS to accelerate report delivery and data freshness. Integrated Oracle Cloud EPM and Microsoft Power BI to deliver unified insights across business functions. Streamlined analytics delivery models by standardizing data ingestion and transformation patterns across client organizations. Supported Agile-based delivery and collaborated with cross-functional teams

Data Architect

CodeAsync

Jan 2020 - Jul 2025 (5 years 7 months)

Led the design and implementation of AI-enabled data architectures for enterprise clients, with a focus on LLM integration, semantic search, and scalable cloud pipelines. Key Contributions: Architected end-to-end data platforms to support LLM-powered use cases, including vector search, document chunking, and RAG pipelines. Designed cloud-native ETL frameworks and data lakes optimized for AI inference and model training. Implemented metadata strategies and governance models to support data lineage and explainability in generative AI systems. Partnered with clients across Americas and Spain to define AI data strategy, enabling enterprise adoption of LLMs and intelligent agents. Contributed to presales efforts by scoping AI/ML solutions,

Senior Data Architect

CodeAsync

Jan 2020 - Jul 2025 (5 years 7 months)

Led the design and implementation of AI-enabled data architectures for enterprise clients, with a focus on LLM integration, semantic search, and scalable cloud pipelines. Key Contributions: Architected end-to-end data platforms to support LLM-powered use cases, including vector search, document chunking, and RAG pipelines. Designed cloud-native ETL frameworks and data lakes optimized for AI inference and model training. Implemented metadata strategies and governance models to support data lineage and explainability in generative AI systems. Partnered with clients across Americas and Spain to define AI data strategy, enabling enterprise adoption of LLMs and intelligent agents. Contributed to presales efforts by scoping AI/ML solutions,

Senior Enterprise Analytics Consultant (Nearshore)

The Hackett Group

Aug 2017 - Sep 2020 (3 years 2 months)

Delivered nearshore data engineering and BI services to global clients, focusing on high-availability analytics systems using cloud-native tools. Key Contributions: Developed data pipelines for high-volume financial and operational datasets using Spark and Databricks. Created reusable BI assets using Power BI and Tableau, improving time-to-insight and enabling business self-service. Integrated multi-cloud and hybrid data sources to support global reporting standards. Collaborated closely with client IT and business teams to modernize legacy data platforms and introduce scalable solutions.

Enterprise Analytics Consultant (Nearshore)

The Hackett Group

Aug 2017 - Mar 2020 (2 years 8 months)

Supported long-term analytics transformation programs for Forbes 100 and Fortune 500 clients, modernizing reporting architectures and building robust data flows. Key Contributions: Facilitated architecture design and delivery of executive dashboards, KPI forecasting models, and market aggregations. Migrated legacy BI processes to cloud-based platforms, reducing report generation times by over 80%. Designed and maintained data models powering financial and sales analytics across multiple global regions. Led performance tuning and optimization efforts across ETL layers to ensure data quality and processing efficiency.

Expert Software Developer

UST Global

Aug 2016 - Aug 2017 (1 year 1 month)

Expert Software Developer (Contractor)

Esurance

Aug 2016 - Aug 2017 (1 year 1 month)

Led development initiatives for a major digital transformation within Esurance, contributing to the adoption of scalable, modern development environments across the organization. Key Contributions: Spearheaded the migration to a JVM-based development stack, introducing functional and reactive programming patterns to support scalable, low-latency services. Developed high-performance prototypes using Scala, Spring, and Play Framework to showcase modern architectural possibilities. Designed and implemented distributed backend systems with a focus on scalability, reusability, and fault tolerance. Collaborated with architecture and product teams to define service boundaries and integration strategies. Contributed to the standardization of

Expert Software Developer @Esurance

UST Global

Aug 2016 - Aug 2017 (1 year 1 month)

Chief Software Architect

Mediara

May 2016 - May 2017 (1 year 1 month)

Led end-to-end software architecture and engineering strategy for digital product development, aligning cross-functional teams and modern tech stacks to client needs. Key Contributions: Architected multi-platform digital solutions using C#, Java EE, and PHP, ensuring scalability, maintainability, and integration flexibility. Directed a team of 8 developers across front-end, back-end, and full-stack roles, fostering agile collaboration and delivery excellence. Defined software design standards, reusable patterns, and modular system components to improve delivery speed and reduce technical debt. Oversaw technical roadmapping and client engagement to align product architecture with evolving business objectives. Introduced agile best prac

Founder

CodeAsync

Dec 2015 - Jul 2025 (9 years 8 months)

Founded and grew a boutique tech consultancy delivering enterprise data, AI, and integration solutions across LATAM, US and Spain. Key Contributions: Led business development, technical strategy, and client success for Fortune 500 and mid-market clients. Built and scaled cross-functional teams across data architecture, software development, and cloud engineering. Oversaw solution delivery across industries including finance, healthcare, and retail—ensuring high-quality execution under agile and CMMI frameworks. Directed key partnerships, vendor negotiations, and talent acquisition to support long-term client growth. Drove early adoption of cloud-native and AI/ML technologies to position clients for digital transformation.

Senior Associate, Software Engineer

MSCI Inc

Jul 2014 - Apr 2016 (1 year 10 months)

Contributed to the development of data pipelines and analytics systems supporting MSCI’s global real estate index reporting across EMEA, Americas, and ASPAC. Key Contributions: Developed data workflows and automation tools that reduced report generation time from 8 days to 3 hours. Built and maintained ETL components using Python, T-SQL, and SQL Server Reporting Services (SSRS). Supported the creation of standardized forecast models, KPI dashboards, and region-specific market aggregations. Improved data quality and processing performance through system optimization and refactoring. Collaborated with finance and analytics teams to implement scalable, reliable data solutions.

Technical Lead

UST Global

Oct 2013 - Jul 2014 (10 months)

Technical Lead(Contractor)

Carenet Healthcare Services

Oct 2013 - Jul 2014 (10 months)

Lead Programmer Analyst

Sanmina

May 2012 - Aug 2013 (1 year 4 months)

Software Engineer

Comision Federal de Electricidad

Mar 2006 - Apr 2012 (6 years 2 months)

I

Software Developer

INNOX

Aug 2005 - Jan 2006 (6 months)

A

Junior Software Developer

Aullox

Nov 2004 - Jul 2005 (9 months)

Junior Networking Engineer

Universidad Panamericana

Jan 2002 - Jun 2004 (2 years 6 months)

Information Technology Support Staff

Universidad Panamericana

Apr 2001 - Dec 2001 (9 months)

HTML Developer

Microton

Aug 1998 - Aug 1999 (1 year 1 month)

Juan Pablo Vilchis Diaz Santana

About

Detail

Timeline

Résumé