Open to opportunities

Francisco Marambio Correa

@franciscomarambiocor

I lead data engineering and BI initiatives—turning requirements into reliable ETL, data warehouses, and executive analytics.

Chile

Message

What I'm looking for

I’m looking to lead data projects end-to-end—requirements, ETL/data warehouse delivery, and Power BI executive reporting—while ensuring quality, traceability, and operational continuity. I want to apply SQL, Python, and applied machine learning to support decision-making.

I’m a Master’s in Computer Engineering–trained Data Project Lead with more than 13 years of experience in data, BI, information integration, and corporate analytics platforms. I specialize in leading data projects in business environments, from requirements gathering through implementation of integration, automation, Data Warehouse, and executive reporting.

I coordinate with business areas and technical teams to prioritize initiatives and ensure quality, traceability, information availability, and operational continuity. I’m especially strong in advanced SQL and database performance work, including stored procedures, window functions, indexing, and execution plan analysis for optimized processing.

On the engineering side, I design and maintain ETL pipelines with SSIS—implementing incremental loads, multi-source integration, logging, error handling, and operational troubleshooting. I also modernize analytics platforms with Power BI (dashboards, DAX, KPI monitoring) and Python for analytical automation and applied machine learning forecasting/categorization.

In recent work, I led corporate data projects end-to-end, including Data Warehouse improvements with orchestration via SQL Server Agent, and automated reporting for faster decision-making. In featured ETL modernization, I reduced overnight processing time by 40% while improving operational traceability.

Experience

Work history, roles, and key accomplishments

Current

Data Project Lead & BI Engineer

Current

Ecomac Chile

Jan 2019 - Present (7 years 6 months)

Led corporate data projects covering requirements gathering through delivery of data integration, automation, Data Warehouse, and executive reporting. Designed ETL pipelines (SSIS), optimized SQL Server performance, automated Power BI dashboards, and supported forecasting/categorization initiatives using Python and machine learning.

BI Systems Analyst

Caja Los Andes Chile

Jan 2018 - Jan 2019 (1 year)

Integrated and transformed data from multiple sources using Oracle 11g, SAP Data Services, and SQL. Built Power BI and SAP BO dashboards to track commercial KPIs and support decision-making.

Data Integration data transformation SAP Data Services SQL Power BI DAX Dashboarding SAP BI BO KPIs

Systems Analyst

Universidad De Los Andes Chile

Jan 2016 - Jan 2018 (2 years)

Developed executive dashboards, institutional data analysis, and report automation for academic and administrative teams. Supported process improvement initiatives through requirements gathering, analysis, and ensuring information availability.

Institutional Data Analysis Report Automation Requirements Gathering Data Analysis Process Improvement

Database Programmer Analyst

Samsung Electronics Chile

Jan 2014 - Jan 2016 (2 years)

Designed and maintained SSIS packages and SQL Server databases/queries for internal data integration and reporting processes. Supported business users by maintaining operational information and providing technical support for internal data workflows.

SSIS SQL Server SQL Queries Data Integration Internal Reporting Technical Support Operational Support

IT Analyst

Areadigital Ltda.

Jan 2013 - Jan 2014 (1 year)

Provided IT infrastructure support, performed basic network administration, and resolved operational incidents. Supported day-to-day operations for internal systems and services.

IT Infrastructure Support Network Administration Incident resolution