Power BI Developer

ITDS; Porto; Hybrid; EUR 55,000 - 75,000; Full time

Job summary

ITDS in Porto, Portugal, offers a hybrid work model as a Senior Power BI Developer role focused on enterprise dashboards and data modeling for a leading banking group. You will drive strategic insights and build robust BI solutions end-to-end.

The role requires 8+ years in BI/Data Analytics, expert SQL and DAX skills, strong Power BI ecosystem knowledge, and a PL-300 or equivalent certification is preferred. You will mentor juniors and contribute to governance and performance improvements.

Qualifications

• 8+ years in BI/Data Analytics with MS BI stack.
• Expert SQL skills: CTEs, joins, subqueries, aggregations.
• Advanced DAX knowledge with time intelligence.
• Strong Power BI ecosystem skills: Desktop, Service, gateway, RLS, workspaces.

Responsibilities

• Design, build, and maintain enterprise Power BI dashboards, reports, and data models.
• Write and optimize advanced SQL queries to extract and analyze data from diverse sources.
• Develop time-series SQL queries for historical data retrieval.
• Integrate custom parameters into SQL within Power BI to improve performance.
• Author and optimize complex DAX calculations and time intelligence measures.
• Troubleshoot performance and ensure efficient dashboard refreshes.
• Provide guidance, code reviews, and governance for junior/mid developers.

Skills

Power BI

SQL

DAX

Time intelligence

Data modeling

Education

Microsoft Certified Power BI Data Analyst Associate (PL-300)

Tools

Power BI Desktop

Power BI Service

Power BI Gateway

RLS

Workspace management

Job description

Unleash data-driven innovation — craft impactful dashboards that transform enterprise decision-making!

Porto-based opportunity with hybrid work model.

As a Senior Power BI Developer, you will be working for our client, a leading banking group, focused on developing enterprise-level financing applications. You will help build sophisticated dashboards and data models that enable strategic insights and drive financial success. Join a team committed to pushing the boundaries of Business Intelligence and shaping the future of banking analytics.

Your main responsibilities:

• Design, build, and maintain enterprise Power BI dashboards, reports, and data models aligning with business needs.
• Write and optimize advanced SQL queries to extract, manipulate, and analyze data from diverse source systems.
• Develop dynamic SQL queries for historical data retrieval using time-series logic and date filters.
• Integrate custom parameters into SQL within Power BI to enhance data load performance.
• Author, optimize, and maintain complex DAX calculations, implementing advanced time intelligence and nested measures.
• Troubleshoot and tune report performance, ensuring efficient dashboard refreshes and query execution.
• Provide technical guidance, code reviews, and best practices to junior and mid-level developers, fostering team excellence and governance.

You're ideal for this role if you have:

• Minimum of 8 years of experience in Business Intelligence, Data Engineering, or Data Analytics, with a strong focus on Microsoft BI Stack.
• Mastery of SQL, including CTEs, subqueries, JOINs, UNIONs, and aggregation functions.
• Expert-level DAX skills, capable of complex business logic implementation.
• In-depth understanding of Power BI ecosystem: Desktop, Service, gateway, RLS, and workspace management.
• Microsoft Certified Power BI Data Analyst Associate (PL-300) or similar certification (preferred).

It is a strong plus if you have:

• Proficiency in French to collaborate with French-speaking stakeholders.

Eligibility to work on this role:

• Only candidates with an existing legal right to work in Portugal will be considered.