Junior Data Engineer | Junior Data Analyst

Junior data professional with hands on experience in SQL, Python, data analytics, and cloud based data platforms, focused on data quality and analytics ready datasets.

View Projects GitHub LinkedIn Download Resume (Data Engineer) Download Resume (Data Analyst)
AWS Certified Data Engineer – Associate IBM Data Engineering Professional Certificate

Projects

End-to-End E-commerce ETL Pipeline (AWS → Snowflake)

Designed and implemented an end-to-end ETL pipeline for e-commerce data using AWS Glue and Amazon S3, loading curated datasets into Snowflake for analytics and reporting. Included SQL-based transformations and data validation.

AWSS3GlueSnowflakeSQLPython

Repository →

COVID-19 ETL Pipeline (Python → PostgreSQL)

Automated ingestion and cleaning of Mexico COVID-19 data. Loaded to PostgreSQL via Docker; queried with SQL for validation and exploration.

PythonSQLPostgreSQLDocker

Repository →

RDS ↔ QuickSight (Secure VPC)

Deployed a MySQL instance on Amazon RDS, secured via VPC and security groups, and integrated it with QuickSight for building interactive data visualizations. Included detailed documentation of IAM policies and network security design.

AWSRDS (MySQL)QuickSight

Repository →

Aurora + EC2 Connectivity

Built an Amazon Aurora (MySQL-compatible) cluster and connected it securely from EC2. Covered endpoints, security groups, and connectivity validation.

AWSAuroraEC2

Repository →

Skills & Tools

Programming

Python, SQL

Databases

MySQL, PostgreSQL, IBM Db2

BI & Analytics

Amazon QuickSight, Google Looker, IBM Cognos

Cloud & Infastructure

AWS, Snowflake, Docker

Version Control

Git

Familiar with

MongoDB, Cassandra, Airflow, Kafka, Spark, Hadoop

Core Competencies

ETL Pipeline Development • Data Modeling • Analytical Thinking • Documentation • Teamwork

Contact

Phone: +52 686 108 3152

Email: rubenenc.jr@gmail.com

Also on LinkedIn and GitHub.