Looking for a job

Santiago Ponce

@santiagoponce

Message

Business Intelligence Analyst and Reporting Lead delivering scalable insights with Power BI and SQL.

Japan

Message

What I'm looking for

I’m looking for a role where I can deliver scalable BI and reporting that turns data into clear, actionable decisions—partnering with stakeholders and continuously improving data pipelines, dashboards, and performance.

I deliver actionable insights through scalable reporting and business intelligence. I’m a Business Intelligence Analyst with 3+ years of experience bridging business needs with technical solutions to drive performance.

In my most recent role as Reporting Lead, I led a cloud-scale analytics migration by moving 100+ production reports from GCP to Azure, improving system stability and reducing query latency through redesigned data pipelines and optimized Power BI semantic models. I also enhanced performance monitoring with usage tracking and resource optimization, and I supported continuous improvement by creating structured feedback loops between business users and data teams.

Earlier, I built and maintained data pipelines by integrating heterogeneous data sources using SQL and Python, with automated validation checks. I contributed to campaign optimization by developing predictive audience segmentation and improved forecast reliability by analyzing uncertainty drivers, while translating complex analytics into transparent dashboards for non-technical stakeholders.

Experience

Work history, roles, and key accomplishments

Reporting Lead (BI)

MetLife Chile

Jun 2024 - Oct 2024 (4 months)

Led a cloud analytics migration moving 100+ production reports from GCP to Azure, improving system stability and reducing query latency by redesigning data pipelines and Power BI semantic models. Implemented usage tracking and resource optimization to enhance performance monitoring and established feedback loops between business users and data teams.

Power BI DAX Google BigQuery SQL Data Pipelines Performance Monitoring Product Usage Tracking

Campaigns Analyst (BI)

ProVida AFP

Oct 2021 - May 2024 (2 years 7 months)

Built and maintained data pipelines integrating heterogeneous sources using SQL and Python, with automated validation checks. Optimized campaigns by developing predictive audience segmentation, improved forecast reliability by reducing variance between predicted and observed outcomes, and delivered transparent dashboards for non-technical stakeholders.

SQL Python Power BI Data Pipelines Time Series Analysis Forecasting Dashboarding

Credit and Market Risk Analyst

Banchile Inversiones

Jan 2021 - Jun 2021 (5 months)

Monitored fixed and variable income portfolios using risk alerts and management/board-set limits, supporting investment strategies through credit risk, liquidity, and FX position analysis. Maintained compliance with internal risk thresholds and assisted with market monitoring.

SQL R Power BI Excel Credit Risk Analysis Investment Controls

Teaching Assistant (BI)

Universidad de Chile

Jun 2019 - Mar 2020 (9 months)

Supported undergraduate Business Intelligence instruction focused on applied data analysis and machine learning. Facilitated practical sessions using RStudio and helped students with semester-long projects covering decision trees, support vector machines, and neural networks, translating predictive results into business optimization scenarios.

Business Intelligence RStudio Machine Learning Decision Trees Neural Networks Data Analysis Student Mentoring Performance Evaluation