Browse profiles Post a project
Malt welcom

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 freelancer profiles on Malt.

Pedro Magalhães

Data Analytics & Business intelligence Expert

Works remotely from Oporto

  • 41.1494
  • -8.6108
  • Suggested rate £195 / day
  • Experience 7+ years
  • Response time 1 hour
Propose a project The project will begin once you accept Pedro's quote.

This freelancer is available full-time but hasn't confirmed their availability in over 7 days.

Propose a project The project will begin once you accept Pedro's quote.

Location and workplace preferences

Location
Oporto, Portugal
Remote only
Primarily works remotely

Preferences

Business sector
Would prefer to avoid:
  • Defense & Military
  • Restaurants & Food Service

Verifications

Freelancer code of conduct signed
Read the Malt code of conduct

Verified email

Reputation

Github

Github : pmags pmags
  • 0 Followers
  • 25 Repos
  • 11 Gists

Languages

  • Portuguese

    Native or bilingual

  • English

    Fluent

  • Spanish

    Fluent

Categories

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,

Experience

Mosaic.pt

Partner

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

March 2015 - Today (7 years and 11 months)

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 (4 years and 5 months)

• 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

Associate

September 2007 - July 2010 (2 years and 10 months)

Price Waterhouse Coopers

Associate

September 2007 - March 2010 (2 years and 6 months)

Parte integrante de equipas de auditoria de grandes empresas. Responsabildiade sobre a coordenação de várias equipas de trabalho.

Simão Rio - Mosaic.pt

15/07/2021

I have worked with Pedro Magalhaes in data analysis projects, encompassing time-series processing, on several areas, such as risk analysis, marketing and c-level reporting. In those projects Pedro has demonstrated a strong knowledge of statistics advanced technics, econometrics and data mining, combining his academic background with an excellent capability of quickly leveraging new tools/technics. Our clients covered multiple areas, including institutions of international reputation across the finance and retail sectors. Pedro demonstrates a great capability of technical execution, with an excellent drive and autonomy balancing it with the ability to teamwork and maintain good personal relationships.

Education

  • Post Graduate

    Porto Business School

    2015

    Develop analytical, decision-making and implementation skills in the area of marketing. Develop soft skills such as communication, teamwork, leadership and communication. Attend Master Classes taught by national and international lecturers, addressing topics such as Organisational Strategy and Communication, Design Thinking, Leadership, Data Mining or Digital Transformation.

  • Licenciado / Bachelor

    FEP U. Porto – Economics and Management

    2007

    The undergraduate degree course in Economics it is known for its high quality standards and excellent employment records upon graduation. The curriculum of the course has several disciplines in Theoretical Economics and Applied Economics, as well as disciplines in Mathematics and Statistics that provide the necessary quantitative foundations. The course also has a strong component of disciplines in Management and Accounting. In the final semester, some options are offered to allow students to personalize their academic profiles. Actividades extra curriculares: - Voluntário no programa de integração de alunos Erasmus da Faculdade de Economia do Porto. Funções: acolhimento e integração de estudantes que provêm de outras Universidades- - Visita ao parlamento Europeu pela FEP a convite da Dra Elisa Ferreira - Presidente da Comissão do 3º ano de economia - Certificado de Profeciency in English

Certifications