Pedro Oliveira de Castro
Pedro Oliveira de Castro

Data Analyst

Open to offers · Member since 2 Oct 2026
Location
São Paulo, Brazil
Desired salary
Unspecified
Work preference
Remote Only / Full Time
Experience level
Mid

About

Professional summary

I am a mid-level Data Analyst with over three years of experience across the data lifecycle, including source extraction, transformation, quality assurance, governance, and reporting delivery. I specialize in building reliable data products that help business stakeholders make informed decisions.

I design and maintain multi-source ETL/ELT pipelines that integrate relational databases, spreadsheets, and APIs. My work includes canonical key generation, source-priority deduplication, volumetric reconciliation, and consistency validation before data releases.

I have advanced experience with SQL Server, complex joins, CTEs, window functions, dimensional modeling, Power BI, DAX, Power Query, and Excel. I build Star Schema models and self-service reporting environments used by operations managers and executive leadership.

Data quality, lineage, and governance are central to my work. I maintain metric dictionaries, document business rules and data lineage, and establish standardized KPI definitions to create a single source of truth across teams.

I also automate analytical workflows using n8n and LLM-powered assistants, applying structured output schemas and validation layers against raw database queries. I am developing my Python, Pandas, Git/GitHub, and cloud data warehousing skills while seeking remote-first, high-autonomy data opportunities.

Skills

35 capabilities

Tech stack & tools

Working toolkit

Development

Languages & Frameworks

Libraries

Experience

Career history

Data Analyst (Mid-Level) E3 Brasil Eco Eficiência Energética

I build and maintain multi-source ETL/ELT pipelines integrating relational databases, spreadsheets, and APIs. I implement canonical keys, source-priority deduplication, volumetric validation, and release quality checks.

I orchestrate scheduled automation workflows with validation and error-handling checkpoints, maintain data governance documentation, and deliver Power BI reporting for three corporate clients and approximately 70 branches. I also lead pilot projects, develop LLM-powered analytical assistants in n8n, and translate stakeholder needs into data deliverables.

Project Manager E3 Brasil Eco Eficiência Energética

I coordinated an equipment implementation project across approximately 600 branches, tracking physical-financial progress and quality indicators.

I designed progress and performance dashboards for executive leadership and managed communication among technical teams, clients, and suppliers to mitigate schedule and integration risks.

Junior Data Analyst E3 Brasil Eco Eficiência Energética

I monitored and analyzed energy-efficiency indicators for one client with approximately 50 branches across two states. I identified KPIs and improvement opportunities related to energy consumption and cost reduction.

I supported continuous-improvement initiatives, operational performance analysis, and communication between clients, suppliers, maintenance teams, and field operations.

Network Support Analyst Network Support

I provided technical support for automation and monitoring equipment, diagnosing failures and supporting maintenance planning to restore operational conditions.

I tracked field occurrences and assisted with the resolution of technical problems in coordination with operational teams.

Education

Learning history

Saint Leo University

Bachelor of Science, Information Technology

In progress. Expected completion in December 2026. All undergraduate coursework is conducted in English.

Universidade Anhembi Morumbi

Bachelor of Arts, Civil Aviation

Completed in December 2022. Studies included operational logistics, quantitative methodology, and procedural compliance.

This professional hasn’t added portfolio projects yet.

This professional hasn’t listed any services yet.

Jobs Talent AI Tools Salaries
Menu