Turning messy data
into decisions companies trust.
I'm Lorenzo Ruffino, a Business Intelligence Analyst building the dashboards, models and pipelines that C-level teams actually use. I handle data end-to-end, from pipelines to visualization.
I transform complex data into strategic insight — and decisions that stick.
As a BI Analyst, I specialize in turning raw information into assets that fuel decision-making for multinational teams. I design data models, build the dashboards executives live in, and automate the reporting that used to eat entire afternoons, so the companies I work with make sharper, faster, better-informed decisions.
My work sits at the intersection of analytical rigour and clear communication, whether that's a star schema in Snowflake, a dbt pipeline integrating HubSpot and Google Ads, or a 1500-word feature on Italian demographics illustrated with charts I built myself.
The toolkit — what I reach for first.
Data modeling & SQL
01 / 04- SQL Core
- dbt Cloud
- Snowflake
- Amazon Redshift
Visualization & BI
02 / 04- Tableau Core
- Power BI
- Lightdash
- Figma
Languages & analysis
03 / 04- R
- Python
- Econometrics
- Statistical modeling
Methods & collaboration
04 / 04- Agile / Scrum Certified
- Requirements gathering
- Stakeholder management
- International team collaboration
Five years across BI consulting, medtech, edtech — and now a career platform.
Apr 2026 — Present
Remote
Current
Data Analyst
CareerMinds Full-time · Career & outplacement
- Joined the Data team at a company focused on careers, jobs and outplacement services.
- Currently working on the data integration of the B2B outplacement arm into the company's analytics stack — consolidating sources, mapping the domain, and building a foundation for cross-business reporting.
Nov 2024 — Apr 2026
Remote
Business Intelligence Analyst
GoStudent Full-time · Edtech
- Owned and continuously optimized the company's primary acquisition dashboard, used by C-level executives and Directors for strategic decision-making.
- Maintained and developed 20 marketing dashboards in Tableau and Lightdash providing real-time visibility into campaign performance and customer acquisition metrics.
- Built complex dbt models in SQL integrating HubSpot, Google Analytics and internal platforms to calculate key business KPIs, with dbt tests ensuring data consistency.
- Led the data integration of Studienkreis & Lernquadrat (group companies) into GoStudent's analytics ecosystem — requirements gathering, reverse engineering of existing reports, seamless consolidation.
- Managed the marketing attribution model, resolving data quality issues and integrating new acquisition channels.
- Developed a Strategy & Finance dashboard tracking actual vs. target across 30+ key business metrics (acquisition, retention, finance).
- Optimized trial-to-paid conversion by identifying high-performing tutor demographics and designing a lead-routing strategy based on conversion probability.
Dec 2023 — Sep 2024
Remote
Business Intelligence Developer
Edwards Lifesciences Full-time · Medtech
- Core member of an international Scrum team within the Enterprise Data & Analytics department.
- Developed and maintained Tableau and Power BI dashboards focused on sales performance and cost control, serving 2,000+ users organization-wide.
- Collaborated with international stakeholders to align reporting needs with business objectives.
- Architected optimized star-schema data models with row-level security in Snowflake, maintaining sub-5-second load times.
- Ensured data quality by investigating and resolving discrepancies between native systems and Snowflake.
Feb 2022 — Nov 2023
Turin
Business Intelligence Consultant
Visualitics Full-time · BI consulting
- Key member of a BI team for a multinational pay-TV client.
- Developed a 12-month ARPU (Average Revenue Per User) calculation model in SQL, integrating Siebel and Salesforce, for accurate future revenue estimates.
- Created and managed 70+ customized Tableau reports for middle management and executives — a comprehensive sales performance platform.
- Automated 15+ previously manual reports, reducing an entire team's workload by 15+ hours per week.
- Conducted in-depth analysis of business requirements and processes to generate actionable, decision-supporting insights.
Economics-first, with a heavy statistics & econometrics backbone.
Sep 2019 — Jul 2021
University of Turin
MSc in Economics · English-taught
Relevant coursework: Mathematical Economics, Statistical Inference, Econometrics II, Microeconomic Analysis, Computer Science with Python, Numerical Methods in Economics.
Sep 2016 — Jul 2019
University of Turin
BSc in Economics & Commerce
Relevant coursework: Econometrics and Applied Statistics, Financial and General Mathematics, Computer Tools for Economic Research, Statistics, Introduction to Stata.
Data journalism — in public, for Italian audiences.
A weekly newsletter providing the facts and data you need to understand the news.
Original analysis and bespoke data visualizations, delivered every week to a growing readership of data-curious readers. Read it at lorenzoruffino.it.
American news for an Italian audience.
Editor & editorial coordinator. Daily in-depth articles on US politics and current affairs, an automated poll tracker built in R, a 7:00 AM press review, and cross-platform publishing automation on n8n (Facebook, X, Bluesky, Telegram, WhatsApp). Also manage the website — internal tools for content organization and Umami analytics.
Economic & social articles, illustrated with charts.
Long-form, data-driven articles covering Italian economic and social issues. Every claim paired with a chart, produced in-house.
Infographics on politics, demography & society.
Five years contributing infographics and feature articles — covering elections, generational demographics and society at large. Built in R and Figma.
Working across two languages — every day.
Italian
Native
English
Full professional proficiency
Let's turn some
data into decisions.
Always happy to talk data, dashboards, visualization, modeling and the stories numbers (and a good data article) can tell.