Analytics Engineer (dbt / SQL) vs Business Intelligence (BI) Lead: Salary & Career Benchmarks in Spain

In Spain, Business Intelligence (BI) Lead roles typically command a higher median salary than Analytics Engineer (dbt / SQL) positions. According to our 2026 live benchmark data, a mid-level Business Intelligence (BI) Lead earns a median salary of €50K, whereas a Analytics Engineer (dbt / SQL) brings in roughly €44K (a gap of €6K at the median).

Seniority, tech stack, and location all move this gap. Senior practitioners in either discipline can exceed the upper range through specialist skills. See the skills premium section below for the specific certifications and tools that push offers to the top of the range.

While both positions are vital to a modern tech organisation, Analytics Engineer (dbt / SQL) and Business Intelligence (BI) Lead have fundamentally different daily workflows.

Analytics Engineer (dbt / SQL) focuses primarily on transforming raw data into trusted, business-ready datasets using dbt modelling layers and semantic logic. Day-to-day work revolves around writing and testing dbt models, maintaining data catalogues, defining shared metric logic with analysts, and enforcing data quality checks across the warehouse.

Business Intelligence (BI) Lead focuses on leading an organisation's business intelligence function, setting reporting and dashboarding strategy, and managing the analysts and developers who build it. Their time is spent setting BI tooling and data-modelling standards, reviewing dashboard and reporting requests for priority, mentoring BI developers and analysts, and presenting key business metrics to leadership.

Transitioning between these two paths is achievable but requires targeted upskilling.

Moving from Analytics Engineer (dbt / SQL) to Business Intelligence (BI) Lead:

Moving from Business Intelligence (BI) Lead to Analytics Engineer (dbt / SQL): Data analysts with strong SQL and a working knowledge of dbt are the most natural fit, since the role sits at the intersection of engineering and analysis.

Neither path requires starting from scratch. Professionals in both roles share underlying technology fluency; the gap is usually domain knowledge and specific tooling rather than core engineering fundamentals.

In Spain in 2026, both roles are seeing demand, but with different drivers.

Analytics Engineer (dbt / SQL) demand is very high, particularly in Data platform teams inside Madrid banks and Barcelona scale-ups, led by employers such as BBVA and Glovo, with Agencia Tributaria's own data modernisation programme adding public-sector demand. Business Intelligence (BI) Lead demand is high, concentrated in Spanish banks and retailers consolidating fragmented BI reporting into a single governed function, led by employers such as BBVA and Inditex.

Workspace flexibility significantly impacts total compensation value in Spain.

Analytics Engineer (dbt / SQL) roles score 68% on our remote-friendliness index (High). This is because model-building and data-pipeline work is largely asynchronous and tool-driven, though Spanish employers outside Madrid and Barcelona still lean toward a hybrid schedule of two to three office days. Where in-office attendance is required, it is typically driven by cross-functional data modelling discussions and stakeholder alignment sessions, and Spanish employers in Madrid's banking sector tend to formalise this into a fixed hybrid schedule.

Business Intelligence (BI) Lead roles score 55% (Moderate). BI strategy and tooling work can largely be done remotely, though Spanish employers outside Madrid and Barcelona still lean toward a hybrid schedule of two to three office days is the primary driver of flexibility. When office days are required, it is usually for executive reporting sessions and cross-team prioritisation still pull leads into the office regularly, and Spanish employers in Madrid's banking sector tend to formalise this into a fixed hybrid schedule.