Sample document — fictional candidate for illustration purposes only. Your CV is prepared from your own record.
Professional Summary
Data Analyst with 2 years of experience at Santander Spain, turning raw transactional and customer data into actionable reporting and dashboards. Skilled in SQL, Python, and Power BI, with a focus on automating repetitive analytical workflows to free up stakeholder time for decision-making. Comfortable working across finance, marketing, and operations teams.
Key Metrics
12 hrs/wk
Saved via report automation
3
Monthly reports fully automated
40%
Reduction in ad-hoc data requests
6
Live Power BI dashboards owned
Technology Stack
SQL
Python
pandas
Power BI
DAX
Excel
Azure Data Studio
Git
Confluence
Experience
Santander España, Madrid
- Business question: Could manual monthly reporting be eliminated for the retail credit team? Approach: Audited 3 existing Excel reports, rewrote them as parameterised SQL queries feeding a Power BI service dataset. Outcome: Eliminated 12 hours of analyst time per week across the team.
- Business question: Which customer segments were at highest churn risk in Q4 2024? Approach: Built a cohort analysis in Python using 18 months of transaction history and modelled early-warning signals with logistic regression. Outcome: Retention campaign targeted 4,200 at-risk customers; 31% conversion rate on re-engagement offers.
- Business question: Why were branch managers submitting duplicate data-quality tickets? Approach: Traced root cause to mismatched column mappings in the ETL job; patched the transformation and added a reconciliation check. Outcome: Duplicate ticket volume fell 94% in the following cycle.
- Maintained and documented 6 production Power BI dashboards used by 80+ business users in retail banking operations.
Santander España, Madrid
- Business question: How could the ops team track SLA compliance in near-real time? Approach: Designed a Power BI dashboard pulling from Azure SQL with 15-minute refresh; added conditional formatting alerts for breached SLAs. Outcome: Average SLA breach response time dropped from 4.2 hours to 47 minutes.
- Wrote and maintained 20+ SQL stored procedures supporting monthly regulatory reporting submissions to Banco de España.
- Supported A/B test analysis for 2 product campaigns; communicated results to non-technical stakeholders via structured slide decks.
Additional Skills
- Statistical analysis & hypothesis testing
- Data cleaning & wrangling
- Dashboard design & UX
- Stakeholder communication
- Agile / Jira
- Spanish (native), English (C1)
Education
BSc Statistics
Sep 2019 – Jun 2023
Universidad Carlos III de Madrid — GPA 8.4/10, Honours mention in Statistical Computing