Portfolio

Data Engineer with 10+ years shaping data into reliable business assets. I design data models and build pipelines using Python and SQL, guided by functional programming principles. My process is systematic: identify root causes, test solutions, document clearly. My objective is constant—data products that generate real value: lower costs, reduced decision risk, and sustainable revenue growth..

Linkedln

My blog posts

• Data Engineering in a Nutshell

Skills:

1. Domain knowledge and problem-solving
2. Data modeling techniques
   • Relational
   • Dimensional
3. Database Administration and Query Optimization
   
4. SQL Language
5. Python Language
   • Functional Programming Principles
6. Data integration
   • Data Profiling and Cleaning
   • Idempotent ETL/ELT pipelines
   • Kimball Data Warehousing/BI methodology
     
7. Data governance and quality management
   
8. Cloud Computing:
   • AWS Services (Redshift, RDS, IAM, S3 Bucket, and Glue)
   • GCP - BigQuery
   • Snowflake Data Warehouse
     • Data model optimization,
     • Data partitioning,
     • Clustering, and compression techniques.
       
9. Data visualization & Data Storytelling
   • DAX Power BI

Work samples:

1. Data engineering.

• Simple ETL pipeline(log, csv, xlsx)
• Python ETL with Snowflake
• Data ingestion with Airflow
• Data quality checklist
• RestFul API Request Optimization
• Optimizing SQL Logic

2. Public data analysis.

• EDA - Customer Satisfaction Level analysis
• EDA - NYC Taxi Trip analysis

3. Data visualization.

• SEPLAG-RJ BI Dashboard

4. Apps

• Data Anonymization Tool
• Burnout Assement Tool
• GAYA ICU - Intensive Care Unit AI system (prototype)
• Yaki In Box

Contact

• email: jayronsoares@yandex.com