Welcome to Pedro's freelance profile!

Malt gives you access to the best freelancers for your projects. Contact Pedro to discuss your project or search for other similar profiles on Malt.

Pedro Magalhães

Data Analytics & Business intelligence Expert

Remote from Oporto

  • 41.1494
  • -8.6108
Propose a project The project will only begin when you accept Pedro's quote.
Propose a project The project will only begin when you accept Pedro's quote.

Location and geographical scope

Oporto, Portugal
Remote only
Works remotely most of the time


Business sector
Would prefer avoiding:
  • Defense & Military
  • Restaurants




Github : pmags pmags
  • 18 Repos
  • 10 Gists



Skills (48)

Pedro in a few words

I’m a Certified Data Analytics and Business Intelligence Specialist, with a background in economics, management, econometrics and a Master degree in Marketing Management. I have been helping businesses, from startups to large public corporations, to gain insights from their data and make better decisions for more than 14 years.

I am passionate about Data and my client's challenges. I enjoy pushing the envelope, answering hard business questions, solving difficult problems, optimizing business processes, writing clean and efficient pipelines and informative Data Visualizations.

My certifications:
- Microsoft Certified: Data Analyst Associate (H859-1477) ;
- Microsoft Certified: Power Platform Fundamentals (H680-4568) ;
- Google Analytics Individual Certification (ID: 43650393) ;
- Google Tag Manager Fundamentals ;
- SAS Customer Intelligence 360 certification

I am experienced in the following fields and technologies:

- Business Intelligence and Analytics: R, Python, DAX, T-SQL, MS-Excel

- Data Mining and Integration: SAS Data Mining, Pentaho Kettle, Knime, Airflow, ETL on Python, Azure Functions for ETL, Power Automate, Data extraction via API, Setting up API using Flask and Plumber

- Data Warehouse and Database development: Azure SQL Data Warehouse, SQL Server, Postgresql, BigQuery

- E-commerce and Web Analytics: Google Analytics and API, Google Tag Manager, Google Ads and API, Facebook Analytics and API, SAS Customer Intelligence 360, SEO Marketing, Data Mining of Social Media, Market Research, Advanced Metrics dashboard

- Big Data: Databricks

- Data Visualization and Applications: Power BI, Google Data Studio, Tableau, R Shiny Apps, Plotly Dash, Dynamic Rmarkdown notebooks, Apache Superset, Power Bi custom Visuals and connectors, Outsystems

- Machine learning and Time Series Forecast: Advanced Linear Model, Random Forest algorithm, Scilik-Learn, Keras, Tidymodel & Caret, Parallel training using azure clusters,




Rua Julio Dinis, n 728, 5º andar, sala 516, 4050-012 Porto, Portugal

March 2015 - Today

Mosaic is a data driven consultancy firm focused on revealing powerful insights from raw data. With a background on finance and economics we were able to help our customers during valuations, Merge & Acquisitions, financial & business restructuring and digital transformation. Mosaic differs from other consultancies in that we leverage our broad business knowledge in order to apply the latest and most advance technology. At Mosaic we speak the same language as financial, factory directors, marketeers or warehouse clerks. We understand the operation from their unique perspective and are able to deliver a solution, not a model. Together with Math Marketing (https://math.marketing/en) we apply to a data driven approach to Marketing and Customer Satisfaction. Data is not enough. Our team understands, refines, analyzes and quickly delivers diagnostics of Martech, Adtech and Data Culture.

Price Waterhouse Coopers

Senior Associate

July 2010 - December 2014

• Garantir a prestação de um serviço de elevada qualidade de acordo com as expectativas do cliente; • Coordenação do trabalho de equipas de auditoria e desenvolvimento das suas competências técnicas; • Gestão do esforço e a motivação das equipas, assim como contribuir para a formação e desenvolvimento de todos os elementos através de um “coaching” ativo; • Responsabilidade quanto ao planeamento do trabalho da equipa e definição da estratégia de auditoria; • Apoio no desenho de sistemas de controlo interno; • Análise de áreas de risco ou complexas em grandes empresas nacionais, nomeadamente consolidação, em SNC e IFRSM • Identificação de oportunidades comerciais. Participei em auditoria de diversos sectores empresariais, como automóvel, imobiliário, embalagens e têxtil, tendo tido a oportunidade de contactar com realidades empresariais distintas. Participei em trabalhos de análise ao consolidado de grandes grupos nacionais.

Price Waterhouse Coopers


September 2007 - July 2010

Price Waterhouse Coopers


September 2007 - March 2010

1 external recommendation

Check out Pedro's recommendations