Senior BI & SQL Performance Specialist (Hybrid Lisbon/Porto)

Closer Consulting; Lisboa; Hybrid; EUR 60,000 - 90,000; Full time

Job summary

Closer Consulting is seeking a Senior BI/SQL Performance Specialist to join our hybrid team in Lisbon or Porto. You will optimize SQL performance, design dimensional models, and work with Power BI and Tabular Models on enterprise data warehouses.

The role requires 7+ years in BI/Data Warehousing, strong SQL/T-SQL skills, and experience with ETL, Git, and data modeling. English proficiency is mandatory due to international collaboration.

Qualifications

• 7+ years in BI Development, Data Warehousing or similar.
• Deep expertise in SQL/T-SQL: writing, analyzing, and troubleshooting complex queries and stored procedures.
• Proven SQL performance optimization: execution plans, indexing strategies, query tuning.
• Solid mastery of data modeling: dimensional modeling, star schemas, fact/dimension design.
• Hands-on experience with enterprise Data Warehouse environments, analytical models, Tabular Models, and cubes.
• Familiarity with Power BI, DAX fundamentals, and ETL processes.
• Proficiency with Git for version control and best development practices.
• Strong communication skills in English for international banking projects.

Skills

BI Development

Data Warehousing

Data Engineering

SQL Performance

Data Modeling

Power BI

DAX

ETL

Git

English Communication

Tools

Power BI

DAX

ETL

Job description

Closer Consulting is seeking a Senior BI/SQL Performance Specialist to join our hybrid team in Lisbon or Porto. You will optimize SQL performance, design dimensional models, and work with Power BI and Tabular Models on enterprise data warehouses.

The role requires 7+ years in BI/Data Warehousing, strong SQL/T-SQL skills, and experience with ETL, Git, and data modeling. English proficiency is mandatory due to international collaboration.