You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Marco AlencastroMA

Marco Alencastro

Data Analyst

€324/day
Rio de Janeiro, BR
3-7 years

Average response time: 1 hour

About Marco

Data Analyst and Data Engineer with over 5 years of experience in Business Intelligence, Analytics and Data Engineering, working end-to-end from requirements gathering to the delivery of dashboards, reports, and strategic KPIs.

Strong experience developing solutions using Power BI, SQL, Python, and Databricks, including data modeling, ETL/ELT processes, KPI development, pipeline automation and data visualization. Proven background supporting enterprise projects across industries such as banking, healthcare, education, retail and oil & gas.

Analytical and results-oriented professional with the ability to translate business requirements into clear, actionable insights, improving data quality, operational efficiency and data-driven decision-making.

Follow my contacts

🔗Portfolio - 🔗LinkedIn - 🔗GitHub -
  • Portuguese

    Native or bilingual

  • English

    Basic

  • Spanish

    Basic

Remote only
Primarily works remotely

Experience

  • SENAI
    Data Engineer
    DIGITAL AND IT
    August 2025 - Today (10 months)
    Tubarão, Brazil
    -Participated in an educational data analysis and data engineering project, focused on optimizing data processing, automation and data governance in a cloud environment.

    -Contributed to data treatment and transformation processes using Databricks, Apache Spark, Python and SQL, ensuring data quality, performance, and scalability.

    -Supported the design and maintenance of data pipelines, enabling data ingestion and processing into Data Lakes during transformation stages.

    -Implemented data storage structures using MinIO and Azure Storage Accounts, supporting scalable and organized Data Lake architectures.

    -Assisted in loading curated datasets into Data Warehouses, enabling structured data consumption by analytics and visualization tools.

    -Supported pipeline orchestration and automation using Jenkins and Azure Synapse Analytics, enabling reliable and fully automated data workflows.

    -Contributed to the structuring of Azure data services, improving efficiency, security, reliability and scalability of data processes.
    Microsoft Azure Python SQL Jenkins Databricks
  • Ernst & Young
    Data Engineer
    DIGITAL AND IT
    July 2021 - August 2025 (4 years and 1 month)
    Rio de Janeiro, Brazil
    -Participated in data engineering and data governance projects for large organizations in the banking, mining, retail, and healthcare sectors.

    -Contributed to the design and implementation of Data Lakes and data pipelines, supporting data governance, security, and efficiency across enterprise environments.

    -Supported the development of strategic dashboards using Power BI and Grafana, enabling the transition from spreadsheet-based reporting to centralized, reliable analytics platforms.

    -Improved data availability and update frequency through automated ETL processes, reducing manual intervention and minimizing data errors.

    -Enhanced data quality and consistency, providing business teams with a trusted source of information for analysis and decision-making.

    -Engaged in frequent requirements discussions with clients, ensuring business needs were clearly understood and solutions aligned with stakeholder expectations.
    Microsoft Power BI SQL Data integration (ETL, ELT and data warehousing) Power Apps Power Automate
  • Solutic
    Business Analyst
    DIGITAL AND IT
    March 2020 - July 2021 (1 year and 4 months)
    Macaé, Brazil
    -Contributed to the development of Petrobras’ Management Cockpit, a strategic TIBCO Spotfire dashboard integrating financial and HR data for the Wells department.

    -Participated in requirements gathering, data processing and technical documentation, collaborating with business and technical stakeholders.

    -Centralized previously fragmented spreadsheet-based data into a single reporting platform, improving data accessibility and consistency.

    -Increased data update frequency and reliability through automated ETL processes, significantly reducing manual data treatment.

    -Enhanced managerial decision-making by delivering consolidated KPIs, standardized reports and interactive visualizations.

    -Supported project delivery using the Agile SCRUM methodology, contributing to improved efficiency and collaboration.
    TIBCO Spotfire Microsoft Power BI Scrum

Recommendations

Be the first to recommend Marco

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • MBA
    USP/Esalq
    2024
    Data Science & Analytics
  • Bachelor
    Universidade Veiga de Almeida
    2014
    Computer Science

Certifications

Skill set

Categories