Senior Power BI Architect (Hybrid)

Aubay Portugal; Porto; Hybrid; EUR 50,000 - 70,000; Full time

Benefits offered by this job

Training Academy and mentoring

Comprehensive health insurance incl.-d

Team events and well-being initiatives

Language platform with courses

Job summary

Aubay Portugal in Porto is seeking an experienced BI/Analytics professional to design and maintain Power BI dashboards, data models, and reports. You will optimize SQL queries, implement advanced DAX calculations, and ensure robust data solutions across the Microsoft BI stack.

You will work in a hybrid model, collaborating with cross-functional teams, refining data architectures, and guiding junior developers. Proficiency in English is mandatory, with French as a valuable asset.

Qualifications

• 8+ years in BI, data analytics, or data engineering with Microsoft BI stack.
• Expertise in writing and tuning complex SQL, including CTEs and joins.
• Strong DAX knowledge for time intelligence and filtering contexts.
• Fluent English; French is a strong asset.

Responsibilities

• Design, build, and maintain enterprise Power BI dashboards, reports, and data models.
• Write and optimize highly complex SQL queries to extract data from various sources.
• Design historical data extraction queries using dynamic date parameters and time-series logic.
• Create and optimize advanced DAX calculations for business logic.
• Troubleshoot dashboard performance, refresh times, and underlying SQL queries.
• Provide technical guidance, conduct code reviews, and mentor junior/mid-level developers (N4).

Skills

Power BI

SQL

DAX

Power BI Service

English

French

Tools

Power BI Desktop

Power BI Service

Job description

Aubay Portugal in Porto is seeking an experienced BI/Analytics professional to design and maintain Power BI dashboards, data models, and reports. You will optimize SQL queries, implement advanced DAX calculations, and ensure robust data solutions across the Microsoft BI stack.

You will work in a hybrid model, collaborating with cross-functional teams, refining data architectures, and guiding junior developers. Proficiency in English is mandatory, with French as a valuable asset.