LIS · Lisbon

Data analyst · Lisbon, Portugal

Tiago
Castro

I build the dashboards and reports a finance team runs on, and I check the data under them. Power BI, SQL, dbt, Snowflake. Nine years as cabin crew before that.

See the work GitHub
PartidasDepartures
Lisbon
Next departure: a Data Analyst, BI Analyst or Power BI Developer role in Lisbon, hybrid or remote.

Flight path

Percurso
Gate01

Twenty years drawn to scale. The top lanes are work, the bottom lane is study. Where they overlap, the degree and the postgraduate diploma were done while working full time.

Career and study timeline, 2003 to 2026Aviation 2012 to 2021, finance 2021 to 2023, compliance data 2023 to 2026, data and controlling at Siemens from 2026. Bachelor's degree 2020 to 2023 and postgraduate diploma 2024 to 2025 overlap with full-time work.

Boarding passes

Trabalho na Siemens
Gate02

Four projects from my work at Siemens. Internal system names are left out; the numbers are real.

Baggage claim

Projetos pessoais
Belt03

Things I built on my own time. Most are live and open in the browser, and each one says when its data is fictional. Filter by type.

Itinerary

Experiência
Gate04
  1. ArrivedLISApr 2026

    Digital Transformation Analyst & Financial Controller Trainee Now

    Siemens · Alfragide, Lisbon · Hybrid · Apr 2026 to now

    • Own and maintain a suite of Power BI dashboards and the recurring reports financial controllers depend on, modeling SAP and internal planning data through Snowflake, dbt, SQL and SQL Server.
    • Run the monthly cash flow and income statement reporting cycle for a profit center end to end: SAP extraction, Excel preparation, Power BI refresh and publication, distribution.
    • Took over the reporting of an internal cost allocation application when its owner left the team: the reports, the user access process and the allocation key master data.
    • Built a software license comparison report over IT asset management data, with duplicate detection and missing-field pages.
    • Work between finance and IT: gather what controllers need, build it, and walk them through it. Use Power Automate, Office Scripts and Copilot to remove manual steps.
  2. Jul 2023LISApr 2026

    KYC Data Officer

    BNP Paribas · Lisbon · Hybrid · Jul 2023 to Apr 2026

    • Ran KYC recertification reviews for the Luxembourg branch, opening each case with database checks and a gap analysis against existing client records.
    • Verified FATCA, AEOI and MiFID documentation, and maintained scoring grids, activity data and ownership structures in internal systems.
    • Worked a portfolio of mostly investment funds, with every file reviewed by a second analyst before closing.
  3. EntrySNTOct 2021

    Financial Analyst

    AZN Portugal · Sintra · Oct 2021 to Jun 2023

    • Ran financial operations as lead analyst for a vending machine distribution company: budget control, forecasting and cash flow tracking.
    • Analyzed the cost structure line by line and renegotiated terms with the main suppliers, lowering unit costs on the highest-volume lines.
  4. 2012 to 2021CDGPDL · DE

    Flight Attendant, long haul and short haul

    Norwegian (Paris CDG) 2018 to 2021 · Ryanair (Germany and Azores) 2012 to 2018

    • Nine years of cabin crew across three countries, on transatlantic Boeing 787 routes and European short haul, working to EASA procedures and in English every day.

Earlier: back-office complaint management at the Customer Ombudsman Office of Portugal Telecom / TMN (2010 to 2012); junior financial markets analyst at Metello & Seabra (2006 to 2008); store assistant at TMN (2009 to 2010); owner and manager of a family retail business (2004 to 2011); IT support intern at Lisbon City Council (2006).

Hand luggage

Ferramentas e formação
Gate05

Tools Carry-on

Reporting & BI
Power BI (DAX, Power Query, field parameters, TMDL), Excel, end-user enablement
Data
SQL (T-SQL, profiling), SAP data extraction, Snowflake, Microsoft Fabric, dbt, star schema modeling, data quality and reconciliation
Analysis
Python (Pandas, NumPy), statistics, outlier and multicollinearity analysis, TypeScript (Office Scripts)
Automation
Power Automate, Microsoft Copilot and Copilot Studio, SharePoint, Azure, Git, Jira

Education Checked

  • Postgraduate Degree, Data Science & Business AnalyticsISEG Executive Education, Lisbon · Apr 2024 to Apr 2025Done while working full time
  • Bachelor's Degree, Business Management & AdministrationUniversidade Europeia, Lisbon · Sep 2020 to May 2023Done while working full time
  • IT Systems Management Technician (EQF Level 4)Escola Profissional de Tecnologia Digital · 2003 to 2006

In-flight entertainment

Tempos livres
Seat26A

What I do off duty. Six channels, no ads.

Now showing · off dutyChannel 01
Channel 01

Family walks

Weekend walks with the family. The best crew I have ever flown with.

Channel 02

Travel

Nine years flying for work, and I still plan trips for fun. Window seat, always.

Channel 03

Padel

Small court, long rallies, and a scoreboard I never have to reconcile.

Channel 04

Movies & series

Usually one more episode than planned. I stay for the credits.

Channel 05

Reading

A book, a coffee and the phone in another room.

Channel 06

Gadgets

If it has a firmware update, I have probably already installed it.

Headphones available on request

Now boarding

Looking for Data Analyst, BI Analyst or Power BI Developer roles in Lisbon, hybrid or remote, where the work sits between a finance or operations team and its data.