Looking for a job

Pedro Mendes

@pedromendes1

Message

Data analyst skilled in SQL, Python, and Power BI driving actionable insights.

Portugal

Message

What I'm looking for

I seek data roles where I can build reliable analytics pipelines and dashboards, collaborate with cross-functional teams, and drive data-informed decisions in a learning-focused, impact-oriented environment.

I am a data analyst with a strong analytical foundation built from engineering and research roles, proficient in SQL, Python (Pandas, NumPy), and Power BI. I transform raw data into reliable, performance-focused dashboards and reports that inform strategic decisions.

My background spans industrial process optimization, academic research in polymer chemistry, and end-to-end data projects analyzing listener behavior, global sales, and job market trends. I have implemented SQL views, advanced queries (CTEs, window functions), and automated reporting to improve data quality and delivery speed.

I value clear communication, reproducible workflows, and mentoring; I hold certifications in Google Data Analytics, Power BI, and SQL, and I build interactive visualizations and KPI tracking solutions that help stakeholders act with confidence.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst

Current

Freelance / Personal Projects

Jul 2024 - Present (1 year 6 months)

Performed end-to-end data analyses of listener, sales, and job market datasets using SQL and Python; built interactive Power BI dashboards and implemented SQL views to improve reporting performance and support strategic decisions.

SQL Python NumPy Power BI Data Cleaning Data Modeling Data Visualization ETL Tableau Jupyter Notebooks

Chemical Engineer

Jamarcol

Oct 2023 - Mar 2025 (1 year 5 months)

Optimized chemical and electroplating processes, built and maintained a centralized process-tracking database, and ensured compliance with industry and environmental standards to reduce operational errors.

Process Optimization Database Management Quality Control Compliance Reporting Data Tracking Root Cause Analysis

Wood Chemistry Researcher

University of Hamburg

May 2020 - Jun 2023 (3 years 1 month)

Researched bio-based polymer synthesis via lignin modification and crosslinking, designed experiments, analyzed results, and supervised postgraduate students to advance sustainable material alternatives.

Polymer Experimental Design Data Analysis Research & Documentation Lignin Chemistry Teaching

Private Tutor & Translator

Concentrarte / Freelance

Sep 2007 - Aug 2019 (11 years 11 months)

Provided translation services and tutored chemistry, mathematics, and English to diverse learners, adapting teaching methods to individual needs over a multi-year freelance engagement.

Tutoring Translation Instructional Design Multilingual Communication Curriculum Adaptation Academic Support Client Communication

Research Assistant

Technical University of Darmstadt

Jun 2018 - Aug 2018 (2 months)

Supported synthesis and characterization of photoreactive benzophenone-functional cellulose polymers and contributed to data collection, analysis, and reporting for lab research projects.

Polymer Synthesis Experimental Support Reporting

Education

Degrees, certifications, and relevant coursework

University of Aveiro

Master of Science, Chemistry

Activities and societies: Thesis: Functional Cellulose Polymers: Synthesis and Characterization of Photoreactive Benzophenone-functional Cellulose Polymers

Completed an MSc in Chemistry with a thesis on functional cellulose polymers conducted at the Technical University of Darmstadt.