Ignacio de Pablo
Data Analyst

Ignacio
de Pablo

Financial and operational data analyst with 7+ years of fintech experience.

I turn complex datasets into clear business insights using SQL, Excel, Tableau, Power BI, and Python. My background combines hands-on analytical work, stakeholder communication, and real operational context.

Portfolio projects built with real datasets and business-focused analysis.

7+ Years in fintech
$50M+ Monthly settlement volume analyzed
12,000+ Merchant portfolio exposure
View Featured Project → Browse All Projects Download Resume
Focus Area
Data Analytics and BI
Core Stack
SQL, Excel, Tableau, Power BI, Python
Target Roles
Data Analyst and BI Analyst
Location
Seattle, WA
About Me

The story behind the data

I'm Ignacio, a data analyst based in Seattle. For 7+ years I worked inside fintech operations at a payment processing company, managing a portfolio of 12,000+ merchants, building financial reports that informed leadership decisions, and analyzing transactional data to identify revenue leakage and operational risk across $50M+ in monthly settlement volume.

That work taught me the most valuable skill in data: understanding what decision a stakeholder needs to make, and building the analysis backwards from there. That pull is what made me go deeper, pairing a B.S. in Information Technology with an intensive Data Analytics Bootcamp, and now an incoming M.S. in Data Analytics, while building a portfolio across SQL, Excel, Tableau, Power BI, and Python.

Actively seeking Data Analyst and Business Intelligence roles where I can pair fintech domain expertise with a growing technical toolkit to support data-informed decisions.

Outside of work, I love practicing fencing, watching good cinema, being an amateur space nerd, and spending time with my family.

7+ Years in FinTech
B.S. Information Technology
5+ Tools in Stack
2x Bilingual EN / ES
Certifications, click to verify
CompTIA Security+ CompTIA Network+ CompTIA A+ PMI CAPM ITIL 4 Foundation AWS Cloud Practitioner Google IT Support Linux Essentials
In progress: Microsoft Power BI Data Analyst (PL-300), exam July 2026
Tech Stack

Tools & Technologies

The tools I use to collect, clean, analyze, and visualize data.

SQL
Writing queries to extract, filter, and aggregate data, from simple lookups to multi-table joins and complex subqueries.
JOINsSubqueriesCTEsAggregationsWindow Functions
Excel
Data cleaning, transformation, and analysis, from formulas and pivot tables to automated workflows with macros.
PivotTablesXLOOKUPVLOOKUPPower QueryMacrosConditional Formatting
Power BI
Building interactive dashboards and reports with calculated measures, data modeling, and visual storytelling.
DAXData ModelingInteractive ReportsVisualizationsGrowing
Tableau
Interactive dashboards, KPI tracking, scatter plots, bar charts, area charts, and data storytelling.
DashboardsKPIsCalculated FieldsStorytelling
Python
Learning data manipulation and visualization through real bootcamp projects using industry-standard libraries.
PandasNumPyMatplotlibData CleaningIn Progress
Web Development
Basic front-end skills used to build and maintain portfolio projects and simple web interfaces.
HTML5CSS3JavaScript
Projects

Selected Projects

Finished portfolio work across Excel, SQL, and Tableau, each built around a real business question.

Food Delivery Customer Analysis
Excel · Marketing Analytics
Food Delivery Customer Analysis
  • Business question: What drives customer spending, and which campaigns perform best?
  • Tools: Excel, PivotTables, correlation analysis, and charting.
  • Key finding: Income explains 67% of spending variation, and discount-heavy campaigns underperform for high-value segments.
ExcelCustomer SegmentationCorrelation Analysis
Read Write-up ↗
Massachusetts Public Schools Dropout Analysis
Tableau · Data Visualization
Massachusetts Education Dashboard
  • Business question: Which schools are underperforming, and across what metrics?
  • Tools: Tableau, scatter plots, KPIs, bar charts, area charts, and calculated fields.
  • Key finding: Performance gaps are visible across 1,800+ schools and 100+ metrics, surfacing outliers at a glance for stakeholders.
TableauData VisualizationKPI Reporting
View Dashboard ↗
What Happened to $1.76 Billion in World Bank Funding?
SQL · Financial Analysis
What Happened to $1.76 Billion in World Bank Funding?
  • Business question: The World Bank committed $1.76B to Myanmar. How was that money distributed, what changed across political periods, and where did it all end up?
  • Tools: MySQL, aggregations, filtering, and period analysis on 55 Myanmar records from the World Bank IDA global dataset (11,171 records, March 2026).
  • Key finding: Lending shifted significantly across political periods, with cancellations targeting broad priorities rather than isolated projects.
SQLWorld Bank IDAMyanmarFinancial Analysis
Read Write-up ↗
View in-progress projects ↓
In Progress

Upcoming Projects

Active work currently in development, with finished write-ups added as each project wraps.

Databricks · BI Platform
AZIMUTH — Launch Market Intelligence Platform
Featured · In progress
Business question: Where does a new heavy-lift rocket realistically stand against the field? An end-to-end data platform tracking how the global launch market is evolving — cadence, reliability, reuse, and mass to orbit — built on a Databricks lakehouse with a dbt star schema, data-quality tests, and an interactive dashboard.
DatabricksdbtPythonPlotly
In progress
SQL · Healthcare Analytics
Hospital Readmission Analysis
In progress
Business question: Are we treating patients equitably, and what drives length of stay? Analysis of 101,000+ real patient records using advanced SQL, including JOINs, CASE WHEN, CTEs, window functions, and histograms.
SQLHealthcare AnalyticsMySQL
In progress
Experience & Education

Background & Training

7+ years in fintech operations, now fully focused on data analytics through a degree, a bootcamp, an incoming master's, and hands-on portfolio work.

Completed · June 2026
B.S., Information Technology
Western Governors University (WGU)
Admitted · Fall 2026
M.S., Data Analytics (Data Engineering)
Western Governors University (WGU)
Mar – Jun 2026
Data Analytics Bootcamp
Data Analytics Accelerator (DAA)
Mar 2023 to Mar 2024
Bilingual Financial Support Analyst
FinTech | Seattle, WA
  • Analyzed transactional, billing, and settlement data using SQL and Excel across a 12,000+ merchant portfolio representing $50M+ in monthly settlement volume
  • Built recurring KPI dashboards and financial reports in Excel and Tableau, giving leadership data-driven visibility into portfolio health and trends
  • Reduced average case resolution time by 25% through structured root cause analysis and workflow optimization
  • Served as primary success partner for 900+ Spanish-speaking merchants, driving retention and satisfaction
Dec 2016 to Mar 2023
Bilingual Customer Success Engineer
FinTech | Seattle, WA
  • Founded and scaled the Spanish-language merchant program from ~250 to 900+ accounts, contributing to a 20% reduction in churn
  • Analyzed support metrics and trends using Excel to identify performance gaps and drive continuous improvement
  • Managed ~30 complex merchant interactions per day across POS systems, billing disputes, and PCI compliance
  • Trained and mentored 4 bilingual agents, developing onboarding materials and quality frameworks
Resume
Download PDF
Languages
EnglishFluent
SpanishNative
Seeking
Seeking Data Analyst and Business Intelligence Analyst roles in Seattle or remote, especially where fintech, operations, or reporting experience is valued.
Contact

Let's connect

I'm actively exploring Data Analyst and Business Intelligence roles. If you're working in data or hiring for these roles, I'd love to connect.

Whether you want to discuss a project, share feedback on my work, or explore how my fintech background could add value to your team. Feel free to reach out.

Email
idepabloc@gmail.com
LinkedIn
linkedin.com/in/idepabloc
Tableau Public
Ignacio de Pablo
GitHub
github.com/idepablo