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. I'm now transitioning fully into data analytics, completing both a B.S. in IT and a hands-on Data Analytics Bootcamp while building a project portfolio across Excel, SQL, Tableau, Power BI, and Python.

🎯 Actively seeking Data Analyst and Business Intelligence roles where I can apply both fintech domain expertise and growing technical skills to drive 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
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 Video walkthrough coming soon
  • 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

Additional work currently in development across SQL, Tableau, Python, and R.

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
Tableau · Sports Analytics
NBA Season Performance Analysis
In progress
Business question: Which players deliver the most value relative to their role, and how do team strategies differ across the league? Full season dataset visualized using stacked bar charts, heatmaps, treemaps, and bubble charts in Tableau.
TableauSports AnalyticsDashboards
In progress
Python · Industrial Analytics
Mining Process Quality Analysis
In progress
Business question: What process variables most affect iron concentrate purity, and can we predict quality from operational inputs? Real plant data across 6 months analyzed with Pandas, NumPy, and Matplotlib.
PythonPandasIndustrial Analytics
In progress
R · People Analytics
Employee Attrition Analysis
In progress
Business question: Why are employees leaving, and which factors most predict attrition? Analysis of 1,470 employee records using R, including correlations, scatterplots, boxplots, hypothesis testing, and linear regression.
RPeople AnalyticsStatistical Analysis
In progress
Experience & Education

Background & Training

7+ years in fintech operations, currently completing a B.S. in IT and building hands-on analytics experience through portfolio work.

📊
2026 · In Progress
Data Analytics Bootcamp
Data Analytics Accelerator (DAA)
🎓
Final Course in Progress
B.S., Information Technology
Western Governors University (WGU)
Mar 2023 to Mar 2024
Bilingual Financial Support Analyst
FinTech | Seattle, WA
  • Analyzed transactional, billing, and settlement data using 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