Aitor Guzmán Cantón

Sole responsible for the BI and data platform of Femxa. Designed and implemented the entire data infrastructure using Microsoft Fabric following a Lakehouse architecture with a Medallion approach (Bronze, Silver and Gold layers). Developed ingestion pipelines with Copy Data, transformation logic with Notebooks, and semantic models using Direct Lake. Built end-to-end Power BI reports fully connected to the Fabric Lakehouse, covering the complete data lifecycle.

Additionally, worked on a BI governance and deployment project for Elecnor, implementing a versioning strategy using Azure DevOps and Power BI Pipelines. Configured separated Development and Production workspaces connected through deployment pipelines, ensuring controlled releases, traceability and enterprise-grade BI governance.

Worked as Data Engineer on projects for clients such as Hipra and Etnia, designing data systems and pipelines using Azure Data Factory and developing database objects with SQL Server Management Studio. As BI Consultant, delivered end-to-end Power BI solutions for private companies and public administrations including Almirall, Castanyer, Diputació de Girona and Agència Catalana del Turisme.

Led internal initiatives focused on Power BI governance, including the development of a deployment and versioning framework using Azure DevOps and PowerShell. This solution supported multiple environments (Development, Test, Production and Self-Service) and improved release reliability and collaboration. Worked in international teams with stakeholders from the USA and Germany.

Worked full time on an HP project maintaining and developing Power BI reports. Developed a Python-based machine learning proof of concept to predict printer failures, gaining hands-on experience in data science and predictive analytics within a real business context.