Senior Data Analyst (Power BI)

TL;DR

Senior Data Analyst (Power BI): Building and optimizing enterprise BI solutions in Portugal with an accent on Power BI architecture, advanced DAX and Power Query, SQL performance, and dimensional modeling. Focus on designing Kimball-based data warehouses, solving complex data transformation challenges, and delivering reliable analytics for client projects.

Location: Hybrid in Porto, Portugal

Salary: €28,000–€52,000 per year

Company

hirify.global is a Portugal-based IT consulting partner with 18 years of experience, delivering technology guidance and solutions for clients.

What you will do

• Architect and deploy end-to-end enterprise Power BI solutions.
• Build advanced DAX measures, including time intelligence and performance-optimized calculations.
• Develop complex M and Power Query transformations for data preparation.
• Write and optimize advanced SQL queries using joins, CTEs, and window functions.
• Design data warehouse models based on Kimball methodology, including star schemas, fact tables, and dimension tables.
• Support challenging client projects and collaborate with experienced consulting teams.

Requirements

• 6+ years of professional experience in data analytics.
• Senior-level expertise in architecting and deploying enterprise Power BI solutions.
• Advanced knowledge of DAX, evaluation context, time intelligence, and performance tuning.
• Advanced Power Query and M transformation skills.
• Expert SQL skills and deep practical knowledge of dimensional modeling and Kimball methodology.
• Professional English and availability for hybrid work in Porto, Portugal.

Culture & Benefits

• No-term full-time employment contract.
• Health insurance and 22 paid vacation days.
• Four additional annual days for Carnival, Christmas Eve, New Year's Eve, and the employee's birthday.
• Meal allowance on a Coverflex card, referral bonus, discounts, and flexible options.
• Annual training budget and opportunities to grow through challenging projects.
• People-centered, team-oriented culture within an international company.