Portfolio

I am a Data Engineer with over 10 years of experience working with data to support practical business solutions. I have solid experience in data modeling and in building data pipelines using Python (functional programming style) and SQL. I enjoy solving problems by identifying root causes, testing and applying solutions, and maintaining clear documentation. My focus is on ensuring the return on investment (ROI) of data products by reducing costs, mitigating risks in data-driven decisions, and increasing revenue.

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 Website
• SEPLAG-RJ Dashboard

4. Apps

• Data Anonymization Tool
• Burnout Assement Tool(English)
• Burnout Assement Tool(Portuguese)
• Business Data Health Diagnostic
• GAYA ICU - Intensive Care Unit AI system (prototype)

Contact

• email: jayronsoares@yandex.com