Learn Data Skills
Beta
Gustavo Henrique Ferreira

Gustavo Henrique Ferreira

Senior Data Engineer

Coimex Administradora de Consórcios | Curitiba, PR - Brazil

Technologies

My Portfolio Highlights

My New Course

Introduction to SQL

My New Workbook

Analyzing unicorn company data

Data adventurer, fearlessly exploring the depths of complex datasets.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Intermediate SQL

DataLab

Analyzing unicorn company data

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Mycon Consórcio Digital | Aug 2024 - Present

Senior Data Engineer

I am currently working as a Senior Data Engineer at a digital consortium fintech, where I am the technical lead for the engineering team and responsible for the implementation of an AWS data lake. This project aims to integrate the company's data from various sources, such as transactional databases like SQL Server, Google Analytics, and advertising platforms like Google Ads, Facebook Ads, and TikTok Ads. Additionally, I support other data areas, including Data Analysis, Business Intelligence, and Data Science, as well as promoting data democratization within the company, ensuring teams can access and leverage information efficiently. Technologies used: Python Spark AWS (S3, DMS, Glue, Redshift, Athena) SQL (SQL Server, PostgreSQL, Google BigQuery) Apache Airflow Linux
Show More

Mobilize Financial Services | Feb 2024 - Aug 2024

Business Intelligence and Data Analysis Specialist

Data Professional in IT at Mobilize Lease&Co, a subscription car service company by Renault and Nissan, I was responsible for the complete restructuring of the data area. My main challenges included developing the company’s data lake and rebuilding the Data Warehouse (DW) using the Microsoft Fabric platform. I also served as the data focal point between the branches in Brazil and Colombia, as well as being responsible for data reporting to the company headquarters in France. Key Responsibilities: Database Development: Lead the development and implementation of the company’s data lake and Data Warehouse, ensuring data efficiency and integrity. Process Automation: Automate daily processes using Python, Power Automate, Azure Functions, and Logic Apps to improve operational efficiency. Reports and Analytics: Develop and maintain Power BI reports, providing valuable insights for strategic decision-making. Database Administration: Manage SQL Azure and Microsoft Fabric databases, ensuring data security and availability. Ad Hoc Queries: Execute ad hoc queries to provide quick and accurate answers to specific business questions. Technologies Used: Microsoft Fabric SQL Python Power Automate Azure Functions Logic Apps Power BI SQL Azure My role requires both strategic and technical approaches to transforming the company’s data infrastructure, enabling deeper and actionable data analysis. With a combination of skills in development, automation, and data administration, I am committed to delivering innovative solutions that drive Mobilize Lease&Co’s growth and efficiency.

Paraná Banco S/A | Jan 2021 - Nov 2023

Business Intelligence Analyst

I worked as a data specialist for the Investments and Strategic Planning areas, leading the creation and maintenance of the Datamarts for each department, along with their respective data pipelines. I also highlight my role in automating the Variable Compensation processes and promoting a Self-Service BI culture through the development of OLAP Data Cubes. Key Responsibilities: Creation and maintenance of managerial and operational reports. Extraction and analysis of information from databases. Development of ETL processes using Pentaho PDI. Process automation using Python. Creation and maintenance of DAGs in Airflow. Development of OLAP Data Cubes with Analysis Services. I utilized various technologies, including SQL Server, Power BI, Pentaho PDI, GIT, Python, Airflow, and Analysis Services.

Grupo Marista | Jun 2021 - Oct 2021

Data Analyst

Key Responsibilities: Design, develop, and monitor continuous audit projects using SQL, Python, Power BI. Architect and develop machine learning and AI projects for applicable continuous audit work. Support the Compliance Team in investigations (Background Checks, internal ERP reports, due diligence) using data analysis. Tools: Microsoft Office Suite, SQL Server, OracleDB, Python, Power BI.

Olist | Mar 2021 - Jun 2021

Data Analyst

Data Analyst in the Catalog Area, focused on identifying opportunities and generating insights for the business. Key Responsibilities: Managing and maintaining data for the catalog area. Creating and maintaining objects in PostgreSQL databases. Mapping and automating processes using APIs with Python. Developing and maintaining automated routines on Linux virtual machines (Google Cloud). Creating and measuring operational KPIs to monitor productivity. Building dashboards in Redash, Google Data Studio, and Power BI. Tools: Linux Google Sheets Python PostgreSQL Databases AWS Athena Google Cloud Virtual Machines (VM) Jenkins Google Data Studio Redash Power BI

Vivo (Telefônica Brasil) | May 2019 - Mar 2021

Junior MIS Analyst

Key Responsibilities: MIS Analyst. Managing and maintaining operational data for customer service. Creating and measuring managerial, business, and operational KPIs using automated database routines (Stored Procedures). Managing metrics and integrating data across departments using ETL tools. Creating and maintaining objects in Oracle databases. Developing dashboards in Excel and Power BI. Designing incentive campaigns based on operational indicators. Tools: Microsoft Office Suite (Excel, Access, PowerPoint). Oracle Databases. Pentaho. Jenkins. Power BI.

My Education

Take a look at my formal education

Pós-graduação Lato Sensu - MBA, Data Science & Analytics  · (maio deUniversidade de São Paulo | 2022
Bacharelado, Análise e Desenvolvimento de SistemasUniversidade Positivo | 2021
Curso de Extensão, Excel para Negócios e Finanças: Nível Avançado e VBAUniversidade Positivo | 2017
Bacharelado, Educação FísicaUniversidade Positivo | 2017

About Me

Gustavo Henrique Ferreira

Gustavo Henrique hasn't filled in a bio text

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free