Portfolio

Data Engineer with over 10 years of experience, focused on turning data into effective business solutions. Collaborating with stakeholders to assess Return on Investment for data-driven solutions, delivering actionable insights.

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 profiling with Pandas
• Data quality checklist
• RestFul API Request Optimization
• dbt Tutorial
• 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 Version)
• Burnout Assement Tool(Portuguese Version)
• Index Analysis Visualization
• GAYA ICU - Intensive care unit AI system (prototype)
  • User and password:
    • user:medico
    • password:clinico

Contact

• email: jayronsoares@yandex.com