Open to opportunities

Nicolas Ruiz Buitrago

@nicolasruizbuitrago

Message

I’m a data analyst turning SQL , Excel and Power BI into actionable business insights.

Colombia

Message

What I'm looking for

I’m looking for a role where I can build SQL + Power BI dashboards, automate data workflows, and validate data quality—turning complex datasets into clear decisions for stakeholders with measurable impact.

I’m a data analyst with 2+ years of combined experience across the energy, financial, and digital marketing sectors. I work hands-on with SQL, Power BI, and Excel to validate data quality and turn complex datasets into clear, actionable insights for business stakeholders.

I’ve built dashboards and reports that drive decisions, automating data workflows and communicating findings effectively across technical and non-technical audiences. Highlights include process automation delivering up to 25× efficiency gains, and consolidating 19,036 records into 1,396 canonical items—a 92.7% reduction in redundancy that improved data governance and traceability.

In recent roles, I delivered end-to-end BI solutions, executive dashboards, and automated reporting processes for operational performance monitoring. I bring a strong bias toward measurable impact—improving visibility, reducing validation time, and supporting high-stakes business and compliance outcomes through reliable data.

Experience

Work history, roles, and key accomplishments

Current

Digital Media Buyer

Current

Within CO Functions

Apr 2026 - Present (2 months)

Conduct daily spend analysis across client accounts to identify performance trends and reallocate budgets toward higher-yield opportunities. Designed and automated budget allocation models for key accounts (Movado, The Container Store) to deliver clear recommendations for non-technical stakeholders.

Spend Analysis SQL Data Automation Data Analysis Performance Metrics Resource Optimization

Data & Performance Dashboard Analyst

Frontera Energy

Jan 2026 - Apr 2026 (3 months)

Built end-to-end BI solutions in Power BI to track operational and management KPIs using DAX and Power Query. Developed executive dashboards and automated recurring reporting to improve leadership visibility through continuous performance monitoring.

Power BI DAX Power Query BI dashboards Data Modeling KPI Reporting SQL Data Visualization

Environmental Compliance Analyst

Ecopetrol S.A.

Jun 2025 - Jan 2026 (7 months)

Led a data integration initiative consolidating 19,036 records into 1,396 canonical items using SQL, improving data governance for environmental compliance and multi-billion COP contracts. Automated cross-database validation workflows (SAP ERP/Excel/SharePoint) to reduce validation time from 75 to 3 minutes (~25×).

SQL Data Integration Data Governance Power Query Advanced Excel VBA Data Validation IDEAM Crosswalk

Junior Consulting Analyst

Financial Group Javeriana

Feb 2021 - Dec 2024 (3 years 10 months)

Conducted market surveillance using Bloomberg and built consulting cases using structured quantitative analysis. Supported financial intelligence initiatives and analysis projects using data-driven methodologies.

Quantitative Analysis Financial Modeling Data Analysis Reporting Problem Solving

Commercial Data Analyst

Bancóldex

May 2024 - Aug 2024 (3 months)

Optimized CRM and leasing-related databases (OnBase, Si-Leasing) to support sales tracking and reporting. Automated recurring reports, reducing operating time by 80% and exceeding the team BI KPI by 60%, and delivered training sessions that achieved 4.5/5 NPS.