Malt welcome

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
1 recommendation
  • Suggested rate
    €220 / day
  • Experience8-15 years
  • Response rate50%
  • Response time1 hour
The project will begin once you accept Pedro's quote.
Location and workplace preferences
Location
Oporto, Portugal
Remote only
Primarily works remotely
Verifications

Freelancer code of conduct signed

Read the Malt code of conduct
Verified email
Reputation
1Followers
30Repos
11Gists
176Reputation
6Bronze
2Silver
0Gold
Languages
Categories
Share this profile
These freelancer profiles also match your search criteria
Agatha FrydrychAF

Agatha Frydrych

Backend Java Software Engineer

Baptiste DuhenBD

Baptiste Duhen

Fullstack developer

Amed HamouAH

Amed Hamou

Senior Lead Developer

Audrey ChampionAC

Audrey Champion

Web developer

Skill set (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
    March 2015 - Today (9 years and 9 months)
    Rua Julio Dinis, n 728, 5º andar, sala 516, 4050-012 Porto, Portugal
    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)
1 recommendation
SR

Simão Rio recommend Pedro

Simão RioSR
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