# Juan Compte Alvaredo

Juan Compte Alvaredo is a remote worker on Himalayas, Data & BI Engineer at Assertia Solutions, based in Spain.

Source: https://himalayas.app/@juan-compte-alvaredo

```text
Data & BI Engineer at Assertia Solutions building Microsoft Fabric platforms and column-level lineage.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | Spain |
| Authorized to work in | Spain, Argentina, Uruguay |
| Salary expectations | 55k-70k EUR |
| Job categories | Business Intelligence Engineer, Business Intelligence Consultant, Business Intelligence Architect, Data Consultant, SQL Server Developer, Data Analyst, Data Engineer, Business Intelligence Analyst, Analytics Engineer |
| Skills | Data Engineering, Business Intelligence, Data Warehouse, Data Pipelines, ETL ELT, Data Orchestration, Data Modeling, Kimball Dimensional Modeling, Medallion Architecture, SCD2, Change Data Capture, Column Level Lineage, Data Governance, Data Quality Testing, Row level security |
| LinkedIn | https://linkedin.com/in/juan-compte-alvaredo |

## What I'm looking for

```text
Busco una empresa con una cultura de datos sólida que valore la innovación, donde pueda aportar mi experiencia en BI y seguir desarrollando mis habilidades en tecnologías emergentes.
```

## About

```text
Ingeniero de BI y Analítica con más de 7 años de experiencia en el diseño y desarrollo de plataformas de datos modernas. Especialista en el ecosistema de Microsoft (Azure, Fabric, Power BI) y con experiencia práctica en la integración de soluciones de Machine Learning e Inteligencia Artificial en entornos empresariales.

Logros Clave:

Optimización Financiera: Implementación de Net Revenue Retention (NRR) mediante la asignación precisa de hechos a través de dimensiones para un análisis de rendimiento efectivo.

Eficiencia Operativa: Desarrollo de un visual personalizado que integró el sistema de tickets de soporte con los informes, mejorando el tiempo de resolución en un 2x.

Innovación en IA: Creación de un pipeline RAG NLP-to-SQL y un modelo de detección de cuentas duplicadas para Salesforce, mejorando la integridad de los datos.

Enfoque en el Cliente: Experiencia en la recopilación de requisitos de stakeholders, análisis de procesos de negocio y capacitación de usuarios para asegurar la adopción de nuevas herramientas.

Intereses: Busco roles que me permitan combinar la ingeniería de datos tradicional con el desarrollo de productos de IA y Machine Learning, ayudando a las empresas a tomar decisiones basadas en datos de manera más rápida y precisa.
```

## Experience

### Data & BI Engineer (current)

Assertia Solutions. Jul 2025 - Present

```text
Built an agentic extraction pipeline for actuarial valuation workbooks, engineered column-level lineage data model, and architected a Dynamics 365 to Power BI data platform with SCD Type 2 and RLS.
```

Skills: SQL-Server, Fabric, Model-Context-Protocol-(MCP), Azure-Data-Factory, Databricks, RLS-Policies, SQL, Power-BI, Dynamics-365, Microsoft-Fabric, DAX, (M), Unity-Catalog, Dataverse, SSIS, Git, Azure-DevOps, CI-CD, REST-APIs, Power-Automate, Microsoft-Fabric-Dataflows-Gen2, Fabric-Pipelines, Fabric-Copy-Job, Databricks-Jobs, ETL-ELT, CDC, Python, Spark, PySpark, KQL, MDX, Power-Query-(M), PowerShell, Kimball-Dimensional-Modeling, SCD2, Medallion-Architecture, Watermark-Incremental-Loads, Data-Quality-Testing, Row-level-security, PII-Masking, Column-Level-Lineage, Power-BI-REST-API, Lineage-API, OneLake-Catalog-API, Fabric-REST-API, Fabric-CLI, Microsoft-Purview, Agentic-AI-workflows, Claude-Code, Cursor, MCP-Servers, Vector-Databases

### Data & BI Consultant

ClearPeaks. May 2025 - Jul 2025

```text
Developed a cross-departmental Power BI dashboard embedded in a website for workforce analytics, ensuring GDPR compliance through PII masking and row-level security, and integrated multiple Databricks data sources.
```

Skills: Power-BI, Databricks, GDPR, PII-Masking, Row-level-security, Data-Integration, Dashboard-Development, Data-Normalization

### Senior Data & BI Consultant

Coal Intelligence LLC. Sep 2024 - Mar 2025

```text
Migrated Power BI dashboards from SQL Server to Azure and automated recurring reporting pipelines using SQL and Python.
```

Skills: Power-BI, SQL-Server, Azure, SQL, Python, Automation, ETL, Report-Automation

### Business Intelligence Architect

[Consumer Affairs](https://himalayas.app/companies/consumeraffairs). Aug 2021 - Aug 2024

```text
Led migration of analytical warehouse from Redshift to Snowflake, built transformation layer in dbt and Airflow, and designed event-driven orchestration and notification system.
```

Skills: Snowflake, DBT, Airflow, Redshift, Tableau, Slack, Data-Modeling, ETL, Orchestration, A-B-Testing, Data-Quality, Data-Warehouse, SQL, Python, Lineage-Tracking

### Business Intelligence Consultant (Ssr.)

[Western Union](https://himalayas.app/companies/western-union). Nov 2020 - Aug 2021

```text
Optimized high-volume ETL pipelines processing 20-40M records/day, built a payment-reminder integration with Mercado Pago, and A/B tested notification lead time.
```

Skills: ETL, Qlik-Sense, SCD2, Data-Integration, A-B-Testing, SQL

### Business Intelligence Consultant

[Western Union](https://himalayas.app/companies/western-union). Nov 2020 - Aug 2021

```text
Optimized high-volume ETL pipelines processing 20-40M records/day with Qlik Sense and SCD2 logic. Built a payment-reminder integration between Western Union and Mercado Pago, and A/B tested notification lead time.
```

Skills: Qlik-Sense, ETL, SCD2, SQL, A-B-Testing, Data-Integration, MercadoPago-API

### BI Analyst Jr.

Agencia de Administración de Bienes del Estado. Feb 2020 - Nov 2020

```text
Developed SSIS ETL pipelines and maintained the data warehouse design serving four business areas.
```

Skills: SSIS, ETL, Data-Warehouse, Data-Warehouse-Design

### SQL Server Developer Trainee

Ministerio de Obras Públicas y Transportes. Jun 2019 - Dec 2019

```text
Trainee role developing SQL Server solutions.
```

Skills: SQL-Server

## Education

### Microsoft

Microsoft Certified: Fabric Analytics Engineer Associate, Data Analytics

```text
Earned the Microsoft Certified: Fabric Analytics Engineer Associate certification in August 2026, valid through August 2027.
```

### Databricks

Generative AI Fundamentals, Artificial Intelligence

```text
Earned the Generative AI Fundamentals certification from Databricks in August 2026.
```

### University of Buenos Aires

MEng, Chemical Engineering

```text
Completed coursework for the MEng in Chemical Engineering in 2021, with thesis pending.
```

### University of Buenos Aires

BEng, Chemical Engineering

```text
Earned a BEng in Chemical Engineering from the University of Buenos Aires in 2016.
```

## Tech stack

- Amazon Redshift
- Snowflake
- Azure Synapse
- Apache Spark
- Tableau
- QlikView
- GitHub
- Azure Pipelines
- PySpark
- dbt
- Microsoft SQL Server
- Databricks
- Slack
- Microsoft Teams
- Azure Stack
- Azure DevOps
- Python
- PowerShell
- Microsoft PowerApps
- Azure SQL Database
- TypeScript
- Git
- Airflow
- Microsoft Power Automate
- Microsoft Power BI
- SQL
- Cursor
- Microsoft Fabric
- Model Context Protocol (MCP)
- Unity Catalog
- Claude Code
- Microsoft Purview
- Power BI

To contact Juan, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Aida Benito](https://himalayas.app/@aidabenito): Artificial Intelligence Engineer, Independent Project
- [Maarten van Reek](https://himalayas.app/@maartenvanreek): Advanced BI Developer, Visma
- [Pablo Martin Alberti](https://himalayas.app/@pablomartinalberti): Tech Lead / Senior Tech Engineer, Santander Tecnología
- [Sebastián Pons](https://himalayas.app/@sebastianpons): Senior BI & Data Consultant, Nortal
- [Edgar Martinez](https://himalayas.app/@edgarmartinez1): BI Data Analyst/Data Engineer, Ayesa Digital
- [Araceli Menchaca](https://himalayas.app/@aracelimenchaca): Ingeniería de Datos, Avan
- [Alexi Ledesma](https://himalayas.app/@alexiledesma): Data Migration , JBK
- [Federico Klix](https://himalayas.app/@federicoklix): Data Architect, Get Staffed Up
- [Diego Otero](https://himalayas.app/@diegootero): Jefe de Arquitectura Big Data, Telefónica
- [Luis Rodriguez](https://himalayas.app/@luisrodriguez11): BI Developer / Data Analyst, Cuantico ERP
