Guilherme Lamb
Angestellt, Data Engineer, Lojas Renner S.A
Berlin, Deutschland
Über mich
Professional with 4+ years of experience in Data Analysis related positions with strong knowledge in time series data, having skills in statistical analysis and predictive modeling. Highly organized, detail oriented and constantly looking for improvement. Able to provide valuable insights to help companies make informed and strategic decisions.
Werdegang
Berufserfahrung von Guilherme Lamb
Bis heute 8 Monate, seit Feb. 2024
Data Engineer
Lojas Renner S.A
- Data collection, cleaning, and processing using Python and Pyspark inside Databricks environment; - Development of ETL/ELT processes using Azure Data Factory and Databricks Jobs; - Data ingestion through APIs; - Development of tables in different layers (Bronze, Silver and Gold); - Code versioning and CI/CD using Azure DevOps; - Query optimization; - Assist business team with complex SQL queries.
2 Jahre und 10 Monate, Apr. 2021 - Jan. 2024
Senior Data Analyst
Lojas Renner S.A
- Point of contact between technical team (data engineering/data science) and business area; - Data analysis and management of the data-driven supply; - Development of a sales forecast model based on inventory turnover; - Development of a model for detection and treatment of anomalies in sales forecast data; - Development of Python/Pyspark scripts to automate tests; - Development of ETL pipelines; - Query optimization; - Query in databases using SQL; - Development of dashboards using Power BI/Databricks.
8 Monate, Aug. 2020 - März 2021
Market Intelligence Analyst
Laureate International Universities
- Worked in the data processing team, responsible for data collection, wrangling, and processing using SPSS, Alteryx, and Python; - Development of ETL process using Alteryx; - Elaboration of dashboards in Excel and Tableau; - Elaboration of a prioritization matrix, using linear regression; - Assistance in the elaboration of questionnaires using softwares like Qualtrics and Sawtooth.
1 Jahr und 11 Monate, Mai 2018 - März 2020
Trainee of Technical and Technological Services
SENAI Technology Institute of Petroleum, Gas, and Energy
- Collect, treatment, and analysis of equipment data; - Development of performance indicators (KPI's); - Preparation of consulting reports for clients; - Participation in research and development projects (acting from the elaboration of scope, requirements matrix, risk assessment, physical and financial schedules, and return on investment calculations to subsequent execution and progress measurement); - Conducting consultancy in energy efficiency (electrical, thermal, and steam reuse).
Ausbildung von Guilherme Lamb
1 Jahr und 1 Monat, Feb. 2015 - Feb. 2016
Mechanical Engineering
RWTH Aachen University
Exchange student
7 Jahre, Aug. 2010 - Juli 2017
Mechanical Engineering
Instituto Federal de Educação, Ciência e Tecnologia Sul-Rio-Grandense
Sprachen
Portugiesisch
Muttersprache
Englisch
Fließend
Deutsch
Gut
Spanisch
Grundlagen