lucagdeluca.com

Business intelligence · Data engineering · Analytics

Luca Deluca

Focus

What the current work consists of.

domain_01

Data platforms

Ingestion and transformation on Microsoft Fabric: Data Factory pipelines, Lakehouses and Warehouses, SQL, Python and PySpark. Incremental and full-load strategies for large tables, and keeping pipelines dependable when the source systems are not.

domain_02

Models and reporting

Power BI semantic models, dimensional modelling and DAX. Models that follow how the business actually runs, and that stay fast and understandable as they grow.

domain_03

BI governance

How an organisation catalogues, owns and documents its reports and datasets, so that people can tell which numbers to trust and whom to ask about them.

Experience

Energy, luxury goods, consumer goods and life sciences, in Brazil, Italy and Switzerland.

period
May 2026 – Present
location
Switzerland
sector
Life sciences and laboratory technology

Hamilton

Business Intelligence Data Engineer

Enterprise BI and data engineering on the Microsoft data platform. I build and maintain the ingestion, transformation and modelling layers behind company reporting, and take part in deciding how the wider analytical environment is organised and governed.

  • Data Factory pipelines in Microsoft Fabric, loading Lakehouses and Warehouses from enterprise applications, including Microsoft Dynamics 365.
  • Incremental and full-refresh loading strategies for tables with tens of millions of records, and keeping those pipelines reliable when source systems are limited or inconsistent.
  • Transformation in SQL, Python and PySpark.
  • Power BI semantic models, DAX and reporting.
  • BI governance: cataloguing reports and datasets, defining ownership, documenting analytical assets, and making it clear to users which reports and datasets they can rely on.
period
Sep 2023 – Apr 2026
location
Italy
sector
Luxury goods · Supply chain and logistics

Kering

Worldwide Transportation Performance Analyst / Data Scientist

I joined to analyse the performance of the group's worldwide transportation and logistics operations. Over time the role became steadily more technical, moving through data science, data engineering and BI development: from analysing operational performance to designing the data structures used to analyse it.

  • Performance analytics and KPIs for global transportation and logistics.
  • Power BI dashboards, data models and DAX, including reporting performance and model optimisation.
  • ETL/ELT and data transformation in SQL, Python and PySpark, including work on Microsoft Fabric.
  • Bringing together complex operational data from multiple sources, with attention to quality, standardisation and consistency.
  • Working with business stakeholders to turn operational requirements into technical solutions.
period
2020 – 2022
location
Brazil · Remote (global)
sector
Energy

ExxonMobil

Trainee / Analyst

Analytical work inside a large multinational: business processes, operational reporting and performance management. This is where I first saw how information moves through an enterprise organisation and how it supports operational decisions.

  • Reporting and analysis supporting business activities.
  • Work on business processes and performance management.
Earlier roles
ElectroluxInternWorked with data in a controlling environment, an early look at how a multinational measures and reports on its own performance.2019Brazil
TranslucBusiness / Administrative AssistantAutomated parts of day-to-day business processes, the start of an interest in process automation that has stayed with me.2018 – 2019Brazil
Hi TechnologiesInternMy first professional experience, inside a health sciences and laboratory technology startup.2016Brazil

Toolkit

Grouped by how the tools are used, not by self-rating.

groupitemscontext
Day to day
  • Microsoft Fabric
  • Data Factory pipelines
  • Lakehouses and Warehouses
  • SQL
  • Python
  • PySpark
  • Power BI
  • DAX
  • Power Query
  • Semantic and dimensional modelling
  • ETL / ELT
  • Incremental and full loads
What my current work is built on.
Architecture and governance
  • Medallion architecture
  • Star schemas
  • Data quality and consistency
  • Report and dataset catalogues
  • Data ownership
  • Documentation
  • Reporting standards
  • KPI definition
  • Model performance
The questions around the pipelines and reports.
Also worked with
  • Microsoft Dynamics 365 data
  • Azure DevOps
  • Git
  • Tableau
  • SAP HANA
  • Alteryx
  • AWS fundamentals
From earlier roles, integrations and projects.
Outside work
  • Next.js
  • TypeScript
  • LLMs and AI agents
Independent projects and current study.

Background

Certifications and languages.

I didn't start out as a software engineer. My early roles were in administration, business processes and analysis, first in internships and then as a trainee and analyst at ExxonMobil. At Kering I joined as a transportation performance analyst for the group's worldwide logistics, and over time the work moved steadily towards the technical side: from reading the reports, to building them, to designing the models and pipelines behind them. At Hamilton that technical side is now the job.

Having worked on both sides shapes how I approach data problems. A pipeline can run perfectly and still deliver numbers nobody trusts, and a dashboard can look right while describing the business inaccurately. I care about understanding what the data represents, how it is generated and why someone needs it, and then designing the systems underneath so the analysis stays consistent as requirements change.

Certifications
AWS Certified Cloud Practitioner2023
Google Data Analytics Professional Certificate2023
Languages
PortugueseFluent
EnglishFluent
ItalianAdvanced
GermanLearning

Open questions

What I’m studying and thinking about.

AI and business automation

Studying how AI agents and language models can be applied to real operational processes: how they interact with enterprise systems, APIs and workflows, and how to judge whether a given use is secure, reliable, affordable and properly supervised by people.

Data architecture and governance

The questions above individual implementations: how an analytical environment should be structured, who owns what, how it is documented, and how people know what to rely on.

Independent projects

Building small applications and experiments outside work, mostly to understand new technologies properly, and investigating how software and automation can improve existing business processes.

After hours

Things that don’t belong on a résumé, served through the tools I use at work.

off_hours Mostly outdoors: hiking in the Alps, swimming and cooking Brazilian barbecue. Otherwise chess, rock and trying out new technology for the sake of it.

01 · sql

Query my hobbies

luca.db · query editorSQL
SELECT category, value
FROM hobbies
ORDER BY category;

Press Run to execute the query.

02 · rest

What I'm doing now

api explorerREST
GET/api/v1/luca/now

Send the request to see what I’m up to.

03 · pyspark

Music taste, as a notebook

music_analysis.ipynbPySpark
In [ ]:
df = spark.table("favorite_bands")
display(df.orderBy("rank"))
In [ ]:
display(
    df.groupBy("genre")
      .count()
      .orderBy(F.desc("count"))
)
Illustrative favourites, not an exact ranking.

Writing & projects

all writing · all projects

article6,835 chess games, one dashboardHow I turned my chess.com history into an interactive dashboard: a build-time extract, one fact table at game grain, cross-filtering in the browser, and an opening explorer on a real board.12 November 2026