Learn Data Skills
Beta
Jose Luis Yañez

Jose Luis Yañez

Certified

Senior Data Engineer

BC Tecnologia | Chile

Technologies

My Portfolio Highlights

My New Project

Cleaning Bank Marketing Campaign Data

My New Certification

Data Engineer Associate

My New Project

Cleaning Bank Marketing Campaign Data

Senior Data Engineer | AWS Data Specialist

My Work

Take a look at my latest work.

course

Improving Query Performance in SQL Server

project

Cleaning Bank Marketing Campaign Data

GitScalaSnowflake
course

Data Manipulation with pandas

DataLab

Bikeshare Insights: Summer in the Windy City

certification

Data Engineer Associate

course

Improving Query Performance in SQL Server

My Certifications

These are the industry credentials that I’ve earned.

Data Engineer Associate

Data Engineer Associate

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Intermediate SQL
Intermediate Python
Data Manipulation with pandas

My Work Experience

Where I've interned and worked during my career.

BC Tecnología | Mar 2024 - Oct 2024

Senior Data Engineer

CENCOSUD Design and implementation of data ingestion processes using AWS Glue, S3, Athena, and JDBC, optimizing data integration. Creation and transformation of data models using DBT and Athena under a four-layer architecture. Organization of data pipelines with Airflow MWAA (AWS), automating critical workflows. Development of a monitoring and unit testing library using Python, Boto3, and Pytest, improving process oversight. Version control management in GitLab and support for CI/CD processes. Management of user stories in Jira Kanban and technical documentation in Confluence. Training data engineers at Cencosud, promoting new architectures and best practices. ACHIEVEMENTS: Introduction of technologies such as EMR and DBT to the company, resulting in more agile development and a cost reduction. Promoted to Data Technical Lead, managing cross-functional projects and driving best work practices.
Show More

Soluciones - an AVOS Tech Company | Aug 2023 - Mar 2024

Senior Data Engineer

COPEC Development of ETL/ELT processes using Glue, Lambda, SQS, and Kinesis with Python under an IaC (Infrastructure as Code) architecture using CloudFormation. Development of data ingestion processes from SAP, SQL Server, and Rest APIs source systems to the corporate Data Lake on S3. Implementation of tables and queries in DynamoDB. Creation of SQL queries using Athena for data sources in S3. Process orchestration with Step Functions. Development of data export APIs for external providers using API Gateway and Python. Data Lake administration with Lake Formation. Creation and updating of git repositories in Bitbucket. CENCOSUD Development of data ingestion processes from Teradata to S3 using Glue and Apache Airflow under a three-layer architecture (raw, processing, reporting). Design, implementation, and tuning of Redshift databases using star schema modeling. Management of SQL queries for review and validation of data loads using Athena. Support in query optimization for MicroStrategy reports. Creation and updating of git repositories in Bitbucket.

Stefanini Group | Jan 2022 - Aug 2023

Senior Data Engineer

TK Elevator • (Atlanta, GA, United States) Creation of ETL processes with data sources from MySQL and Rest API using Azure Data Factory and Databricks in Python. Development of stored procedures, functions, and SQL query optimization in Azure SQL Server. Creation and maintenance of Data Quality reports in Power BI. BANCO DE CHILE Development of data ingestion and transformation processes in Apache Spark, Hadoop, and Scala on Hadoop clusters, under Hortonworks Data Platform infrastructure. Validation of data loads and monitoring using Impala and YARN. Database design and modeling using the Data Vault methodology. Participation in a migration project from Hadoop to GCP using BigQuery, Dataproc, Pub/Sub, and Cloud Shell. ETL process automation and scheduling using Control-M. Creation and updating of git repositories in Bitbucket. Data querys and table structuring with Apache Hive (HiveQL). ACHIEVEMENTS: Optimization of large-scale dataframes, significantly improving performance through advanced optimization techniques with Scala, and participation in the migration from On-Premise Hadoop to GCP, supporting the bank's technological modernization.

FORUM Servicios Financieros | Oct 2020 - Aug 2021

Data Enginer

Design, proposal, and implementation of a datamart project for the commercial department using OLAP cubes in Analysis Services and SQL Server. Development of ETL processes in Pentaho Data Integrator (PDI) and SSIS (Integration Services). Design and implementation of database models using star and snowflake methodologies. Creation of stored procedures, functions, triggers, and SQL query optimization in SQL Server. Creation and automation of analytical reports in Power BI. Creation and updating of git repositories in GitLab. ACHIEVEMENTS: Developed database models using star and snowflake methodologies, improving data structure and successfully implementing a commercial datamart with OLAP cubes, optimizing commercial decision- making.

EY | Nov 2019 - Jun 2020

Senior Data Engineer

• Participation in accounting data analysis projects for various clients nationwide. • Creation of ETL processes using SSIS (Integration Services) and Alteryx Designer. • Design and implementation of databases in Azure SQL Server. • Creation of stored procedures, triggers, and SQL functions. • Participation in and leadership of junior (associate) data engineer teams.

Management Solutions | Feb 2018 - Feb 2019

Consultor TI

N/A

Gestion12 Ingeniería de Software | Jul 2016 - Oct 2017

.NET Developer

- Analysis and gathering of requirements through meetings with clients and end users - Task organization and time estimation using agile methodologies and Team Foundation Services (TFS) - Analysis and design of use cases, class diagrams, sequences and activities using UML. - Software programming with C#, ASP.NET MVC, Entity Framework, Razor, Bootstrap, JavaScript (JQuery, AJAX, AngularJS, ECMAScript) and SQL Server - Version and control of repositories in Git - Creation, implementation and documentation of unit tests in Visual Studio.

My Education

Take a look at my formal education

Diplomado en Gestión de Procesos de Negocios y TI Universidad Técnica Federico Santa María | 2019
Ingeniería en Informática, Tecnología de la informaciónUniversidad Santo Tomás (CL) | 2017

About Me

Jose Luis Yañez

Professional with 5+ years of experience in engineering and data architecture projects with strong experience in cloud environments, with special focus on Amazon Web Services (AWS). I am characterized by my agility, great analytical skills, teamwork

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free