You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Juan D.JD

Juan D.

Data Engineer at Microsoft Fabric

€650/day
Madrid, ES
8-15 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Juan

I design and build data platforms in Microsoft Fabric from end to end: ingestion, Lakehouse, transformation, semantic model, and reporting in Power BI.
I work with companies that are at one of these three points:

They have data spread across Excel, SQL Server, SaaS, and on-premise, and need a single platform where the business trusts the numbers.
They are coming from Synapse, Databricks, or a legacy stack and want to modernize to Fabric without breaking what already works.
They have slow Power BI, duplicated models, or pipelines that break on Monday mornings, and need a clean architecture behind it.

How I work
I start by understanding the business case before touching the tool. I define the architecture (medallion: bronze / silver / gold), build the ingestion and transformation (Pipelines, Dataflows Gen2, Spark, SQL), and deliver a semantic model in Power BI on which the business can confidently exploit data. All code lives in Git, with tests and CI/CD when the project justifies it.
My background
10+ years in data: 7 at Thales (Engineering, Transport) and 3 at Millicom (telco), designing data models, optimizing Power BI, and leading migrations to Azure. Certified in Azure Data Engineer Associate (DP-203) and Microsoft Fabric Data Engineer (DP-700).
Types of projects that fit well

Design and implementation of a Fabric platform from scratch (4-12 weeks)
Migration from Synapse or other DWH to Fabric
Audit and redesign of Power BI models with performance issues
Design of the transformation layer (medallion + dbt or native Spark/SQL)

I can design a workflow with agents to increase the productivity of BI analysts and developers.

I can also design workflows with agents based on Hermes at a very low operational cost.

I also have experience building Generative AI applications on corporate data (RAG, conversational agents on BI models).
  • Spanish

    Native or bilingual

  • English

    Fluent

  • French

    Basic

Remote only
Primarily works remotely

Experience

  • Millicom
    Analytics | LLM Engineer
    TELECOMMUNICATIONS
    March 2023 - Today (3 years and 5 months)
    Madrid, Spain
    Design and maintenance of the corporate analytics platform on Azure Synapse and Power BI, serving business stakeholders in finance, sales, and operations.
    Migration of the reporting tool to Power BI: redesign of the semantic model, optimization of DAX, and consolidation of scattered reports into a single reliable model.
    Advanced data modeling in Azure Synapse with SQL and PySpark, ensuring consistency between the cloud DWH and on-premise systems.
    Requirements gathering with stakeholders, KPI definition, and go-live of projects in production.
    Design and development of Generative AI applications on corporate data: Conversational BI (DuckDB + LangGraph + dbt + Streamlit with open source LLMs) and contract manager with RAG (ChromaDB + Streamlit).
    Project lifecycle management in Azure DevOps, including performance testing in Power BI Service.
    Microsoft Azure Python Microsoft Power BI LLMs Langchain
  • THALES
    Analytics Engineer
    AVIATION AND AEROSPACE
    November 2015 - February 2023 (7 years and 3 months)
    Madrid, Spain
    Integration of on-premise data to Azure: design of pipelines and normalization in the corporate DWH.
    Design and optimization of data models for BI and advanced analytics with PySpark, SparkR, and SQL.
    Development of dashboards in Power BI (DAX, Power Query) and advanced tabular modeling with Tabular Editor and DAX Studio.
    RStudio SQL Power BI DAX Power Query
  • Nokia
    Project Procurement Manager
    TELECOMMUNICATIONS
    February 2013 - October 2015 (2 years and 9 months)
    Madrid, Spain
    Use and optimization of various tools in coordination with IT: IBM Emptoris, SAP Netweaver, SAP BPP, etc.
    Selection, motivation, and approval of new suppliers for each product family.
    Management of preferred supplier audits: Supplier Risk Assessment, Supplier Business Review, Scorecard, etc.
    Periodic reports identifying savings opportunities or other actions that improve project profitability.
    Procurement Management SAP MM SAP S/4HANA

Recommendations

Be the first to recommend Juan

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Degree in Physics-Chemistry
    UCLM
    2002
  • MBA
    ISTP BUSINESS SCHOOL
    2010

Certifications

Skill set

Categories