Available for remote work · Open to relocation-free international roles

Data that gets executed, not just presented.

Data Analyst focused on statistically validated analysis — every notebook below runs end-to-end and gets checked against the underlying data before a finding ships. If a conclusion doesn't hold up, it doesn't go in the report.

Portrait of Carlos Crespo Smith
Carlos Crespo Smith Data Analyst · Remote
11projects executed & verified
0.05significance threshold, applied consistently
5+ yrscross-industry analytical experience
100%remote-ready
Selected work

Every card below is a claim I can defend.

Filter by discipline. Each project links to a fully executed notebook — real outputs, not narrated screenshots.

Statistical Validation Bar chart comparing Mann-Whitney U p-values for conversion rate versus revenue per order, showing conversion is statistically significant while revenue is not.

Showz: A/B Testing & Hypothesis Prioritization

Does a new feature actually help the business, or does it just look good on paper? This project ranked which ideas to build first, then proved one of them lifted sales by nearly 19% — while catching a second "win" that turned out not to be real.

PythonSciPyICE/RICE
BI & Financial Modeling ARPU comparison bar chart: Ultimate plan at $72.31 versus Surf plan at $60.71 average revenue per user.

Megaline: Tariff-Plan Profitability

Which phone plan actually makes the company more money? This project rebuilt the billing math from scratch to find out — and caught an earlier assumption about which region performed best that turned out to be backwards.

PandasSciPyt-test
Market Research Box plot and bar chart showing trip duration increases 21.4% under adverse weather conditions in Chicago.

Chicago Mobility: SQL + Weather-Impact

Does bad weather really slow down rides, or does it just feel that way? This project proved it does — trips take 21% longer — giving a new rideshare company real numbers to plan pricing and driver availability around.

SQLPandasLevene
BI & Financial Modeling
−$8.29 Loss per user, misallocated channel

Showz BI: Marketing ROI & Unit Economics

Where should the marketing budget actually go? This project traced revenue back to each ad channel and found one was quietly losing money while another was the real growth driver — redirecting spend toward what works.

PandasCohort AnalysisLTV/CAC
BI & Financial Modeling
34.72% Platform traffic in a 2-day window

Instacart: Market Basket & Retention

When do customers come back, and when are they about to leave for good? This project mapped shopping habits across millions of orders to find the exact window to reach out before a customer churns.

PandasSeabornCohorts
Statistical Validation
38% Funnel drop-off point isolated

FoodFlow: A/A/B Funnel Validation

Did a small design change actually change customer behavior, or was it a coincidence? This project tested it properly and confirmed the change was safe to ship — protecting the team from reading too much into random noise.

SciPyBonferroniFunnel
Market Research
r=0.40 Critic score → sales correlation

Ice Online Store: Global Game Sales

What actually makes a video game sell — great reviews, the platform, the region? This project compared sales across markets and genres to guide which titles to stock ahead of the holiday season.

SciPyRegional Segmentation
Foundations
$9,189 CLV modeled, 10 accounts, core Python

Advanced User Data Processing & Segmentation

Which customers are worth the most over time, and who deserves VIP treatment? This project built that picture from raw customer records using only core problem-solving, no pre-built shortcuts.

PythonData Structures
Foundations
8 Defensive ETL phases built

DQA: Data Quality & User Profile Structuring

Messy, inconsistent customer data is unusable data. This project cleaned and standardized a real-world user database so it could actually be trusted for analysis.

PythonETL
Foundations
61,253 Streaming records analyzed

Urban Music Consumption: Two-City Study

Do people in different cities listen to music differently by day and time? This project compared two cities to find out — useful for deciding when and where to run ads.

PandasHypothesis Testing
Live App
50K+ Listings in an interactive dashboard

US Used Vehicles: Streamlit Dashboard

How much is a used car really worth based on its mileage? This interactive tool lets anyone explore 50,000+ real listings to see how value drops off — and where the resale sweet spot sits.

StreamlitPlotly
Toolkit

What actually built the work above.

🐍 Python 🐼 Pandas 📐 SciPy 🗄️ SQL 📊 Tableau 📈 Power BI 📗 Excel 🧪 Jupyter 🎈 Streamlit
Get in touch

Looking for a Data/BI Analyst who verifies before they present.

Open to remote roles on US/Canada-aligned time zones. Let's talk.