Oscar Lopez, Business Intelligence Developer in Barcelona

> About

> Hi! My name is Oscar, and I'm a Business Intelligence Developer based in Barcelona, Spain. Here's my story:

Oscar Lopez corporate portrait

Business Intelligence Developer

  • Location: Barcelona, Spain
  • Focus: BI & Analytics
  • Experience: 5+ years in Tech

> I design and develop Business Intelligence solutions that turn operational data into reliable, actionable insights. My work covers the full path from data transformation and modelling to KPI logic, semantic models and final dashboard delivery.

> I work mainly with Power BI, Domo and SQL, and have experience across Power Query, Databricks and Azure Analysis Services. I focus on building reporting solutions that are technically sound, understandable and reliable.

> My current work is focused on contact center and workforce management analytics, including productivity, SLA, AHT, CSAT, NPS, forecasting and operational performance. I also enjoy troubleshooting the difficult parts: granularity, filter context, relationships, aggregations and complex BI architectures.

> I started my IT career in Level 2 support, where I built a strong foundation in systems, troubleshooting, automation and user-focused problem solving. That technical background now shapes how I approach data and BI development.

> Outside of my main role I have been building and maintaining things since 2020, from a WordPress and WooCommerce e-commerce for a local RV rental company to the self-hosted homelab I have been running since 2021.

> Tech Stack

> The tools and disciplines I use to move from raw data to business-ready insights.

BI & Analytics

Power BI Domo Data Visualization KPI Development Reporting Business Analytics

Data

SQL DAX Power Query / M Data Modelling ETL / ELT Data Transformation

Data Platforms

Databricks Dremio Azure Analysis Services SQL Server DirectQuery Composite Models

Engineering

Databricks Notebooks Data Quality Domo Magic ETL PowerShell Git

> Experience

> Here is a little bit of what I did until now:

Summary

Oscar Lopez Conde

Business Intelligence Developer with hands-on experience designing and maintaining reporting solutions across Power BI and Domo mainly for contact center and workforce management operations, covering data transformation, modelling, KPI development and dashboard delivery directly to client. Strong background in enterprise IT support provides a strong technical foundation across systems and infrastructure.

  • Barcelona, Spain

Education

> Computer Engineering for Management and Information Systems

2019 - 2022

TecnoCampus, Mataró

Studies covering computer engineering, information systems and business management.

Earlier Experience

> Freelance Full Stack Developer

Nov 2020 - Oct 2025 · Remote

El Bon Camí · La Garriga, Spain

Designed, developed and maintained the website of a local camper and motorhome rental business, working directly with the owners.

  • Built and maintained the site with WordPress, WooCommerce, Elementor, HTML, CSS and JavaScript
  • Implemented online bookings, card payments, shopping cart and customer account pages
  • Improved site structure, usability and overall user experience
  • Applied performance and SEO improvements to increase search visibility

> Philips Sales Representative

2021 - 2022

Barcelona, Spain

Specialized in high-end Philips televisions at El Corte Inglés Diagonal, combining product expertise, consultative selling and customer relationship management.

  • Achieved top salesperson recognition in 2021 doubling the previous year's sales
  • Sold 100+ televisions in a highly competitive retail environment
  • Built relationships with hundreds of customers and recommended products based on their needs
  • Earned additional incentives through performance on challenging product categories

Professional Experience

> Business Intelligence Developer

Feb 2024 - Present · Hybrid

Barcelona, Spain

Design, build and maintain Business Intelligence solutions for contact center and workforce management analytics across multiple client environments in Spain and the EMEA region.

  • Develop end-to-end BI solutions covering data transformation, semantic modelling, KPI development and dashboard delivery using Power BI and Domo
  • Build advanced DAX measures, Power Query transformations and analytical data models for complex reporting requirements
  • Design and maintain Domo pipelines using Magic ETL, DataFlows, Beast Mode and SQL
  • Develop and optimize SQL queries and data transformations across multiple enterprise data sources
  • Work with Databricks and Azure Analysis Services within enterprise BI architectures
  • Develop analytical solutions covering productivity, SLA, AHT, CSAT, NPS, forecasting and operational performance
  • Collaborate directly with clients to translate evolving business needs into usable dashboards and actionable KPIs
  • Troubleshoot complex BI issues involving granularity, aggregations, relationships, filter context, DirectQuery, Composite Models and Analysis Services connectivity

> Service Desk Systems L2 Technician

Oct 2022 - Feb 2024 · On-site

Barcelona, Spain

Provided Level 2 technical support across enterprise hardware, software and infrastructure, building the technical foundation for a transition into data and BI development.

  • Troubleshot enterprise hardware, software and systems issues
  • Managed Active Directory administration, user provisioning and system access
  • Used PowerShell for task automation and systems management
  • Applied a structured, user-focused approach to diagnosing and resolving technical problems

> Projects

Home Assistant

Homelab

Self-Hosted Infrastructure
Personal Portfolio project preview

Personal Portfolio

Static Web
El Bon Camí e-commerce website preview

El Bon Camí

E-Commerce Web

> Contact

> Open to opportunities, collaborations, and interesting projects!

Location:

Barcelona, Spain

Meeting:

Schedule a Meeting