Senior Business Intelligence Consultant

About the role

Aubay Portugal is seeking a Senior Business Intelligence Consultant to join its technology consultancy team. You will work on data‑driven projects for strategic sectors such as banking, insurance, automotive and more, using a hybrid model based in Lisbon.

Key responsibilities

• Utilise the Microsoft BI ecosystem (SQL Server, SSIS, SSAS, SSRS) to design and maintain data solutions.
• Develop Power BI reports, dashboards and semantic models for business stakeholders.
• Write and optimise SQL queries for data extraction, analysis and reporting.

Required profile

• 5+ years of experience as a Business Intelligence Consultant.
• Fluency in English (mandatory).
• Ability to work on‑site in Portugal two days per week (hybrid model).

Required skills

• Microsoft SQL Server
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• SQL Server Reporting Services (SSRS)
• Power BI and semantic modelling
• Advanced SQL for data querying
• Dimensional modelling (Kimball methodology)

What we offer

• Comprehensive health insurance with dental coverage.
• Performance feedback system and structured career progression.
• Access to Aubay Training Academy (technical and behavioural courses, webinars, mentoring).
• Team‑building events and a digital platform for mental‑health support.
• Family benefits such as a Mini‑Aubilous Kit for newborns and annual school‑supply support.
• Language platform offering conversation classes in 12 languages.