Henrique Cazarini Pereira

Data Engineer @ Lima Consulting Brasil

About

I am a rising data engineer with over 8 years of technical and leadership experience, mastering SQL (optimized queries, window functions, CTEs), Python (OOP, Big Data, APIs), and cloud platforms like GCP (BigQuery, Dataflow, Storage, Dataproc) and Databricks (Structured Streaming, Delta Lake). My strong foundation in residential automation, electrical engineering, and team coordination has honed sharp analytical skills, complex problem-solving, and high-impact project management, including training over 150 professionals. Currently at Lima Consulting Group, I maintain 130+ critical jobs and 500 notebooks in Databricks, develop end-to-end pipelines like sales/IPTV tracking (Dataflow extraction, Spark with Medallion architecture, BigQuery loading), and integrate APIs (Meta, GA4) to optimize performance and stability. Key projects include Tag Match Validator (R$500k annual cost reduction) and job monitoring with Delta Tables and ClickUp. My passion for innovation includes awards at the NASA Space Apps Challenge Hackathon 2018 (1st place in São Paulo, global nomination as Asgardians Team leader) and creating training materials in programming, electrical, electronics, and networks. Holding a Precision Mechanics degree (FATEC-SP) and pursuing a postgraduate in Database Engineering (UNICAMP, 2027), I seek challenges to advance in lakehouse, MLOps, and scalable solutions. 🚀

Country

Brazil

City

São Paulo

Industry

Mechanical Or Industrial Engineering

Skill

Engenharia de dados, Python, SQL, Azure Databricks, Google Cloud Platform (GCP), Gestão de projetos, Gestão de inovação, Desenvolvimento de produtos, Desenvolvimento de novos negócios, Desenho técnico, AutoCAD, Autodesk Inventor, Robótica, Desenho mecânico, Automação residencial, Torno mecânico, Mecanica de Precisão, Projetista, Desenho Industrial, Automação comercial

Experience

Data Engineer

Lima Consulting Brasil

2024-10 - Present · 2 yrs

São Paulo, Brasil

• Critical Infrastructure Management: Maintained and optimized 130+ critical data jobs (SAP, Investments, GA4, Teradata) and 500+ Databricks notebooks • Data Pipeline Development: Engineered end-to-end sales tracking pipeline using Databricks, BigQuery, and GA4, processing tens of millions of data points for executive decision-making • Architecture & Migration: Refactored and migrated 20+ processes to new Databricks workspace, implementing Medallion architecture for improved scalability and performance • Integration & Automation: Integrated external APIs (Meta, GA4, Webprice) with automated data ingestion using Dataflow and PySpark for real-time business intelligence • Advanced SQL Optimization: Designed and optimized complex queries across BigQuery, Teradata, Oracle, and SQL Server for business analytics • Cost Optimization: Launched Tag Match Validator project, delivering $500K annual cost reduction in data validation processes

Founder

I/O Automação

2022-10 - Present · 4 yrs

São Paulo, Brasil

• Operations Management: Optimized and streamlined internal processes and systems to improve operational efficiency • Team Leadership: Managed technical, field, and administrative teams • Financial Management: Oversaw project budgeting and financial planning

Technical Coordinator

Scenario Automation

2023-9 - 2024-9 · 1 yr 1 mo

São Paulo, Brasil

• Technical Leadership: Coordinated cross-functional technical team, providing expertise and guidance on automation solutions • Team Development: Designed and delivered comprehensive training programs for engineering professionals • Process Innovation: Developed business processes for customer prospecting and technical sustainability • Quality Assurance: Ensured technical excellence and system stability across all engineering operations

Technical Coordinator

Nice Group

2022-4 - 2022-10 · 7 mos

São Caetano do Sul, São Paulo, Brazil

• Portfolio Development: Structured smart home product portfolio aligned with Brazilian market requirements • Process Engineering: Developed organizational processes and post-sales operations • System Improvement: Enhanced documentation and software systems for better performance

Innovation Coordinator

Scenario Automation

2021-6 - 2022-3 · 10 mos

São Paulo

• Digital Transformation: Implemented ERP, CRM, and HelpDesk systems • Technical Training: Developed comprehensive training programs for automation engineering teams • Business Process Design: Created customer prospecting workflows and business processes

Technical Sales & Consulting

Scenario Automation

2020-3 - 2021-6 · 1 yr 4 mos

São Paulo, São Paulo

Vendedor técnico

RoboCore Tecnologia

2019-2 - 2019-12 · 11 mos

São Caetano do Sul / Santana de Parnaíba

• Elaboração de Tutoriais em Arduino, com programação em C++; • Suporte e consultoria em projetos, com foco no desenvolvimento de projetos em C++, HTML e CSS assim como em mecânica; • Venda direta em loja física; • Atendimento telefônico para clientes PJ e PF; • Elaboração de orçamentos formais e negociação de condições para venda; • Desenvolvimento de estratégias de abordagem, bem como padronização de atendimento via e-mail e telefone. • Desenvolvimento de sistema de prospecção e follow-up de clientes; • Definição de personas a serem prospectadas bem como a catalogação de possíveis clientes;

Freelancer - Programador e Técnico de Instalação

2016-4 - 2019-3 · 3 yrs

São Paulo

• Programação de Sistemas de Automação Residencial e Corporativa; • Instalação de módulos de iluminação, controle de Ar Condicionado e Áudio e Vídeo; • Instalação de redes e cabeamento residencial e comercial; • Desenhista de plantas de automação.

Education

Faculdade de Tecnologia de São Paulo - FATEC-SP

Mecatrônica, Robótica e Engenharia de Controle e Automação

2016 - 2019 · 3 yrs

O Tecnólogo em Mecânica de Precisão está habilitado a atender, a montar, a manter, a desenvolver e a projetar sistemas mecânicos, que integram a mecânica e a eletrônica à informática. Trabalha com os conceitos da mecânica tradicional para entender como funcionam os atuadores mecânicos, pneumáticos, hidráulicos e eletromecânicos. Lida com as funções dos sensores ópticos, hidráulico-pneumáticos, mecânicos eletrônicos e outros. Conhecimentos em eletrônica e informática, além da mecânica, fazem parte integrante da sua formação profissional.