Learn Data Skills
Beta
Sebastian Pumarejo

Sebastian Pumarejo

Certified

Data Analyst

Freelancer | Colombia

Technologies

My Portfolio Highlights

My New Project

Analyzing Unicorn Companies

Analytical wordsmith, crafting stories with data as the pen and curiosity as the ink.

My Work

Take a look at my latest work.

project

Analyzing Unicorn Companies

SQL
project

Analyzing Students' Mental Health

SQL
course

Case Study: Analyzing Customer Churn in Tableau

Tableau

My Certifications

These are the industry credentials that I’ve earned.

Data Analyst Associate

Data Analyst Associate

SQL Associate

SQL Associate

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

ForUsAll | Feb 2024 - Jul 2024

Operations Analyst | ETL | Fivetran | Mode Analytics | Project Management

• Define and implement KPIs to track the Operations team's progress. • Created advanced Mode dashboards and complex queries • Managed the ETL process to import data from various sources via Fivetran, uploading it to Snowflake for analysis and visualization in Mode • Created personalized GPT to support the operations team in compliance questions • Lead the reconciliation project from beginning to end covering 99% of Forusall's clients. • Managed daily operations and client interactions entirely in English, collaborating effectively with diverse teams
Show More

Alegra | Dec 2021 - Mar 2024

Business Intelligence Team Lead | AWS | Storytelling | Pricing | Board presentations

• Lead a 4 members team focus on business analytics following SCRUM methodology with Asana. • I pioneered the creation of annual pricing reviews based on inflation and product growth, leading to the largest ARR increase in Alegra’s history—a 13% boost through a strategic pricing change. • Built and mantained SaaS metrics dashboards in Amazon QuickSight and Data Studio, through a data warehouse in Amazon RedShift. • Developed and delivered monthly and quarterly board presentations covering key business metrics across Sales, Finance, Growth, Product, and SaaS development. • Managed CRM tools like HubSpot, and extract information from Google Analytics to analyze growth through SEO and SEM. • Forecasted revenue and users growth using machine learning and forecasting techniques. • Provided multiple insights to support decision making and OKR's planning.

Alegra | Mar 2021 - Dec 2021

Lead Financial Analyst

Defining KPIs, building dashboards, and collaborating with the product team to enhance the memberships platform, while implementing automations to optimize collections processes."

Ecopetrol | Aug 2020 - Feb 2021

Engineer intern

Developed an incident recovery system and Power BI dashboard for organizational learning at Ecopetrol, automating insights collection and visualization with Power Apps and SharePoint.

My Education

Take a look at my formal education

Bachelor's degree, Chemical engineeringUniversidad de los Andes - Colombia | 2021
Bachelor's degree, Industrial engineeringUniversidad de los Andes - Colombia | 2021

About Me

Sebastian Pumarejo

Data Analyst with 4+ years of experience in SaaS. Skilled in BI tools, Python, and machine learning. Passionate about storytelling with data, optimizing products, and creating impactful dashboards to drive business insights and growth.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free