Sergio Nicolás Ortiz Barreto

Data Engineer

Power Digital Marketing

Jun 2025 - Current (1 year 5 months)

helped me get this job

Business Intelligence Engineer

Convatec

Jun 2024 - Jun 2025 (1 year 1 month)

Supported and improved enterprise data infrastructure for a global medical technology company, working across cloud-based ETL and data warehouse technologies.
• Maintained and improved ETL pipelines built with IBM DataStage and dbt, ensuring reliable ingestion, transformation, and loading into a Snowflake-based data warehouse.
• Optimized Snowflake queries and data models, improving performance, scalability, and reporting accuracy.
• Identified and resolved bottlenecks and data inconsistencies, strengthening overall pipeline stability.
• Collaborated with data analysts and stakeholders to align pipelines with evolving business requirements.

Business Intelligence & Analytics Developer

CepoBIA

Sep 2023 - May 2024 (9 months)

Delivered tailored data engineering and BI solutions for clients across retail and manufacturing sectors within a consulting environment.
• Designed and developed ETL pipelines using SSIS and SQL Server to consolidate multi-source data into a centralized Data Warehouse for a large apparel retailer, enabling all business reports to connect to a single source of truth.
• Led migration of legacy QlikView reports to Power BI, restructuring a complex multi-database architecture into a unified, efficient reporting system.
• Built a Power Apps enterprise application for a furniture manufacturer, replacing a costly process-tracking software with a custom solution integrated with Power BI for real-time metrics visualization.

IT & Process Analyst

Natuera

Aug 2022 - Mar 2023 (8 months)

Applied ETL and BI practices to support data-driven decision-making across sales and operations at a cannabis-tech startup.
• Extracted and transformed sales data from vending machines using ETL methodology, building dashboards and reports that established a robust sales funnel.
• Built and enhanced real-time Power BI dashboards for sales, expenses, and operational KPIs, reducing report generation time from days to minutes.
• Developed an Excel VBA tool for end-to-end warehouse and inventory tracking.
• Optimized SQL queries and indexing strategies to improve data warehouse performance.

Data Analyst

Resistencias y Sensores Mandos Industriales

Jan 2021 - Jun 2022 (1 year 6 months)

Introduced data infrastructure and analytics capabilities from the ground up at an industrial components company, enabling data-driven growth.
• Developed Excel VBA systems to manage accounting, sales, supplier tracking, and purchase operations, replacing fully manual processes.
• Built Power BI dashboards visualizing revenue, top products, key customers, and cost structures, contributing to a 2.5x increase in company revenue.
• Identified a market opportunity through data analysis, leading to the successful launch of a new import business line that expanded the company's competitive advantage.

Sergio Nicolás Ortiz Barreto

About

Detail

Timeline

Résumé

Sergio Nicolás Ortiz Barreto

About

Detail

Behavioral traits