
English:
Upper Intermediate
Mexico
UTC -06:00
America/Mexico_City
Senior Data Architect
Senior Data Architect with over 14 years of experience specializing in data solutions and data warehousing. Proficient in implement and manage advanced data solutions using Snowflake, Redshift, Spark, and PySpark. Strong background in model and architect modern data solutions that optimize data accessibility, integration, and analytics across diverse business units.
Want to hire this engineer?
Check if Juan is availableExpertise
Years of commercial development experience
14 years of experience
Core technologies
Other technologies
Project Highlights
Steven Douglas
Dec `23 - Mar `24
3 months
Steven Douglas
Consulting firm that provides services to different clients. Confidential client
Responsibilities & achievements
• Develop and implement scalable data pipelines on Azure to process and analyze large volumes of data from diverse sources. • Use Azure Synapse to develop robust data models, execute high-performance queries, and facilitate advanced analytics, ensuring data availability and consistency across the organization. • Optimize complex queries to improve performance of sales data reporting system, reducing query execution time by 50%. • Lead the migration of data from legacy systems to a new SQL Server database, ensuring data accuracy and consistency. • Develop stored procedures and functions to automate financial reporting tasks, reducing manual effort by 60%.
Rackspace Technology
Aug `20 - Jul `23
3 years
Rackspace Technology
He served as a leading provider of cloud solutions in AWS & Azure, guiding engagements from the design phase to the implementation of innovative data solutions leveraging the latest Big Data frameworks.
Responsibilities & achievements
• His expertise extended to data modeling, ensuring efficient and scalable structures for optimal performance. In addition to integrating data from diverse sources into Data Warehousing and Data Lake solutions, he also had extensive experience in Azure and AWS Databricks. • Leveraging PySpark and Spark, he developed and optimized ETL processes to handle large volumes of data efficiently. • As part of a cloud migration project for a multinational corporation, he led the implementation of Azure network infrastructure to support the deployment of critical applications. Utilizing Azure VNets and Subnets, he designed a scalable and secure network architecture that facilitated seamless communication between various application components while ensuring compliance with organizational security policies. Additionally, he integrated Azure AD for centralized identity management, enabling single sign-on (SSO) and role-based access control (RBAC) for Azure resources. Leveraging Azure ExpressRoute, he established private connections between on-premises data centers and Azure, ensuring low-latency and high-throughput connectivity for mission-critical workloads. He not only led technical implementations but also led teams, orchestrating collaborative efforts to deliver successful outcomes. He spearheaded multiple projects, including data migrations and modernizations, where he played a pivotal role in implementing Snowflake as data warehousing solutions.
Walmart
Jul `19 - Aug `20
1 year
Walmart
As a Senior Data Architect Manager at Walmart, he led a team responsible for designing and implementing scalable and robust data architectures to support the company’s extensive data infrastructure.
Responsibilities & achievements
• In collaboration with cross-functional teams, he developed comprehensive data models tailored to Walmart’s business needs, ensuring optimal data organization and accessibility. • With his expertise in Azure services, including a new implementation of Databricks, he orchestrated the deployment of advanced analytics pipelines. This initiative significantly enhanced their data processing capabilities and provided the data science team with powerful tools to derive actionable insights from vast datasets. • Through effective leadership and mentorship, he fostered a culture of continuous learning and development, enabling his team to excel in their roles and contribute significantly to the company’s overall success.
Cognizant
Aug `18 - Jul `19
10 months
Cognizant
Project: Pharmaceutical industry
Responsibilities & achievements
His role also involved automating data pipelines and implementing real-time data integration solutions using Azure Blob Storage and HDInsight to streamline operations and support decision-making. Further, he designed and managed ETL processes to ensure efficient data flow and integrity across multiple platforms and systems. He collaborated with cross-functional teams to implement scalable machine learning models for predictive analytics, enhancing drug development processes. His role also involved automating data pipelines and implementing real-time data integration solutions to streamline operations and support decision-making.
Cloud Continuity
Jan `18 - Jul `18
6 months
Cloud Continuity
He worked as a partner with the Microsoft Team building Data Solutions in Azure for the Tax Authority of Mexico (SAT).
Responsibilities & achievements
He developed a Big Data solution using Data Lake, Data Factory, and ETLs Design Patterns. He designed and implemented database schemas for various OLTP applications, ensuring optimal data storage and retrieval capabilities for one year. He also gained experience with reporting tools such as Power BI.
IBI Group
Mar `17 - Jan `18
10 months
IBI Group
IBI Group: Toll Systems
Responsibilities & achievements
• Provide technical leadership in all phases of data reports for Toll Systems from discovery and planning, through implementation and delivery. • Participate in troubleshooting and performance optimization with the BI and Data Engineering teams. • Develop and maintain ETL processes for seamless data integration across different systems. • • Collaborate with business stakeholders to gather requirements and translate them into effective database designs.
Edenred
Jul `16 - Mar `17
8 months
Edenred
Edenred: financial services company
Responsibilities & achievements
He worked through all stages of the data solution life cycle, including analyzing and profiling data, creating conceptual, logical, and physical data model designs, and providing guidance on SSIS and analytics solutions. • He had extensive experience working with datasets containing hundreds of millions of records, such as gift vouchers and e-gift cards. He established data architecture principles and built data models that facilitated the implementation of business architecture. In terms of database management, he administered SQL Server databases, implemented performance tuning strategies, and ensured data integrity and security.
Philip Morris International
Mar `15 - Jul `16
1 year
Philip Morris International
Philip Morris International: tobacco manufacturer
Responsibilities & achievements
He developed and re-engineered ETL processes, optimizing them by transitioning to Transact-SQL interfaces to enhance performance and streamline data pipelines for sales. • He possessed extensive experience with dashboard tools, web customizations, and advanced reporting, particularly for the Canada Revenue Agency. Additionally, he adhered to best practices in data loading, table design, and job execution. For more than one year, he played a key role in the development of OLTP applications, where he focused on creating efficient database schemas and optimizing data storage and retrieval processes.
Intellego
Jul `12 - Jan `15
3 years
Intellego
He successfully led data projects for more than 3 years, including orchestrating seamless data integration with various source systems such as CRM platforms, ERP systems, and third-party APIs.
Responsibilities & achievements
• His experience encompassed data modeling, including conceptual, logical, and physical data modeling. Additionally, he had a solid background in working with ETL processes using tools such as SSIS, Informatica, and OBI. • He possessed expertise in data visualization and implemented robust data quality checks and governance policies to ensure the accuracy and consistency of data within the data warehouse. Furthermore, he had experience in predictive analytics, forecasting, and advanced analytics.
Paasel Consulting
May `10 - Jul `12
2 years
Paasel Consulting
Paasel is a leading company in the development of Business Analytics tools.
Responsibilities & achievements
Proficient in deploying and managing database platforms, including Oracle and MySQL. Adept at performance tuning, query optimization, and database indexing techniques. Extensive experience in crafting and optimizing complex SQL queries for optimal performance. Proficient in configuring and maintaining high availability solutions, such as clustering, replication, and failover mechanisms, to ensure uninterrupted access to critical data. Experience building complex PHP applications.
Education
Higher education in Computer Science
Agency
10-50
GMT-3
Uruguay
Core Expertise
Industries
Logistics & Transportation, E-Commerce & Retail, Banking & Finance, Arts & Culture, Branding, design, web development, Augmented reality, SaaS
Want to hire this engineer?
Check if Juan is available