João Pedro Lopes Gonçalves
Data & AI Engineer
Computer Engineering student at Instituto Federal Fluminense, working with data, automation, and workflow optimization in engineering environments. My experience focuses on building practical solutions that reduce manual work, improve data reliability, and support operational decisions for technical and project-oriented teams.
Current Role
BTG Pactual
Data & AI Engineer(Internship)
Jul 2026 - Nov 2026
Rio de Janeiro, RJ, Brazil · Remote
- • Worked on database consolidation and processing optimization initiatives that reduced effective processing time by approximately 87%, saving approximately 176 processing hours in a comparative cycle while handling 29% more records.
- • Developed end-to-end data engineering and automation solutions within BTG Pactual's Data & AI team using Python, SQL, Pandas, Polars, and PySpark, transforming fragmented operational data into standardized, traceable datasets.
- • Built and maintained AWS data pipelines using S3, Athena, Glue, Lambda, ECS, API Gateway, and EventBridge, organizing raw and curated datasets for operational and analytical consumption.
- • Orchestrated automated workflows using Apache Airflow DAGs and Kubernetes CronJobs, implementing dependency management, retries, timeouts, and monitoring through CloudWatch and Slack alerts.
- • Consolidated credit assignment and payment remittance data through SQL Server scripts, staging views, and stored procedures, standardizing heterogeneous schemas and business rules while supporting initial loads and incremental ingestion.
- • Developed SQL-based analytical datasets and Power BI dashboards to track operational performance, collaborating with business and development teams on requirements, technical documentation, and delivery through Azure DevOps.
Experience
TechnipFMC
Project Engineer(Internship)
Sep 2024 - Jul 2026
1 yr 11 mos · São João da Barra, RJ, Brazil · Hybrid
- • Developed and implemented automation solutions for engineering and project management workflows using Python, VBA, SQL, Oracle Database, and Microsoft 365 tools.
- • Supported large-scale data management processes, including extraction, validation, transformation, and structuring of corporate data from Oracle databases.
- • Designed and explored AI-powered automation solutions, including integrations with LLMs and AI agents for data analysis, document review, workflow execution, and decision-making.
- • Contributed to continuous improvement initiatives applying Lean and Kaizen principles, optimizing workflows and earning the Best Kaizen of the Quarter award at TechnipFMC.
- • Built and maintained advanced Power BI dashboards with complex DAX, Power Query M, relational modeling, table joins, and data transformation logic.
- • Collaborated with global engineering teams, project management, and cross-functional areas to identify bottlenecks and implement scalable solutions.
- • Used English daily to analyze technical documentation, communicate with global stakeholders, and support the alignment of international teams.
Education
Instituto Federal Fluminense
B.S. in Computer Engineering - Campus Campos Centro
2022 - Early 2027
Instituto Federal Fluminense holds the maximum score from the Ministry of Education (MEC), ranking among the best-evaluated federal institutions in the country. The Computer Engineering program covers embedded systems, digital circuits, operating systems, algorithms, and software engineering.
Certifications
Excel from Basic to Advanced, Macro, VBA + Power BI
Udemy · Jan 2025
JavaScript in 7 Days + Real Projects
Udemy · Aug 2024
Python 3 from Basic to Advanced
Udemy · Feb 2024
Git Complete: From Basic to Advanced
Udemy · Nov 2023
Power BI Complete - From Basic to Advanced
Udemy · Sep 2023
Study Areas
- Embedded Systems
- Algorithms
- Operating Systems
- Digital Circuits
- Software Engineering