Summary

Expertise

Project Highlights

Education

Agency

JM

English:

Upper Intermediate

Juan M.

vetted by Youteam

Vetted by YouTeam

Mexico

UTC -06:00

America/Mexico_City

English:

Upper Intermediate

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 available

Expertise

Years of commercial development experience

14 years of experience

Core technologies

Python 7 years
ETL 14 years
SQL 14 years
Azure 7 years
Spark 7 years
Snowflake 4 years

Other technologies

AWS

Project Highlights

icon
Senior Data Engineer

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%.

Azure
SQL Server
icon
Senior Data Architect

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.

AWS
Azure
ETL
Spark
Databricks
icon
Data Architect Senior Manager

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.

Azure
Databricks
icon
Big Data Senior Associate

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.

Azure
ETL
icon
Big Data Consultant

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.

Big Data Architects
ETL
icon
Data Architect

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.

Business Intelligence
ETL
icon
Data Architect

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.

SQL Server
icon
Data Engineer

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.

ETL
SQL
icon
Data Engineer

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.

ETL
Data Visualization
icon
DBA / Web Developer

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.

MySQL
Oracle
PHP

Education

Higher education in Computer Science

Agency

Web and Mobile development agency #1991

10-50

GMT-3

Uruguay

Core Expertise

AngularJS
AWS
Business Intelligence
Django
Express.js
Full Stack Development
Java
JavaScript
Kotlin
.NET
Node.js
PHP
Python
QA
React.js
React Native
Ruby
Ruby on Rails
Spring
Android
Automated Testing
DevOps
Front End
Go
Laravel Framework
Product management
Scrum
Spring Framework
Swift
Angular 2x
Back End
Team Lead
Project Manager
Scrum Master
Vue.js
Spring Boot
Business Analysis
Flutter
Google Cloud Platform
GoLand
React-Apollo
Next.js
Data Analyst
Nest.js

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